DatabaseDesign
lily33
CMIS320Project2.docx
1
CMIS 320 Project 2: Database Design for Mom and Pop Johnson Video Store
Student:
Institution:
Course:
Instructor:
Date:
Screenshot of the ERD
Metadata
|
Entity Name |
Attributes |
PK/FK |
Data Type |
Description |
|
Customer |
CustomerID |
PK |
Integer |
Primary Key for Customer entity |
|
|
Name |
|
Varchar (255) |
Customer Name |
|
|
Address |
|
Varchar (255) |
Customer Address |
|
|
TelephoneNumber |
|
Varchar (20) |
Customer Telephone Number |
|
Movie |
MovieID |
PK |
Integer |
Primary Key for Movie |
|
|
Title |
|
Varchar (255) |
Title of Movie |
|
|
ReleaseYear |
|
Integer |
Release Year of Movie |
|
|
Rating |
|
Char (1) |
Customer rating of Movie |
|
|
Length |
|
Integer |
Length of Movie in minutes |
|
Video/DVD Copy |
CopyID |
PK |
Integer |
Primary Key for Video/DVD Copy |
|
|
MovieID |
FK |
Integer |
Foreign Key pointing to Movie |
|
|
Format |
|
Varchar (10) |
Format of the copy (VHS/DVD) |
|
|
DistributorID |
FK |
Integer |
Foreign Key pointing to Distributor |
|
|
UniqueID |
|
Varchar (255) |
Unique Identifier for the copy |
|
Rental |
RentalID |
PK |
Integer |
Primary Key for Rental |
|
|
CustomerID |
FK |
Integer |
Foreign Key pointing to Customer |
|
|
CopyID |
FK |
Integer |
Foreign Key pointing to Video/DVD Copy |
|
|
RentalDate |
|
Date |
Date when the video/DVD was rented |
|
|
ReturnDate |
|
Date |
Date when the video/DVD was returned |
|
|
LateFee |
|
Decimal |
Late fee charged |
|
|
DamageFee |
|
Decimal |
Fee for damages |
|
|
Tax |
|
Decimal |
Tax charged |
|
Distributor |
DistributorID |
PK |
Integer |
Primary Key for Distributor |
|
|
CompanyName |
|
Varchar (255) |
Distributor Company Name |
|
|
Country |
|
Varchar (255) |
Country of Distributor |
|
Genre |
GenreID |
PK |
Integer |
Primary Key for Genre |
|
|
GenreName |
|
Varchar (255) |
Name of the Genre |
|
Actor/Actress |
ActorID |
PK |
Integer |
Primary Key for Actor/Actress |
|
|
Name |
|
Varchar (255) |
Name of the Actor/Actress |
|
Director |
DirectorID |
PK |
Integer |
Primary Key for Director |
|
|
Name |
|
Varchar (255) |
Name of the Director |
|
Award |
AwardID |
PK |
Integer |
Primary Key for Award |
|
|
AwardName |
|
Varchar (255) |
Name of the Award |
|
|
AwardCategory |
|
Varchar (255) |
Category of the Award |
|
|
Year |
|
Integer |
Year the award was won |
