Database Systems: Design, Implementation, & Management

by Carlos Coronel, Steven Morris

Overview

Gain a solid foundation in database design and implementation with the practical and easy-to-understand approach in DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, AND MANAGEMENT, 12E. Filled with diagrams, illustrations, and tables, this market-leading text provides in-depth coverage of database design. You learn the key to successful database implementation: 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 an outstanding balance of theory and practice. You gain the hands-on skills to make you attractive to employers. Updates include the latest coverage of cloud data services and a new chapter on Big Data Analytics and NoSQL, including related Hadoop technologies. In addition, new review questions, problem sets, and cases offer multiple opportunities to test your understanding and develop useful design skills.

Product Details

ISBN-13:	9781305627482
Publisher:	Cengage Learning
Publication date:	01/26/2016
Series:	MindTap Course List
Pages:	784
Product dimensions:	8.80(w) x 11.10(h) x 1.40(d)

About the Author

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