Unit 1

Entity List

1. Title
2. Director
3. Genre
4. Lead_Star
5. IMDb_Rating

Unit 1

I made this list because they do represent an object in the system that we want to model.

Title would be a record name entity in this table, it is providing a name for the movie. Director and Lead Star would be considered as people type entities, because they represent people in the movie database. Genre would be said to be an idea, this entity is grouping all the same type of movies together. Without this entity the movies would be without description and you wouldn’t know what type of movie it was. The IMDb Rating would be considered as a document type entity, meaning this entity would provide everyone with an evaluation of how the movie was.

Unit 2

With these entities they each have attributes that connect to one or more tables. Below is a break down on how these entities connect to each of the other tables.

Title: A title is linked to all of the entities but they are only 1 to 1 connections.

Example: Finding Nemo has one Director, one Lead Star, One IMDb Rating, and one Genre.

Director: A Director has multiple connections unlike the title entity so it is defined as a 1 to many. Director directs multiple titles, directs multiple lead stars, receives multiple IMDb ratings, and directs multiple titles in different genres.

Genre: This entity is considered a many too many and a many to 1. You can have multiple genre types pointing to multiple directors and multiple lead stars. On the other side you can have one Genre pointing to multiple movie titles.

Lead Star: Considered 1 too many, because they are individuals that can play in different movies. Also be directed by multiple directors, have a role in multiple genres, and receive multiple ratings due to the different movies they act in.

IMDb rating: The rating is described to rate all of the other entities, that is how they receive the rating number. A lead star receives his/her own rating, same as the title, and same as the director.

Brandon Hart IT234 Database Concepts

Unit 1

Brandon Hart IT234 Database Concepts Unit 1 Powered by TCPDF (www.tcpdf.org)