Scribd
Upload
15 views2 pages

IMDb Movie Database ER Diagram

The document outlines a group project focused on exploring the Internet Movie Database (IMDb) to identify the entities and attributes relevant to its database. Key entities include Genre, Movies, Serial, User, and Actor, along with their respective attributes. The relationships between these entities, such as 'Belongs_to', 'Watches', 'Acts', and 'Likes', are also described, suggesting a structured approach to presenting their findings using Google tools.

Uploaded by

Faizan Hameed
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
15 views2 pages

IMDb Movie Database ER Diagram

The document outlines a group project focused on exploring the Internet Movie Database (IMDb) to identify the entities and attributes relevant to its database. Key entities include Genre, Movies, Serial, User, and Actor, along with their respective attributes. The relationships between these entities, such as 'Belongs_to', 'Watches', 'Acts', and 'Likes', are also described, suggesting a structured approach to presenting their findings using Google tools.

Uploaded by

Faizan Hameed
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

QUESTION: With your team of three or four students, select an online database to explore, such as

AOL Music, [Link], or the internet Movie Database. Explore one of these websites to see what
information it provides. Then list the entities and attributes that company running the website must
keep track of in its databases. Diagram the relationship between the entities you have identified. If
possible, use Google Docs and Google Drive or Google Sites to brainstorm, organize, and develop a
presentation of your findings for the class.

We have chosen Internet Movie Database (IMDb):  is an online database of information related to films,
television programs, home videos, video games, and streaming content online – including cast,
production crew and personal biographies, plot summaries, trivia, ratings, and fan and critical reviews.
The movie and talent pages of IMDb are accessible to all internet users, but a registration process is
necessary to contribute information to the site.

Here some entities and attributes are enlisted that we identified;

E – R Diagram

Entities and Attributes:

Genre (Genre_id, Genre_name)

Movies (movie_id, movie_name, language, released_date)

Serial (serial_id, serial_name, language, released_date, time)

User (user_id, name, email_id, age, gender)


Actor (actor_id, actor_name, gender, picture, age)

Relationships:

Belongs_to (Genre, Movies)

Belongs_to (Genre, Serial)

Watches (Movie, User)

Watches (Serial, User)

Acts (Actor, Movie)

Acts (Actor, Serial)

Likes (User, Genre)

Relationship Model:

You might also like