IT234M1 Unit 1 – Assignment
My entities are as follows: Lead Star, Director, Producer, Movie, and Genre. These entities were chosen as they are unique items in the movie database.
Since these the movie entities can be drilled down even further via attributes such as Director first and last name, Producer first and last name, Lead Star first and last name, and Genre there is no need for the ratings table since the ratings is just numbers.
For this section I have given my entities ID’s the thought behind this is for example, one movie star can be in many different movies or there may be many different Directors or Producers for one movie.
With providing an ID to these items it allows the user’s search to narrow down the information. A primary key originates from the table and a https://www.solvedcollegepapers.com/product/it-234-unit-1-assignment
https://www.solvedcollegepapers.com/product/it-234-unit-7-assignme-2
