Higher Education

Concepts of Database Management, 7th Edition

  • Philip J. Pratt Grand Valley State University
  • Joseph J. Adamski Grand Valley State University
  • ISBN-10: 1111825912  |  ISBN-13: 9781111825911
  • 400 Pages
  • Previous Editions: 2008, 2005, 2002
  • © 2012 | Published
  • College Bookstore Wholesale Price = $99.00
  • Newer Edition Available
  *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.

About

Overview

CONCEPTS OF DATABASE MANAGEMENT fits perfectly into any introductory database course for information systems, business or CIS programs. This concise text teaches SQL in a database-neutral environment with all major topics being covered, including E-R diagrams, normalization, and database design. Now in its seventh edition, CONCEPTS OF DATABASE MANAGEMENT prepares students for success in their field using real-world cases addressing current issues such as database design, data integrity, concurrent updates, and data security. Special features include detailed coverage of the relational model (including QBE and SQL), normalization and views, database design, database administration and management, and more. Advanced topics covered include distributed databases, data warehouses, stored procedures, triggers, data macros, and Web databases.

Features and Benefits

  • Comprehensively discusses database design that includes normalization, an easily applied database design method, E-R diagrams, numerous database design examples,requirements gathering and analysis, and trade-off discussions.
  • Extensively covers SQL with numerous examples illustrating the various concepts. Advanced topics such as concurrency issues, distributed databases, data warehouses, stored procedures, triggers, XML, and database processing over the Web are included.
  • A case problem in each chapter challenges students and reinforces concepts.
  • Appendices describe the purpose and syntax of the major SQL commands used in the book.
  • Supplements include an integrated syllabus for using the book with leading Microsoft Access 2007 books such as Shelly & Cashman and New Perspectives.

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: Using Access to Create and Publish a Web Database.
Appendix F: Determining Information-Level Requirements.

What's New

  • NEW! Updated to cover Access 2010.
  • NEW! Appendix covering Access Web Databases, Navigation Forms, Macros, and Data Type Parts has been added.
  • NEW! Appendix on Determining Information-Level Requirements has been added.
  • NEW! Instructor's Manual. The Instructor's Manual includes detailed tips on integrating the Seventh Edition with other books from Course Technology that cover Microsoft Access 2010 and SQL. These books include: New Perspectives on Microsoft Access 2010 (Comprehensive, Introductory, or Brief) by Adamski and Finnegan; Microsoft Office Access 2010 (Introductory, Complete, or Comprehensive Concepts and Techniques) by Shelly, Cashman, Pratt, and Last; A Guide to SQL by Pratt and Last; and A Guide to MySQL by Pratt and Last.

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.

Bundle: Concepts of Database Management, 7th + A Guide to MySQL

ISBN-10: 1133391346  | ISBN-13: 9781133391340

List Price = $251.95  | CengageBrain Price = $251.95  | College Bookstore Wholesale Price = $189.75

This Bundle Includes:

  • Concepts of Database Management
    List Price = $133.95  | CengageBrain Price = $133.95  | College Bookstore Wholesale Price = $99.00
  • A Guide to MySQL
    List Price = $120.95  | CengageBrain Price = $120.95  | College Bookstore Wholesale Price = $90.75


Bundle: New Perspectives on Microsoft® Access 2010, Comprehensive + Concepts of Database Management, 7th

ISBN-10:  1133296076  | ISBN-13:  9781133296072

List Price = $302.95  | College Bookstore Wholesale Price = $227.21

This Bundle Includes:

  • New Perspectives on Microsoft® Access 2010, Comprehensive
    List Price = $184.95  | College Bookstore Wholesale Price = $138.75
  • Concepts of Database Management
    List Price = $133.95  | CengageBrain Price = $133.95  | College Bookstore Wholesale Price = $99.00


ISBN-10:  1133302009  | ISBN-13:  9781133302001

List Price = $315.95  | College Bookstore Wholesale Price = $236.96

This Bundle Includes:

  • New Perspectives on Microsoft® Access 2010, Comprehensive
    List Price = $184.95  | College Bookstore Wholesale Price = $138.75
  • Concepts of Database Management
    List Price = $133.95  | CengageBrain Price = $133.95  | College Bookstore Wholesale Price = $99.00
  • SAM 2010 Assessment, Training, and Projects v2.0 Multi-Term Printed Access Card
    List Price = $132.00  | College Bookstore Wholesale Price = $99.00


Printed Text + SAM 2010 Assessment, Training and Projects with MindTap Reader Instant Access

ISBN-10:  1305429958  | ISBN-13:  9781305429956

List Price = $158.95  | College Bookstore Wholesale Price = $119.50

This Bundle Includes:

  • Concepts of Database Management
    List Price = $133.95  | CengageBrain Price = $133.95  | College Bookstore Wholesale Price = $99.00
  • SAM 2010 Assessment, Training and Projects with MindTap Reader Instant Access for New Perspectives on Microsoft Access 2010, Comprehensive
    List Price = $146.00  | College Bookstore Wholesale Price = $146.00


ePack: New Perspectives on Microsoft® Access 2010, Comprehensive + Concepts of Database Management, 7th + SAM 2010 Assessment, Training, and Projects v2.0 Instant Access

ISBN-10:  1305433475 | ISBN-13:  9781305433472

List Price = $315.95  | College Bookstore Wholesale Price = $236.96

This Bundle Includes:

  • New Perspectives on Microsoft® Access 2010, Comprehensive
    List Price = $184.95  | College Bookstore Wholesale Price = $138.75
  • SAM 2010 Assessment, Training, and Projects v2.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


Supplements

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

SAM 2010 Assessment, Training, and Projects v2.0 Multi-Term Printed Access Card  (ISBN-10: 1111667373 | ISBN-13: 9781111667375)

Get your students workplace-ready with SAM, the premier proficiency-based assessment and training solution for Microsoft Office and Computer Concepts! SAM’s active, hands-on environment helps students master computer skills and concepts that are essential to academic and career success. Skill-based assessments, interactive trainings, and comprehensive remediation engage students in mastering the latest Microsoft Office programs on their own, allowing instructors to spend class time teaching. SAM’s efficient course setup and robust grading features provide faculty with consistency across sections.

List Price = $132.00  | College Bookstore Wholesale Price = $99.00

SAM 2010 Assessment, Training, and Projects 1.5, 1 term (6 months) Instant Access  (ISBN-10: 1111669341 | ISBN-13: 9781111669348)

SAM 2010 Assessment, Training, and Projects version 1.5 offers a real-world approach to applying Microsoft Office 2010 skills. The Assessment portion of this powerful and easy to use software simulates Office 2010 applications, allowing users to demonstrate their computer knowledge in a hands-on environment. The Training portion helps students learn in the way that works best for them by reading, watching, or receiving guided help. The Projects portion allows students to work live-in-the-application on project-based assignments.

List Price = $132.00  | CengageBrain Price = $132.00  | College Bookstore Wholesale Price = $132.00

Student Supplements

SAM 2010 Assessment, Training, and Projects v2.0 Multi-Term Printed Access Card  (ISBN-10: 1111667373 | ISBN-13: 9781111667375)

Get your students workplace-ready with SAM, the premier proficiency-based assessment and training solution for Microsoft Office and Computer Concepts! SAM’s active, hands-on environment helps students master computer skills and concepts that are essential to academic and career success. Skill-based assessments, interactive trainings, and comprehensive remediation engage students in mastering the latest Microsoft Office programs on their own, allowing instructors to spend class time teaching. SAM’s efficient course setup and robust grading features provide faculty with consistency across sections.

List Price = $132.00  | College Bookstore Wholesale Price = $99.00

SAM 2010 Assessment, Training, and Projects 1.5, 1 term (6 months) Instant Access  (ISBN-10: 1111669341 | ISBN-13: 9781111669348)

SAM 2010 Assessment, Training, and Projects version 1.5 offers a real-world approach to applying Microsoft Office 2010 skills. The Assessment portion of this powerful and easy to use software simulates Office 2010 applications, allowing users to demonstrate their computer knowledge in a hands-on environment. The Training portion helps students learn in the way that works best for them by reading, watching, or receiving guided help. The Projects portion allows students to work live-in-the-application on project-based assignments.

List Price = $132.00  | CengageBrain Price = $132.00  | College Bookstore Wholesale Price = $132.00

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.

Joseph J. Adamski

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.