Database Modeling and Design

Logical Design


  • Toby Teorey, University of Michigan, Ann Arbor, USA
  • Sam Lightstone, IBM, Toronto, Canada
  • Tom Nadeau, Ubiquiti Inc., Ann Arbor, MI
  • H.V. Jagadish, Univ of Mich, Ann Arbor (EE/CS dept)

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.
View full description


This book is intended for data management professionals with job titles/functions that include data analyst, data modeler; data architect; database designer; database application developer, application architect, database programmer, programmer/analyst, database administrator.



Book information

  • Published: February 2011
  • ISBN: 978-0-12-382020-4


"Database Modeling and Design is one of the best books that I have seen for explaining how to build database applications. The book is informative, well-written, and concise."-Michael Blaha, DSc., Consultant, Modelsoft Consulting Corp

"This book book is by far the best book available on classic database design. Topics like normalization and many-to-many and n-ary association semantics are without peer in teaching you how to model real-world complexities. This latest edition extends the classic material with extensive discussion of modern tools and other aspects of logical database design. Every database architect should have this book at hand."-Bob Muller, Data Analyst, Poesys Associates

“The book is not only good for beginners, but it also provides greater insight for experienced learners. Perhaps this is why it has evolved into its fifth edition. The book is generally well organized. It starts with the first step in the database life cycle, and progresses in a chronological order to more advanced concepts such as object relational design, Extensible Markup Language (XML), and Web databases. The writing style of the book is simple and straightforward, and the use of database terminology is very concise…In my opinion, the book could be used as a course text, with some help from other sources to cover SQL query-related concepts. However, I would have liked a chapter on SQL that covered simple and complex query design, as well as optimization."-- Computing Reviews

Table of Contents


About the Authors

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

Appendix: The Basics of SQL



Solutions to Selected Exercises



Chapter 3: Query Optimization and Plan Selection

Appendix A: A Simple Performance Model for Databases