Gain a thorough, applied understanding of critical database issues with Starks/Pratt/Last's CONCEPTS OF DATABASE MANAGEMENT, 9E. Real cases, examples and screenshots in this concise presentation help clarify database design, data integrity, normalization, concurrent updates, data security, and big data. Completely updated to SQL Server 2016, Microsoft® Access 2016, and Office 365 standards, this edition explores SQL in a database-neutral environment while addressing E-R diagrams, normalization, and database design. Detailed coverage presents the relational model (including QBE and SQL), normalization and views, database administration and management. You also examine advanced topics such as distributed databases, data warehouses, stored procedures, triggers, data macros and Web Apps. This introduction to database is ideal for mastering today's database techniques.
Ch 1 Introduction to Database Management
Ch 2 The Relational Model 1: Introduction, QBE, and Relational Algebra
Ch 3 The Relational Model 2: SQL
Ch 4 The Relational Model 3: Advanced Topics
Ch 5 Database Design 1: Normalization
Ch 6 Database Design 2: Design Method
Ch 7 DBMS Functions
Ch 8 Database Adminstration
Ch 9 Database Management Approaches
Appendix A: Comprehensive Design Example: Marvel College
Appendix B: SQL Reference
Appendix C: "How Do I" Reference
Appendix D: Introduction to MySQL
Appendix E: A Systems Analysis Approach to Information-Level Requirements
作者：Philip J. Pratt
現職：Grand Valley State University
作者：Joy L. Starks
現職：Indiana University- Purdue University Indianapolis
作者：Mary Z. Last