Concepts of Database Management

Joy Starks, Philip Pratt, Mary Last, , Joy Starks, Philip Pratt, Mary Last

• Publisher: Cengage Learning EMEA
• Year: 2018
• Print ISBN:
  9781337093422
• eBook ISBN:
  9781337670494
• Topic: Computer Science
• Subtopic: Databases
• Index: Computer Science

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.

Table of contents

• Table of Contents
• Preface
• Chapter 1 Introduction to Database Management
• Chapter 2 The Relational Model 1: Introduction, QBE, and Relational Algebra
• Chapter 3 The Relational Model 2: SQL
• Chapter 4 The Relational Model 3: Advanced Topics
• Chapter 5 Database Design 1: Normalization
• Chapter 6 Database Design 2: Design Method
• Chapter 7 DBMS Functions
• Chapter 8 Database Administration
• Chapter 9 Database Management Approaches
• Appendix A Comprehensive Design Example: Douglas 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
• Glossary
• Index