Database Principles: Fundamentals of Design, Implementation, and Management

PART I: DATABASE CONCEPTS. 1. Database Systems. 2. Data Models. PART II: DESIGN CONCEPTS. 3. The Relational Database Model. 4. Entity Relationship (ER) Modeling. 5. Advanced Data Modeling. 6. Normalization of Database Tables. PART III: ADVANCED DESIGN AND IMPLEMENTATION. 7. Introduction to Structured Query Language (SQL). 8. Advanced SQL. 9. Database Design. PART IV: ADVANCED DATABASE CONCEPTS. 10. Transaction Management and Concurrency Control. 11. Database Performance Tuning and Query Optimization. 12. Distributed Database Management Systems. 13. Business Intelligence and Data Warehouses. PART V: DATABASES AND THE INTERNET. 14. Database Connectivity and Web Technologies. PART VI: DATABASE ADMINISTRATION. 15. Database Administration and Security. ONLINE APPENDICES. Appendix A: Designing Databases with Visio Professional: A Tutorial. Appendix B: The University Lab: Conceptual Design. Appendix C: The University Lab: Conceptual Design Verification, Logical Design, and Implementation. Appendix D: Converting the ER Model into a Database Structure. Appendix E: Comparison of ER Model Notations. Appendix F: Client/Server Systems. Appendix G: Object-Oriented Databases. Appendix H: Unified Modeling Language (UML). Appendix I: Databases in Electronic Commerce. Appendix J: Web Database Development with ColdFusion. Appendix K: The Hierarchical Database Model. Appendix L: The Network Database Model. Appendix M: Microsoft Access Tutorial.