Database Modeling and Design focuses on techniques for database design in relational database systems. The book discusses the entity-relationship approach and the unified modeling language approach; both are used throughout the book when it refers to logical database design for the specification of data requirements and conceptual modeling.
The book starts with a description of the life cycle of databases, and it goes on to discuss the entity-relationship model and unified modeling languages. It demonstrates how data modeling concepts are used in the process of database design. The book covers database normalization, including information about equivalence on the function of the entity-relationship and unified modeling language conceptual models, and the relational model of the Boyce Codd normal form.
The book explores the difference between object-oriented database systems and relational database systems. It includes a description on handling the impedance mismatch problem by the extensions made to relational systems. Web technologies, including an overview and specific database design issues on XML, are also covered in this book. Lastly, IBMs Rational Data Architect, Computer Associates AllFusion ERwin Data Modeler, and Sysbases PowerDesigner are discussed, and their uses for handling complex data modeling problems are demonstrated.
This book will serve as a guide for both novice and experienced professional database practitioners.
1. 1. Introduction 2. 2. The Entity–Relationship Model 3. 3. The Unified Modeling Language 4. 4. Requirements Analysis and Conceptual Data Modeling 5. 5. Transforming the Conceptual Data Model to SQL 6. 6. Normalization 7. 7. An Example of Logical Database Design 8. 8. Object-Relational Design 9. 9. XML and Web Databases 10. 10. Business Intelligence 11. 11. CASE Tools for Logical Database Design 12. APPENDIX. The Basics of SQL 13. References 14. Exercises 15. Solutions to Selected Exercises 16. Glossary 17. Index 18. Bonus Chapter Opener 19. 3. Query Optimization and Plan Selection 20. A. A Simple Performance Model for Databases
Database Modeling and Design focuses on techniques for database design in relational database systems. The book discusses the entity-relationship approach and the unified modeling language approach; both are used throughout the book when it refers to logical database design for the specification of data requirements and conceptual modeling.
The book starts with a description of the life cycle of databases, and it goes on to discuss the entity-relationship model and unified modeling languages. It demonstrates how data modeling concepts are used in the process of database design. The book covers database normalization, including information about equivalence on the function of the entity-relationship and unified modeling language conceptual models, and the relational model of the Boyce Codd normal form.
The book explores the difference between object-oriented database systems and relational database systems. It includes a description on handling the impedance mismatch problem by the extensions made to relational systems. Web technologies, including an overview and specific database design issues on XML, are also covered in this book. Lastly, IBMs Rational Data Architect, Computer Associates AllFusion ERwin Data Modeler, and Sysbases PowerDesigner are discussed, and their uses for handling complex data modeling problems are demonstrated.
This book will serve as a guide for both novice and experienced professional database practitioners.
1. 1. Introduction 2. 2. The Entity–Relationship Model 3. 3. The Unified Modeling Language 4. 4. Requirements Analysis and Conceptual Data Modeling 5. 5. Transforming the Conceptual Data Model to SQL 6. 6. Normalization 7. 7. An Example of Logical Database Design 8. 8. Object-Relational Design 9. 9. XML and Web Databases 10. 10. Business Intelligence 11. 11. CASE Tools for Logical Database Design 12. APPENDIX. The Basics of SQL 13. References 14. Exercises 15. Solutions to Selected Exercises 16. Glossary 17. Index 18. Bonus Chapter Opener 19. 3. Query Optimization and Plan Selection 20. A. A Simple Performance Model for Databases
