You will be designing and creating a database to store information about various movies as well as the main actors in that movie and the director$($s$).$ For each movie, your database will need to store the following: its title, the year it was made, the movie type $($action$,$ comedy, etc.$),$ the MPAA rating $($G$,$ PG$,$ R$,$ etc.$),$ how many awards it was nominated for, and the number of awards it won. For each actor, you will need: their name $($first and last$),$ date of birth, date of death $($if relevant$),$ and their birth place. For each director, you will need the same information, except that birth place is not needed. Bear in mind that we can have several actors and$/$or several directors listed for each movie.

Steps $1$ and $2$ will need to be completed without seeing an example of the movie data, as I want you to consider the assumptions you have to make in a situation where the data is not yet available. The data file, Student Movie Data.doc, will available on Aims Online after you have submitted your ER diagram with DBDL notation.

Include:

$1)$ All tables listed using DBDL notation format. Include the primary and foreign keys as well as any assumptions you are making using the example below. $(5$ pts$)$

Employee $($EmployeeNum$,$ LastName, FirstName, Street, City, State, Zip, WageRate, SocSecNum, DepartmentNum$)$

FK DepartmentNum $->$ Department

Primary key must be unique, first and last name cannot be null

Department num references the department table and must match a value in that table

SocSecNum will be stored without dashes; $9-$digit Zip $($Zip$+4)$ needed $($no dashes stored$)$