"A designer can mull over..."

Database Design

Information Requirements

Entity Classes

Attributes

Relationships

Relationships (cont.)

Designing a Database

 Who cares about models?

Modeling Database Structures

Slide 11

Peter Chen
Entity-Relationship Diagrams

ERD Notation

ERD Notation

   ERD Notation (cont.)

   ERD Notation (cont.)

The Products ERD

Designing a Database

Edgar F. Codd
Relational Data Model

Relations

Example

Representing Relationships

Representing Relationships

One-to-Many Relationships

Many-to-Many Relationships

Recursive Relationships

Integrity Constraints

Referential Integrity

Enforcing Referential Integrity

Designing a Database

A 7th Grade Punishment

A 7th Grade Punishment

A 7th Grade Punishment

Relational Schema Punishment

Functional Dependencies

Normal Forms

Normalization

Designing a Database