General Rules

Make some reasonable assumptions about which attributes will be mandatory throughout the model.

For example, within the movie table you would expect the title to be mandatory.

The database will only store information about Movies.

no music or subscription$-$based services

the system does not have to deal with refunds

Specific Details

Categories

Categories should be based on the categories from the Shaw VOD website. A category can have sub$-$

categories.

Drama

Thrillers, Emotional, Award Winning

Movies$/$Titles

movies can be associated with multiple categories

a movies can have multiple advisories

"New Releases", "Most Popular", "Coming Soon" are binary attributes of the movie $(0,1)$

There will be an SD and HD price from each movie

store the duration in minutes

duration for all movies should be greater than $0$

movie rating $($G$,$ PG$,14$A$,...)$

httos:$//$www$.$alberta.ca$/$how$-$alberta$-$classifies$-$films.aspx

Advisory

short advisory description

full advisory description

httos:$//$www$.$alberta.ca$/$how$-$alberta$-$classifies$-$films.aspx

Rental

need to remember a customer's rating on the rental

when the customer rented it

when the customer started viewing it

when the rental will expiry $(24$ hours from when the customer started viewing it$)$

For each rental, store the amount of the rental and the credit card that it was charged to

price paid

credit card charged

Credit$\_$card$\_$num should be all digits

type of credit card used

credit card type should be $\{Ax,MC,VS\}$

the rental expiry date should be $>$ the date when the customer starting viewing it

the customer start viewing date $>$ the date when the customer rented it

customer rating $1-5$ stars

Actor$/$Actresses

first name, last name and date of birth

email address $-$ should be unique

For each Actor$/$Actresses $-$ Movie combination

store the actor$/$actresses role name in that movie

Director