Imagine you have been tracking your movie DVD collection using the spreadsheet Leave a reply 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. Heres a hint: The Rating table will look like this:RATINGCodeDescription1Excellent2Good This entry was posted in Health Care and Life Sciences : Health Care and Life Sciences on December 5, 2021 by .