Database Systems: A Pragmatic Approach, 3rd edition

ISBN-13: 9781032202020 / Angielski / Miękka / 2022 / 586 str.

Elvis C. Foster; Shripad Godbole

Opis

This textbook is ideally suited for an undergraduate course in database systems. The discipline of database systems design and management is discussed within the context of software engineering. The student is made to understand from the outset that a database is a mission-critical component of a software system.

Spis treści

Preface. Acknowledgment. Section A PRELIMINARY TOPICS. 1 Introduction to Database Systems. 2 The Database System Environment. Section B THE RELATIONAL DATABASE MODEL. 3 Introducing the Relational Model. 4 Integrity Rules and Normalization. 5 Database Modeling and Design. 6 Database User Interface Design. 7 Relational Algebra. 8 Relational Calculus. 9 Reflective Look at the Relational Database Model. Section C THE STRUCTURED QUERY LANGUAGE. 10 Overview of SQL. 11 SQL Data Definition Statements. 12 SQL Data Manipulation Statements. 13 Logical Views and System Security. 14 The System Catalog. 15 Some Limitations of SQL. Section D ADVANCED TOPICS. 16 Database Administration. 17 Distributed Database Systems. 18 Object Databases. 19 Data Warehousing. 20 Web-Accessible Databases. 21 Using Database Systems to Anchor Management Support Systems. Section E OVERVIEW OF SELECTED DBMS SUITES AND TECHNOLOGIES. 22 Overview of Oracle. 23 Overview of Db2. 24 Overview of MySQL. 25 Overview of Microsoft SQL Server. 26 Other Emerging Database Methodologies. Section F APPENDICES. Appendix 1: Review of Trees. Appendix 2: Review of Hashing. Appendix 3: Review of Information-Gathering Techniques. Appendix 4: BNF Syntax for Selected SQL Statements. Appendix 5: Sample Exercises and Examination Questions. Index.