Goal Draw an Entity Relationship diagram using https://app.diagrams.net Scenario: Movies R US (MRU) has hired you...

 

Transcribed Image Text:

Goal Draw an Entity Relationship diagram using https://app.diagrams.net Scenario: Movies R US (MRU) has hired you to design a database for them. MRU is an agency that collects information about movies and would like to provide users with a "movie library". MRU would you to create a conceptual model that includes information about movies, actors, studios, and directors. Your conceptual model should capture the following information entities, attributes and relationships: 1. For movies, include a unique identifier, the title, description, release date, genre, runtime, link to trailer, awards received, and user reviews. 2. Movies can include many actors, so MRU would like to include a unique identifier, the actor's screen name (first name, last name), real name (first name, last name), birth date, and death date. 3. MRU would also like to track information about the directors of the movie and the studio that produced the movie. For directors, MRU would like to store a unique identifier, the director's name (first name, last name) and a brief biography. For studios, MRU would like to store a unique identifier, the studio's name, website, phone, address (street, city, state, zip code), and provide a brief history. 4. For the purposes of this scenario, please assume that a movie can have more than one director and that a movie can only be produced by one studio. Reading through the description above, think about the entities you would need to create (remembering that they would each be a table in a database), the attributes each record in the entity wold have (and which attribute would uniquely identify the record), and how each of the entities are related to each other. Submission: Save your diagram as a PNG or JPG file. Submissions in any other format will NOT be graded. Submitted file should be named using the following schema IS206-A4-NetlD.png (or .jpg) (eg IS206-A4-CSEVANS2.png) Goal Draw an Entity Relationship diagram using https://app.diagrams.net Scenario: Movies R US (MRU) has hired you to design a database for them. MRU is an agency that collects information about movies and would like to provide users with a "movie library". MRU would you to create a conceptual model that includes information about movies, actors, studios, and directors. Your conceptual model should capture the following information entities, attributes and relationships: 1. For movies, include a unique identifier, the title, description, release date, genre, runtime, link to trailer, awards received, and user reviews. 2. Movies can include many actors, so MRU would like to include a unique identifier, the actor's screen name (first name, last name), real name (first name, last name), birth date, and death date. 3. MRU would also like to track information about the directors of the movie and the studio that produced the movie. For directors, MRU would like to store a unique identifier, the director's name (first name, last name) and a brief biography. For studios, MRU would like to store a unique identifier, the studio's name, website, phone, address (street, city, state, zip code), and provide a brief history. 4. For the purposes of this scenario, please assume that a movie can have more than one director and that a movie can only be produced by one studio. Reading through the description above, think about the entities you would need to create (remembering that they would each be a table in a database), the attributes each record in the entity wold have (and which attribute would uniquely identify the record), and how each of the entities are related to each other. Submission: Save your diagram as a PNG or JPG file. Submissions in any other format will NOT be graded. Submitted file should be named using the following schema IS206-A4-NetlD.png (or .jpg) (eg IS206-A4-CSEVANS2.png)

Answer rating: 100% (QA)

This is a stepbystep on how you can create an EntityRelationship Diagram ERD using the online tool drawio httpsappdiagramsnet 1 Open drawio in your we... View the full answer