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, Seventh Edition, is one of the most comprehensive database textbooks available. We have retained the Parts organization of our market-leading sixth edition and streamlined the chapter coverage to make this the ideal choice for your classroom.
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 in 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 of 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. Peter's real-world experience includes two years as a Director of Operations of an aviation charter 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 analyst and systems/applications developer.Carlos Coronel is currently the Lab Director for the College of Business Computer Lab at Middle Tennessee State University. He has 24 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 1. Database Systems 2. Data Models Part II: Design Concepts 3. The Relational Database Model 4. Entity Relationship (ER) Modeling 5. Normalization of Database Tables 6. Advanced Data Modeling 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. The Data Warehouse PART V: Databases and the Internet 14. Database Connectivity and Web Development Part VI: Database Administration 15. Database Administration Appendices (online) A. Designing Databases with Visio Professional: A Tutorial B. The University Lab: Conceptual Design C. The University Lab: Conceptual Design Verification, Logical Design, and Implementation D. Converting ER Model into a Database Structure E. Comparison of ER Model Notations F. Client/Server Systems G. Object Oriented Databases H. Unified Modeling Language (UML) I. Databases in Electronic Commerce J. Web Database Development with ColdFusion K. The Hierarchical Database Model L. The Network Database ModelA Answers to Selected Questions and Problems