Data Modeling Essentials - 3rd Edition - ISBN: 9780126445510, 9780080488677

Data Modeling Essentials

3rd Edition

Print ISBN: 9780126445510
eBook ISBN: 9780080488677
Imprint: Morgan Kaufmann
Published Date: 4th November 2004
Page Count: 560
48.99 + applicable tax
80.95 + applicable tax
60.95 + applicable tax
Compatible Not compatible
VitalSource PC, Mac, iPhone & iPad Amazon Kindle eReader
ePub & PDF Apple & PC desktop. Mobile devices (Apple & Android) Amazon Kindle eReader
Mobi Amazon Kindle eReader Anything else

Institutional Access


Data Modeling Essentials, Third Edition provides expert tutelage for data modelers, business analysts and systems designers at all levels. Beginning with the basics, this book provides a thorough grounding in theory before guiding the reader through the various stages of applied data modeling and database design. Later chapters address advanced subjects, including business rules, data warehousing, enterprise-wide modeling and data management.

The third edition of this popular book retains its distinctive hallmarks of readability and usefulness, but has been given significantly expanded coverage and reorganized for greater reader comprehension. Authored by two leaders in the field, Data Modeling Essentials, Third Edition is the ideal reference for professionals and students looking for a real-world perspective.

Key Features

· Thorough coverage of the fundamentals and relevant theory. · Recognition and support for the creative side of the process. · Expanded coverage of applied data modeling includes new chapters on logical and physical database design. · New material describing a powerful technique for model verification. · Unique coverage of the practical and human aspects of modeling, such as working with business specialists, managing change, and resolving conflict. · Extensive online component including course notes and other teaching aids (

UML diagrams now available! Visit the companion site for more details.

Click here to view a book review by Steve Hoberman!


data modelers, data architects, database designers, DBAs, systems analysts; undergraduate and graduate-level students

Table of Contents

Contents Preface

Chapter 1 - What Is Data Modeling? 1.1 Introduction 1.2 A Data-Centered Perspective 1.3 A Simple Example 1.4 Design, Choice, and Creativity 1.5 Why Is the Data Model Important? 1.6 What Makes a Good Data Model? 1.7 Performance 1.8 Database Design Stages and Deliverables 1.9 Where Do Data Models Fit In? 1.10 Who Should Be Involved in Data Modeling? 1.11 Is Data Modeling Still Relevant? 1.12 Alternative Approaches to Data Modeling 1.13 Terminology 1.14 Where to from Here?—An Overview of Part 1 1.15 Summary

Chapter 2 - Basics of Sound Structure 2.1 Introduction 2.2 An Informal Example of Normalization 2.3 Relational Notation 2.4 A More Complex Example 2.5 Determining Columns 2.6 Repeating Groups and First Normal Form 2.7 Second and Third Normal Forms 2.8 Definitions and a Few Refinements 2.9 Choice, Creativity, and Normalization 2.10 Terminology 60 2.11 Summary 61

Chapter 3 - The Entity-Relationship Approach 3.1 Introduction 3.2 A Diagrammatic Representation 3.3 The Top-Down Approach: Entity-Relationship Modeling 3.4 Entity Classes 3.5 Relationships 3.6 Attributes 3.7 Myths and Folklore 3.8 Creativity and E-R Modeling 3.9 Summary

Chapter 4 - Subtypes and Supertypes 4.1 Introduction 4.2 Different Levels of Generalization 4.3 Rules Vers


No. of pages:
© Morgan Kaufmann 2004
Morgan Kaufmann
eBook ISBN:
Paperback ISBN:


"The perfect balance of theory and practice, giving the reader both the foundation and the tools to deliver high-quality data models." -Karen Lopez, Principal, InfoAdvisors, Inc. "The complete guide to data modeling for the reflective practitioner. Students like this book and so do I -- it is clear and accessible without sacrificing rigor." -Professor Graeme Shanks, School of Business Systems, Monash University, Australia "A unique, practical and comprehensive guide, providing an invaluable resource to anyone involved in data modeling from the novice to the expert data modeler." -Len Silverston, author of The Data Model Resource Book, Volumes 1 and 2. "Includes an extraordinary amount of good, useful, and well articulated information about the field." -David Hay, President, Essential Strategies, Inc. and author of Data Model Patterns "Data Modeling Essentials is a fresh look at an old topic...much more accesible and refreshing in its tone and attitude. Simsion's explanations are very clear and his examples easy to follow...This book is useful for both beginners and experienced data modelers who want a new innovative approach to the important task of documenting data requirements." - The Bridge --Barbara A. Carkenord "The book is extremely well-written. It is humorous at times, full of useful anecdotes, and follows a very logical sequence...In summary, I found Data Modeling Essentials, Third Edition, very useful for data modelers at any level of experience." - DM Review