Database Design

Outline

Database Design

Database Design Formalisms

1. Object Definition Language

"Basic design paradigm in ODL"

ODL Class Declarations

ODL Example

ODL Declarations

ODL Example Extended

ODL Declarations, Extended

ODL Example, Extended Again

ODL Declarations, Extended Again

Types in ODL

Collection Types

Allowable Types in ODL

2. Entity / Relationship Diagrams

Slide 18

What is a Relation ?

Multiplicity of E/R Relations

Multi-way Relationships

Arrows in Multiway Relationships

Arrows in Multiway Relationships

Arrows in Multiway Relationships

Roles in Relationships

Attributes on Relationships

Converting Multi-way Relationships to Binary

3. Design Principles

Design Principles:
What’s Wrong?

Design Principles:
What’s Wrong?