Database Design: Conceptual Model and ER Diagramming

9/8/99


Click here to start


Table of Contents

Database Design: Conceptual Model and ER Diagramming

Review

Database Design Process

Entity

Attributes

Relationships

Relationships

Types of Relationships

More Complex Relationships

Weak Entities

Supertype and Subtype Entities

Many to Many Relationships

Today

Developing a Conceptual Model

Primary Business Operations

Business Operations (cont.)

Business Operations (cont.)

Business Operations (cont.)

Business Operations (cont.)

Entities

Diveshop ER Entities: DiveCust

Diveshop ER Entities: DiveOrds

Diveshop ER Entities: DiveItem

Diveshop ER Entities: ShipVia

Diveshop ER Entities: DiveStok

Diveshop ER Entities: Dest

Diveshop ER Entities: Sites

Diveshop ER Entities: Biolife

Diveshop ER Entities: Shipwrck

Functional areas

Ordering

Ordering

Ordering Normalization

Details of DiveItem

Ordering: Full ER

Location/Site Selection

Destination/ Sites

Sites and Sea Life 1

Diveshop ER diagram: BioSite

Sites and Sea Life 2

Sites and Shipwrecks

DiveShop ER Diagram

What is Missing??

 Author: Ray R. Larson

Email: ray@sherlock.berkeley.edu

Home Page: http://sims.berkeley.edu/~ray

Download presentation source