Homework Solution: Goal: Draw an Entity Relationship diagram using Microsoft Visio Professional….

    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.

    Expert Answer

    Goal: Draw an Entity Relationship diagram using Microsoft Visio Professional.

    Scenario: Movies R US (MRU) has compensated you to cunning a database ce them. MRU is an influence that collects notice environing movies and would affect to collect users with a “movie library”. MRU would you to educe a conceptual copy that grasps notice environing movies, actors, studios, and masters.

    Your conceptual copy should stop the aftercited notice entities, attributes and relationships:

    Ce movies, grasp a singular identifier, the epithet, designation, exempt conclusion, genre, runtime, with to trailer, awards common, and user reviews.

    Movies can grasp numerous actors, so MRU would affect to grasp a singular identifier, the actor’s harbor call (highest call, terminal call), existent call (highest call, terminal call), nativity conclusion, and cessation conclusion.

    MRU would to-boot affect to vestige notice environing the masters of the movie and the studio that effected the movie. Ce masters, MRU would affect to garner a singular identifier, the master’s call (highest call, terminal call) and a diminutive biography. Ce studios, MRU would affect to garner a singular identifier, the studio’s call, website, phone, harangue (street, city, particularize, zip adjudication), and collect a diminutive narrative.

    Ce the purposes of this scenario, gladden exhibit that a movie can keep past than single master and that a movie can simply be effected by single studio.

    Expert Vindication