Nelson Higher Education

Higher Education

Database Systems: Design, Implementation, & Management, 11th Edition

  • Carlos Coronel
  • Steven Morris
  • ISBN-10: 1285196147
  • ISBN-13: 9781285196145
  • 752 Pages | Hardcover
  • Previous Editions: 2013, 2010, 2009
  • COPYRIGHT: 2015 Published
Request a Copy for Review

Overview

About the Product

Practical and easy to understand, DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, AND MANAGEMENT, Eleventh 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 eleventh edition has been updated to include expanded relational algebra coverage, updated business vignettes showing the impact of database tech in the real world, updated coverage of cloud data services, expanded coverage of Big Data and related Hadoop technologies, SQL coverage expanded to include MySQL databases, and many other improvements! 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

  • Review questions, problem sets, and cases throughout the book provide multiple opportunities for students to test their understanding.

  • Up-to-date content includes topics such as cloud data services, Big Data, and Hadoop technologies.

  • Material on Ethics, as it pertains to the database administration function, is included so that students have a solid understanding of ethical dilemmas in the field.

  • 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, MySQL, and Oracle databases.

  • Business vignettes offer insight on the most current issues and challenges facing database technologies 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.

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

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.

New to this edition

  • 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 add support for MySQL. New topics include expanded coverage of Big Data, NoSQL, cloud computing, expanded relational algebra coverage, and triggers within Microsoft Access 2013.

Supplements

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

Instructor Supplements

CourseMate, 2 terms (12 months) Instant Access  (ISBN-10: 1285857860 | ISBN-13: 9781285857862)

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 11e CourseMate goes beyond the book to deliver what you need! Database Systems 11e CourseMate includes an interactive eBook along with 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.

Student Supplements

CourseMate, 2 terms (12 months) Instant Access  (ISBN-10: 1285857860 | ISBN-13: 9781285857862)

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 11e CourseMate goes beyond the book to deliver what you need! Database Systems 11e CourseMate includes an interactive eBook along with 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.