Synopses & Reviews
This concise yet comprehensive introduction to fundamental database concepts is an indispensable resource to develop your knowledge of database management concepts. Now in its sixth edition, Concepts of Database Management maintains the focus on real-world cases that made previous editions so effective addressing the most current database issues faced today such as database design, data integrity, concurrent updates, and data security. Special features include detailed coverage of the relational model (including Query-By-Example (QBE) and SQL), normalization and views, database design, database administration and management, and more. This book's advanced topics include distributed databases, data warehouses, stored procedures, and triggers fostering an in-depth understanding of database management that will prepare users for success in their fields.
Concepts of Database Management is the perfect short yet complete introduction to database concepts. The two featured case problems, Premiere Products and Henry Books, bring to life real-world database issues such as database design, data integrity, concurrent updates, and data security. This edition includes expanded coverage of SQL, entity-relationship (E-R) diagrams, normalization, and database design.
About the Author
Philip J. Pratt is Professor Emeritus of Mathematics and Computer Science at Grand Valley State University, where he taught for 33 years. His teaching interests include database management, systems analysis, complex analysis, and discrete mathematics. He has authored over 75 textbooks, including coauthoring three levels of Microsoft Office Access 2013 books for the Shelly Cashman Series and A Guide to SQL. Joseph J. Adamski spent 12 years as a computer professional at aerospace and financial services companies and is an Associate Professor Emeritus at Grand Valley State University. He has worked as a computer professional and educator for over 40 years with a special interest in database management and personal uses of databases.
Table of Contents
Introduction to Database Management The Relational Model 1: Introduction, QBE, and Relational Algebra The Relational Model 2: SQL The Relational Model 3: Advanced Topics Database Design 1: Normalization Database Design 2: Design Methodology DBMS Functions Database Administration Database Management Approaches Appendices Comprehensive Design Example: Marvel College SQL Reference "How Do I" Reference