Nelson Higher Education

Higher Education

Concepts of Database Management, 8th Edition

  • Philip J. Pratt
  • Mary Z. Last
  • ISBN-10: 1285427106
  • ISBN-13: 9781285427102
  • 432 Pages | Paperback
  • Previous Editions: 2012, 2008, 2005
  • COPYRIGHT: 2015 Published
Request a Copy for Review


About the Product

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.


  • Thorough yet succinct, CONCEPTS OF DATABASE MANAGEMENT delivers clear, comprehensive discussions of database design that include normalization, an easily applied database design method, E-R diagrams, numerous database design examples, requirements gathering and analysis, trade-off discussions, and more.

  • Extensive coverage of SQL offers numerous examples to effectively illustrate concepts and includes such advanced topics as concurrency issues, distributed databases, data warehouses, stored procedures, triggers, XML, and database processing over the Web.

  • A common case problem in each chapter reinforces key concepts as it challenges students to put what they learn into real-world practice. Two additional case problems are presented in the exercises at the end of each chapter. Critical thinking questions and exercises challenge students to use problem-solving and analytical skills.

  • Providing students with additional insight, appendices describe the purpose and syntax of the major SQL commands used in the book. Appendices include Access Web Apps and a Systems Analysis Approach to Information-Level Requirements.

  • The Instructor's Manual offers detailed tips on integrating the Eighth Edition with other books from Course Technology that cover Microsoft Access 2013 and SQL.

About the Author

Philip J. Pratt

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 more than 75 textbooks and has co-authored three levels of Microsoft® Office Access books for the popular Shelly Cashman Series, in addition to the popular A GUIDE TO SQL.

Mary Z. Last

Mary Z. Last has taught computer information systems since 1984. She retired from the University of Mary Hardin-Baylor, Belton, Texas, where she was an associate professor and the Director of the Center for Effectiveness in Learning and Teaching. Ms. Last is actively involved in the Computing Educator's Oral History Project that encourages young women to pursue careers in math and science. She has been a contributing author to the Shelly Cashman Series since 1992. She also authors many instructor resources for leading database texts.

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.

New to this edition

  • Offering the most current coverage available, the new CONCEPTS OF DATABASE MANAGEMENT, 8e is packed with the latest technologies, practices, and developments from the field.
  • The Eighth Edition is completely updated to Microsoft Access 2013 standards.
  • Comprehensive, current coverage of database design and database management systems provides readers with the tools they need for real-world success.
  • A new continuing case problem appears in each chapter throughout the book.


All supplements have been updated in coordination with the Main title.
Please see Main title page for new to this edition information.

Instructor Supplements

Cengage Testing, powered by Cognero┬« Instant Access  (ISBN-10: 1305119363 | ISBN-13: 9781305119369)