AE Database Systems: Design, Implementation, & Management,
14th Edition

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
14. Big Data Analytics and NoSQL
Part V: DATABASES AND THE INTERNET
15. Database Connectivity and Web Technologies
Part VI: DATABASE ADMINISTRATION
16. Database Administration and Security
ONLINE APPENDICES
Appendix Aa: Designing Databases with Lucicharts: A Tutorial
Appendix Ab: Designing Databases with Visio: 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
Appendix N: Creating a New Database Using Oracle 12c
Appendix O: Data Warehouse Implementation Factors
Appendix P: Working with MongoDB
Appendix Q: Working with Neo4j

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

• A more hands-on focus on big data tools and NoSQL databases equips students with the skills employers want. Immersed in leading edge database concepts, students become familiar with emerging tools such as big data analytics.

• Clear presentation balances theory and practice. The authors' straightforward, easy-to-understand writing style blends foundational theory with the latest practices and applications and an emphasis on key hands-on skills.

• Expanded coverage of SQL eliminates the need for supplemental programming books. Reorganized coverage focuses first on data retrieval since this is the most central SQL programming skill for entry-level database positions.

• Enhanced coverage addresses today's most used database systems, giving students a broad understanding of database design and programming across a range of DBMS products, including Oracle®, MySQL™, SQL Server and Microsoft® Access.

• Auto-graded MySQL labs and homework questions confirm students’ understanding of key concepts and terms, while advanced assignments enable learners to practice database design concepts.

• Module Quizzes, Problems and Use It activities help students apply what they're learning to real-world scenarios. Database for Life assignments keep students current on what's trending, and Concept Video Clips explain and illustrate database system terms and concepts. At the end of the course students can explore the Career Connection unit, which includes videos on potential career paths in the database field and a career reflection assignment.

• Engaging visuals clarify concepts. Full-color, detailed illustrations, tables and diagrams enhance student comprehension of even the most complex concepts.

• Enabling students to work with multiple databases in various formats, this edition provides opportunities for readers to gain experience using all of today's most commonly used database systems, including Microsoft® Access, Microsoft® SQL Server, MySQL™ and Oracle® databases.

• Clear presentation balances theory and practice. The authors' straightforward, easy-to-understand writing style blends foundational theory with the latest practices and applications and an emphasis on key hands-on skills.

• Robust teaching and learning support provides time-saving resources and online tools. PowerPoint® presentation slides, MS Access databases, Oracle®, MySQL™ and SQL Server scripts, test banks, interactive digital exercises, flashcards and other study tools help maximize student success. In addition, the comprehensive Instructor's Manual includes all end-of-chapter solutions, suggested discussion material and other resources to help you maximize your class prep time.

• Through MindTap's digital lab assignments, students write SQL code in an interactive environment and receive real-time feedback on their work. Module Quizzes, Problems and Use It activities help students apply what they're learning to real-world scenarios. Database for Life assignments keep students current on what's trending, and Concept Video Clips explain and illustrate database system terms and concepts. At the end of the course students can explore the Career Connection unit, which includes videos on potential career paths in the database field and a career reflection assignment.

Cengage provides a range of supplements that are updated in coordination with the main title selection. For more information about these supplements, contact your Learning Consultant.