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 Hardcover 
  • Previous Editions: 2010, 2009, 2007
  • © 2013 | Published
Request a Copy
 

About The Solution

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.


Additional Product Information

Features/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.

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.

Best Buy Packages

Other Popular Packages

Choose the textbook packaged with the resources that best meet your course and student needs. Contact your Cengage Learning representative 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


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.

Supplements

Instructor Supplements

Instructor Supplements

All supplements have been updated in coordination with the main title. Select the main title’s "About the Solution" 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.

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

Student Supplements

All supplements have been updated in coordination with the main title. Select the main title’s "About the Solution" 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.

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)


Blackboard MindLink for CourseMate Instant Access  (ISBN-10: 1285597281 | ISBN-13: 9781285597287)

The more you study, the better the results. Make the most of your study time by accessing everything you need to succeed in your database course in one place. Read your eBook, take notes, review flashcards, view videos, and take practice quizzes—all online with MindLink for CourseMate on Blackboard.


Flash Cards 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

About the Author

Carlos Coronel

Carlos Coronel is currently the Lab Director for the College of Business Computer Labs at Middle Tennessee State University. He has over 27 years of experience in various fields as a Database Administrator, Network Administrator, Web Manager, and Technology Specialist, and 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 PhD from Auburn University. He has taught Database Design and Development, Database Programming with Advanced SQL and PL/SQL, Systems Analysis and Design, and Principles of MIS at Middle Tennessee State University. Steven has published many articles, and currently serves 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.