Diagraming a database 1

Modeling a Database

Field list for DVDs

Groups: Entity should be about one thing: No multi valued groups

Candidate Key-- surrogate auto or random number for keys- Natural key is a natural field in the table

DVD

Title, length, Release Date, origin year, purchase year, number of disks, Rating, Description, Price, copyright

Actors

Name, gender, awards, alias

Features

FeatureType, description

Studio

Name, Location

Languages

name

Writer

Name

Genre

Name, description

Original list of fields

Name or title
director
Lead actors
Time length
Release year
Original year
Genre
Number of disks
Studio
Description
Writer
Language choices
Rating
Extras
Plot summary
Country of Origin
Date purchased
Price
copyright

Relationship types

Initial Diagram DVDs Actors

Data Examples