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 co ncepts 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