Part A: Preliminary Topics:
1. Introduction to Database Systems
2. The Database System Environment
Part B: The Relational Database Model
3. The Relational Model
4. Integrity Rules and Normalization5. Database Modeling and Design
6. Database User Interface Design
7. Relational Algebra
8. Relational Calculus
9. Reflective Look at the Relational Database Model
Part 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
Part D: Advanced Topics
16. Database Administration
17. Distributed Database Systems
18. Object Databases
19. Data Warehousing20. Web-Accessible Databases
21. Using Database Systems to Anchor Management Support Systems
Part E: Overview of Selected DBMS Suites
22. Overview of Oracle
23. Overview of DB2
24. Overview of MySQL
25. Overview of Microsoft SQL Server
Part F: Appendices
26. Appendix 1: Review of Trees
27. Appendix 2: Review of Hashing
28. Appendix 3: Review of Information Gathering Techniques
29. Appendix 4: BNF Syntax for Selected SQL Statements
30. Appendix 5: Sample Exercises and Examination Questions
About the Author: Elvis C. Foster is Associate Professor of Computer Science at Keene State College, New Hampshire. 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 strategic information systems and database systems) from University of the West Indies, Mona Jamaica. Dr. Foster has over 22 years of combined experience as a software engineer, information technology executive and consultant, and computer science educator.
Shripad V. Godbole is an independent database administrator/consultant with over 20 years of experience in diverse business environments, information infrastructure planning, diagnostics, and administration. 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.
