About the Book
Practical and easy to understand DATABASE PRINCIPLES: FUNDAMENTALS OF DESIGN, IMPLEMENTATION, AND MANAGEMENT, 10E, 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 tenth edition has been thoroughly updated to include hot topics such as green computing/sustainability for modern data centers, the role of redundant relationships, and examples of web-database connectivity and code security. 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.
Table of Contents
PART I: DATABASE SYSTEMS.1. The Database Approach.
2. Database Development Process.
PART II: DESIGN ALTERNATIVES.3. Data Models.
4. Relational Model Characteristics.
PART III: DATABASE PROGRAMMING.5. Beginning Structured Query Language.
6. Procedural Language SQL and Advanced SQL.
PART IV: DATABASE DESIGN.7. Data Modeling with Entity Relationship Diagrams.
8. Data Modeling Advanced Concepts.
9. Normalizing Database Designs.
PART V: IMPLEMENTATION ALTERNATIVES.10. Distributed Databases.
11. Interacting with Databases through the Web.
PART VI: DATABASE MANAGEMENT.12. Database Administration and Security.
13. Managing Transactions and Concurrency.
14. Managing Database and SQL Performance.
15. Databases for Decision Support.
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.