Includes bibliographical references and index.

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.

Gives students a foundation in database design and implementation. Filled with visual aids such as diagrams, illustrations, and tables, this book provides coverage of database design, demonstrating that the key to successful database implementation is in proper design of databases to fit within a larger strategic view of the data environment.

ISIT112