Higher Education

Concepts of Database Management, 8th Edition

  • Philip J. Pratt Grand Valley State University
  • Mary Z. Last
  • ISBN-10: 1285427106  |  ISBN-13: 9781285427102
  • 432 Pages
  • Previous Editions: 2012, 2008, 2005
  • © 2015 | Published
  • College Bookstore Wholesale Price = $99.00
  *Why an online review copy?
  • It's the greener, leaner way to review! An online copy cuts down on paper and on time. Reduce the wait (and the weight) of printed texts. Your online copy arrives instantly, and you can review it anytime from your computer or favorite mobile device.

If you prefer a print copy to review, please contact your representative.



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.

Features and Benefits

  • 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.

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.

What's New

  • 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.
  • New cases are used in the end-of-chapter exercises and cases.
  • Critical thinking questions and exercises that challenge students to use problem-solving and analytical skills appear in each case.

Learning Resource Bundles

Choose the textbook packaged with the resources that best meet your course and student needs. Contact your Learning Consultant for more information.

Printed Text + SAM 2013 Assessment, Training, and Projects v1.0 Instant Access Code

ISBN-10: 1305713192 | ISBN-13: 9781305713192

List Price = $306.95  | CengageBrain Price = $306.95  | College Bookstore Wholesale Price = $231.00

This Bundle Includes:

  • SAM 2013 Assessment, Training, and Projects v1.0 Multi-Term Instant Access
    List Price = $132.00  | CengageBrain Price = $132.00  | College Bookstore Wholesale Price = $132.00
  • Concepts of Database Management
    List Price = $133.95  | CengageBrain Price = $133.95  | College Bookstore Wholesale Price = $99.00


All supplements have been updated in coordination with the main title. Select the main title's "About" tab, then select "What's New" for updates specific to title's edition.

For more information about these supplements, or to obtain them, contact your Learning Consultant.

Instructor Supplements

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

Meet the Author

Author Bio

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 2013 books for this popular Shelly Cashman Series and 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 database texts.