Synopses & Reviews
Database Systems: Design, Implementation, and Management, Seventh Edition is one of the most comprehensive database textbooks available. The proven success of database design treatment is sustained and further improved in this revision. The proven Parts organizations streamline the chapter coverage, so it is an ideal choice for your classroom. Each Part opens with a new business vignette, which provides real world examples to engage your students. The new edition includes updates in every chapter as well as added exercises and cases. There are new chapters such as Advanced Modeling Concepts, Database Performance Tuning and Query Optimization, and Database Connectivity and Web Development. In the seventh edition you will find examples of database usage, which highlights eBAY for compelling context. In our new Query Optimization chapter, we cover database performance tuning concepts, index selectivity and SQL coding practices. There is added EERD coverage such as clusters and subtype discriminator attributes. With the authors? strong writing style and outstanding balance of theory and practice, this is just a small sampling of the improvements we have made to the new edition of Database Systems: Design, Implementation, and Management by Peter Rob and Carlos Coronel.
Synopsis
Database Systems: Design, Implementation, and Management, Eighth 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. Updates for the eighth edition include additional Unified Modeling Language coverage, expanded coverage of SQL Server functions, all-new business intelligence coverage, and added coverage of data security. 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.
About the Author
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. 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.
Table of Contents
Part I: Database Concepts Chapter 1 Database Systems Chapter 2 Data Models Part II: Design Concepts Chapter 3 The Relational Database Model Chapter 4 Entity Relationship (ER) Modeling Chapter 5 Normalization of Database Tables Chapter 6 Advanced Data Modeling Part III: Advanced Design and Implementation Chapter 7 Introduction to Structured Query Language (SQL) Chapter 8 Advanced SQL Chapter 9 Database Design Part IV: Advanced Database Concepts Chapter 10 Transaction management and Concurrency Control Chapter 11 Database Performance Tuning and Query Optimization Chapter 12 Distributed Database Management Systems Chapter 13 Business Intelligence and Data Warehouses Part V: Database and the Internet Chapter 14 Database Connectivity and Web Technologies Part VI: Database Administration Chapter 15 Database Administration and Security 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