Databases and Database Design

Click here to start

Click here for session outline

Table of Contents

Databases and Database Design

Databases & Database Design

Introduction

Introduction (continued)

Relational Database Model

Relational Database Model

Attributes

Retrieval in RDMS

Advantages of RDMS

Relational Model: Summary

Relational Model: Summary 2

Database Design: Data Models

Data Models

Data Model Quality

Entity

Entity Guidelines

Attribute

Attribute Characteristics

Attribute Characteristics

Attribute Guidelines

Primary Key

Primary Key Characteristics

Relationship

Relationship Guidelines

Single Relationship of Entities

Recursive Relationships

Normalization

Key Normalization Concept

Benefits of Normalization

Summary of Normalization

Common DB Design Errors

Data Model Quality

Database Design Pearls

References - 1

References - 2

Author: William A. Yasnoff, MD, PhD.

Email: way2@cdc.gov

Download presentation source

Return to Curriculum