Database Systems Design, Implementation and Management, 13th Edition

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

Carlos Coronel, Steven Morris

Copyright 2019 | Published 2018  | 836 pages

Provide a balanced approach to databases as the market-leading DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, and MANAGEMENT, 13E emphasizes the knowledge and skills necessary for success and makes databases accessible without overwhelming students. Readers gain a solid foundation in database design and implementation as diagrams, illustrations, and tables clarify in-depth coverage of database design. Students learn how successful database implementation involves designing databases to fit within a larger strategic data environment. Revised coverage of SQL introduces more examples and simpler explanations that focus on areas most important for a database career — making supplementary SQL materials unnecessary. Additional coverage of Big Data Analytics and NoSQL, including related Hadoop technologies, offers a strong hands-on approach. MindTap® now include a digital auto-graded MySQL environment.

TABLE OF CONTENT

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