Data Modeling, A Beginner's Guide | Beginner's Guide

Data Modeling, A Beginner's Guide

Authors: Andy Oppel

Published: December 2009

eISBN: 9780071623995 007162399X | ISBN: 9780071623988

Contents

Acknowledgments

Introduction

Part I: Data Modeling Concepts

1 Introduction to Data Modeling

Data-Centric Design

Anatomy of a Data Model

Importance of Data Modeling

Measures of a Good Data Model

How Data Models Fit Into Application Development

Data Modeling Participants

Try This 1-1: Refining a Conceptual Model

Chapter 1 Self Test

2 Relational Model Components

Conceptual and Logical Model Components

Physical Model Components

Try This 2-1: Conceptual Model Modification

Chapter 2 Self Test

3 Data and Process Modeling

Data Model Diagramming Alternatives

Process Models

Unified Modeling Language (UML)

Relating Entities and Processes

Try This 3-1: Drawing a Conceptual Model with Nested Subtypes

Chapter 3 Self Test

4 Organizing Database Project Work

The Traditional Life Cycle

Nontraditional Life Cycles

The Project Triangle

Try This 4-1: Project Database Management Tasks

Chapter 4 Self Test

Part II: Data Modeling Details

5 Conceptual Data Modeling

The Conceptual Modeling Process

Creating the Model

Evaluating the Model

Try This 5-1: Conceptual Model for International Addresses

Chapter 5 Self Test

6 Logical Database Design Using Normalization

The Need for Normalization

Applying the Normalization Process

Denormalization

Practice Problems

Try This 6-1: UTLA Academic Tracking

Try This 6-2: Computer Books Company

Chapter 6 Self Test

7 Beyond Third Normal Form

Advanced Normalization

Resolving Supertypes and Subtypes

Generalizing Attributes

Alternatives for Reference Data

Try This 7-1: Complex Logical Data Model

Chapter 7 Self Test

8 Physical Database Design

The Physical Design Process

Designing Tables

Try This 8-1: Drawing a Physical Data Model

Integrating Business Rules and Data Integrity

Adding Indexes for Performance

Designing Views

Try This 8-2: Mapping a Logical Model to a Physical Database Design

Chapter 8 Self Test

Part III: Design Alternatives

9 Alternatives for Incorporating Business Rules

The Anatomy of a Business Rule

Implementing Business Rules in Data Models

Limitations on Implementing Business Rules in Data Models

Functional Classification of Business Rules

Try This 9-1: Modeling Business Rules

Chapter 9 Self Test

10 Alternatives for Handling Temporal Data

Temporal Data Structures

Calendar Data Structures

Business Rules for Temporal Data

Try This 10-1: Adding History to Data Structures

Chapter 10 Self Test

11 Modeling for Analytical Databases

Data Warehouses

Data Marts

Modeling Analytical Data Structures

Loading Data into Analytical Databases

Try This 11-1: Design Star Schema Fact and Dimension Tables .

Chapter 11 Self Test

12 Enterprise Data Modeling

Enterprise Data Management

The Enterprise Data Model

Try This 12-1: Enterprise Conceptual Model Development

Chapter 12 Self Test

Part IV: Appendixes

A: Answers to Self Tests

B: Solutions to Try This Exercises

Try This 1-1: Refining a Conceptual Model

Try This 2-1: Conceptual Model Modification

Try This 3-1: Drawing a Conceptual Model with Nested Subtypes

Try This 4-1: The Database Life Cycle

Try This 5-1: Conceptual Model for International Addresses

Try This 6-1: UTLA Academic Tracking

Try This 6-2: Computer Books Company

Try This 7-1: Complex Logical Data Model

Try This 8-1: Drawing a Physical Data Model

Try This 8-2: Mapping a Logical Model to a Physical Database Design

Try This 9-1: Modeling Business Rules

Try This 10-1: Adding History to Data Structures

Try This 11-1: Design Star Schema Fact and Dimension Tables

Try This 12-1: Enterprise Conceptual Model Development

Index