Imagine you have been tracking your movie DVD collection using the spreadsheet “

Imagine you have been tracking your movie DVD collection using the spreadsheet “Week13-MovieCollection.  Download Week13-MovieCollection.xlsx  Download xlsx”.  Now that you have become a Data Modeler, you decide to replace the spreadsheet with a relational database. 
First, design the logical data model and normalize it to Third Normal Form.
Notes: 
You should have seven entities in your data model: Movie, Actor, Actress, Movie_Actor, Movie_Actress, Rating, and Genre.
The note on “No Country for Old Men” will not be needed once your data model is complete.
Once you get the model into Second Normal Form, there may not be anything to do in order to transform it to Third Normal Form.
Finally, once your Data Model is complete, the 7 entities will become 7 tables in your database.  Sketch the 7 tables and their contents.  Here’s a hint:  The “Rating” table will look like this:
RATING
Code
Description
1
Excellent
2
Good