Table of Contents

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.

About the Author

Elvis C. Foster is a Professor of Computer Science at Keene State College. He holds a Bachelor of Science (BS.) in Computer Science and Electronics, as well as a Doctor of Philosophy (PhD) in Computer Science (specializing in software engineering and database systems) from University of the West Indies, Mona Jamaica. His research interests include the development as well as evaluation of management support systems for contemporary organizations.

Shripad V. Godbole is an independent database administrator and consultant with more than 20 years of experience in diverse business environments, information infrastructure planning, diagnostics, and administration. He is also the Vice President for Technology Management at State Street Global Advisors, Boston. His qualifications include Bachelor of Science (BS) in Physics, Bachelor of Computer Science (BCS), Master of Science (MS) in Physics with specialization in Electronics, all from Poona University in Pune, India. He is also an Oracle Certified Professional Database Administrator (OCPDBA) and holds a Master of Business Administration (MBA) in Technology Management from University of Phoenix.