Delivering concise, cutting-edge coverage, CONCEPTS OF DATABASE MANAGEMENT, 8e uses real-world cases, examples, and illustrations to give students a thorough understanding of such critical issues as database design, data integrity, concurrent updates, data security, and more. Completely updated to Microsoft Access 2013 standards, the text presents SQL in a database-neutral environment and covers all major topics, including E-R diagrams, normalization, and database design. It provides detailed coverage of the relational model (including QBE and SQL), normalization and views, database administration and management, and more. Advanced topics covered include distributed databases, data warehouses, stored procedures, triggers, data macros, and Web Apps. Ideal for an introductory database course in an information systems, business, or CIS program, CONCEPTS OF DATABASE MANAGEMENT, 8e can be used in varying disciplines by instructors who want database coverage without using a trade book or a large academic book.
Table of Contents
1. Introduction to Database Management.
2. The Relational Model 1: Introduction, QBE, and Relational Algebra.
3. The Relational Model 2: SQL.
4. The Relational Model 3: Advanced Topics.
5. Database Design 1: Normalization.
6. Database Design 2: Design Method.
7. DBMS Functions.
8. Database Administration.
9. Database Management Approaches.
Appendix A: Comprehensive Design Example: Marvel College.
Appendix B: SQL Reference.
Appendix C: "How Do I" Reference.
Appendix D: Answers to Odd-Numbered Review Questions.
Appendix E: Access Web Apps.
Appendix F: Systems Analysis Approach to Information-Level Requirements.