Cengage Learning

Higher Education

Database Systems: Design, Implementation, and Management, 10th Edition

  • includes Bind-in Printed Access Card
  • Carlos Coronel Middle Tennessee State University
  • Steven Morris Middle Tennessee State University
  • Peter Rob Middle Tennessee State University
  • ISBN-10: 1111969604  |  ISBN-13: 9781111969608
  • 720 Pages
  • Previous Editions: 2010, 2009, 2007
  • © 2013 | Published
  • Newer Edition Available
Request a Copy

About

Overview

Practical and easy to understand, DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, AND MANAGEMENT, Tenth Edition, gives students a solid foundation in database design and implementation. Filled with visual aids such as diagrams, illustrations, and tables, this market-leading text provides in-depth coverage of database design, demonstrating that the key to successful database implementation is in proper design of databases to fit within a larger strategic view of the data environment. Renowned for its clear, straightforward writing style, this text provides students with an outstanding balance of theory and practice. The tenth edition has been thoroughly updated to include hot topics such as green computing/sustainability for modern data centers, the role of redundant relationships, and examples of web-database connectivity and code security. In addition, new review questions, problem sets, and cases have been added throughout the book so that students have multiple opportunities to test their understanding and develop real and useful design skills.

Features and Benefits

  • Full-color, detailed illustrations, tables, and diagrams enhance comprehension and facilitate understanding of more complex concepts.
  • Multiple databases in various formats are used to provide readers with experience in implementation using MS Access, MS SQL Server, and Oracle databases.
  • Business vignettes offer insight on the most current issues and challenges facing database implementation today.
  • Clear, straightforward writing style provides an outstanding balance of theory and practice.
  • Instructor’s Manual includes all end-of-chapter solutions, suggested discussion material, and other resources, giving teachers a complete teaching tool.

Table of Contents

PART I: DATABASE CONCEPTS.
1. Database Systems.
2. Data Models.
PART II: DESIGN CONCEPTS.
3. The Relational Database Model.
4. Entity Relationship (ER) Modeling.
5. Advanced Data Modeling.
6. Normalization of Database Tables.
PART III: ADVANCED DESIGN AND IMPLEMENTATION.
7. Introduction to Structured Query Language (SQL).
8. Advanced SQL.
9. Database Design.
PART IV: ADVANCED DATABASE CONCEPTS.
10. Transaction Management and Concurrency Control.
11. Database Performance Tuning and Query Optimization.
12. Distributed Database Management Systems.
13. Business Intelligence and Data Warehouses.
PART V: DATABASES AND THE INTERNET.
14. Database Connectivity and Web Technologies.
PART VI: DATABASE ADMINISTRATION.
15. Database Administration and Security.
ONLINE APPENDICES.
Appendix A: Designing Databases with Visio Professional: A Tutorial.
Appendix B: The University Lab: Conceptual Design.
Appendix C: The University Lab: Conceptual Design Verification, Logical Design, and Implementation.
Appendix D: Converting the ER Model into a Database Structure.
Appendix E: Comparison of ER Model Notations.
Appendix F: Client/Server Systems.
Appendix G: Object-Oriented Databases.
Appendix H: Unified Modeling Language (UML).
Appendix I: Databases in Electronic Commerce.
Appendix J: Web Database Development with ColdFusion.
Appendix K: The Hierarchical Database Model.
Appendix L: The Network Database Model.
Appendix M: Microsoft Access Tutorial.

What's New

  • Figures, diagrams, and illustrations have been updated in order to provide students with improved visual aids.
  • New review questions, problem sets, and cases have been added throughout the book so that students have multiple opportunities to test their understanding.
  • To ensure that students are provided with the most up-to-date material available, content has been expanded to include topics such as Open Source databases, embedded/mobile databases, data replication, data analytics, explanatory models, predictive models, the role of redundant relationships, and examples of web-database connectivity and code security.
  • In order to address new trends in the market, coverage now includes green computing/sustainability for modern data centers.
  • Material on Ethics, as it pertains to the database administration function, is now included so that students have a solid understanding of ethical dilemmas in the field.

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: Database Systems: Design, Implementation, and Management (with Design, Implementation, and Management (with Premium WebSite Printed Access Card and Essential Textbook Resources Printed Access Card), 10th + A Guide to SQL

ISBN-10: 1133803253 | ISBN-13: 9781133803256


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

Database Systems: Design, Implementation, and Management (Book Only)  (ISBN-10: 1111969590 | ISBN-13: 9781111969592)

CourseMate Instant Access  (ISBN-10: 1133113184 | ISBN-13: 9781133113188)

Cengage Learning’s CourseMate brings course concepts to life with interactive learning, study, and exam preparation tools that support the printed textbook. Watch student comprehension soar as your class works with the printed textbook and the textbook-specific website. Database Systems 10e CourseMate goes beyond the book to deliver what you need! Database Systems 10e CourseMate includes: An interactive eBook. Interactive teaching and learning tools include quizzes, flashcards, videos and more. Engagement Tracker, a first-of-its-kind tool, monitors student engagement in the course.

Essential Textbook Resources Instant Access Code  (ISBN-10: 1111966370 | ISBN-13: 9781111966379)

Student Supplements

CourseMate Instant Access  (ISBN-10: 1133113184 | ISBN-13: 9781133113188)

Cengage Learning’s CourseMate brings course concepts to life with interactive learning, study, and exam preparation tools that support the printed textbook. Watch student comprehension soar as your class works with the printed textbook and the textbook-specific website. Database Systems 10e CourseMate goes beyond the book to deliver what you need! Database Systems 10e CourseMate includes: An interactive eBook. Interactive teaching and learning tools include quizzes, flashcards, videos and more. Engagement Tracker, a first-of-its-kind tool, monitors student engagement in the course.

Essential Textbook Resources Instant Access Code  (ISBN-10: 1111966370 | ISBN-13: 9781111966379)

Flash Cards, 1 term (6 months) Instant Access  (ISBN-10: 128579687X | ISBN-13: 9781285796871)

Flashcards designed to work with your text can help you to review and learn essential terms and key concepts. Interactive flashcards include terms and definitions for each chapter. This is instant access product; at the completion of your purchase, simply go to "My Home" and gain immediate access to your product. Note: If you have purchased CourseMate for your title, flash cards are already included.

Quizzing Instant Access  (ISBN-10: 1285793072 | ISBN-13: 9781285793078)

Interactive practice quizzes designed to work with your text can help you to review and learn essential terms and key concepts. True/false and multiple choice questions are included for each chapter. Check your score and take quizzes again if needed. A reference for where to find more material in the text is included with each answer. This is instant access product; at the completion of your purchase, simply go to "My Home" and gain immediate access to your product. Note: If you have purchased CourseMate for your title, flash cards are already included.

Quizzing with Flash Cards Instant Access  (ISBN-10: 128578927X | ISBN-13: 9781285789279)

Interactive practice quizzes and flashcards designed to work with your text can help you to review and learn essential terms and key concepts. Flashcards contain terms and definitions for each chapter. Practice quizzes consist of true/false and multiple choice questions for each chapter. Check your score and take quizzes again if needed. A reference for where to find more material in the text is included with each answer. This is instant access product; at the completion of your purchase, simply go to "My Home" and gain immediate access to your product. Note: If you have purchased CourseMate for your title, practice quizzes and flashcards are already included.

Meet the Author

Author Bio

Carlos Coronel

Carlos Coronel is currently the Lab Director for the College of Business Computer Labs at Middle Tennessee State University. He has more than 29 years of experience in various fields as a Database Administrator, Network Administrator, Web Manager, and Technology Specialist. He has taught courses in Web development, database design and development, and data communications at the undergraduate and graduate levels.

Steven Morris

Steven Morris completed his Bachelor of Science and Ph.D. from Auburn University. He has taught courses in Database Design and Development, Database Programming with Advanced SQL and PL/SQL, Systems Analysis and Design, and Database Management at the graduate and undergraduate levels at Middle Tennessee State University. He has many years of experience consulting on a database projects across a broad range of industries. Dr. Morris has published numerous professional articles and has served on the review boards of several journals.

Peter Rob

Peter Rob has 32 years experience teaching file systems, database systems design, database design, database applications development, and more. Peter’s real-world experience includes two years as a Director of Operations at an aviation chart company, 20 years as a consultant for hands-on operations systems analysis/development and database systems design, and 15 years experience as a statistical quality control systems analysis and systems/applications developer.