Goal: Draw an Entity Relationship diagram using Microsoft Visio Professional.
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:
For movies, include a unique identifier, the title, description, release date, genre, runtime, link to trailer, awards received, and user reviews.
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.
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.
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.
