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 m
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.
In-depth detail and plenty of real-world, practical examples throughout
Loaded with design rules and illustrative case studies that are applicable to any SQL, UML, or XML-based system
Immediately useful to anyone tasked with the creation of data models for the integration of large-scale enterprise data.
Table of Contents
Chapter 1. Introduction
Chapter 2. The Entity-Relationship Model
Chapter 3. The Unified Modeling Language
Chapter 4. Requirements Analysis and Conceptual Data Modeling
Chapter 5. Transforming the Conceptual Data Model to SQL
Chapter 6. Normalization
Chapter 7. An Example of Logical Database Design
Chapter 8. Object-Relational Design
Chapter 9. XML and Web Databases
Chapter 10. Business Intelligence
Chapter 11. CASE Tools for Logical Database Design