Database Systems: Design, Implementation, and Management (with Bind-In Printed Access Card) / Edition 9

by Carlos Coronel, Steven Morris, Rob

Overview

DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, AND MANAGEMENT, NINTH EDITION, a market-leader for database texts, gives readers a solid foundation in practical database design and implementation. The book 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. -Updated coverage of data models. -Improved coverage of normalization with a data modeling checklist. -Enhanced coverage of of database design and life cycle. -New review questions, problem sets, and cases throughout the book. With a strong hands-on component that includes real-world examples and exercises, this book will help students develop database design skills that have valuable and meaningful application in the real world.

Product Details

ISBN-13:	9780538469685
Publisher:	Cengage Learning
Publication date:	11/28/2009
Series:	Management Information Systems Series
Pages:	700
Product dimensions:	8.70(w) x 11.10(h) x 1.20(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 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 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 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.

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.