Database Systems: A Pragmatic Approach by Elvis C. Foster

by Elvis C. Foster

Part Preliminary 1. Introduction to Database Systems 2. The Database System Environment Part The Relational Database Model 3. 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 Part 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 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 Part Overview of Selected DBMS Suites 22. Overview of Oracle 23. Overview of DB2 24. Overview of MySQL 25. Overview of Microsoft SQL Server Part 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

Paperback

First published July 16, 2010