Instructions: Create a database design (schema) based on the following problem description. You need to list the tables, the fields, the primary key of each table, and all foreign keys. You will probably want to draw this on paper, though there are free tools to create diagrams.
Sample domain description for a movie database
A DVD collection contains many movies. Each movie is in one or more genre. Each movie has 1 or more actors in it. Each actor can be in multiple movies. Each movie has a title and an MPAA rating. Each actor has a name, gender, and birthday. Assume that the DVD collection does not contain multiple copies of the same movie.
Instructions: Based on feedback from Homework 1, make corrections to your database design (schema) based on the following problem description. You need to list the tables, the fields and datatypes, the primary key of each table, and all foreign keys. You will probably want to draw this on paper, though there are free tools to create diagrams. Note the addition of datatypes.
You may upload your results to Canvas or turn it in on paper.
Sample domain description for a movie database
A DVD collection contains many movies. Each movie is in one or more genre. Each movie has 1 or more actors in it. Each actor can be in multiple movies. Each movie has a title and an MPAA rating. Each actor has a name, gender, and birthday. Assume that the DVD collection does not contain multiple copies of the same movie