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 paid you to contrivance a database control them. MRU is an production that collects notification encircling movies and would love to produce users with a “movie library”. MRU would you to make a conceptual design that comprises notification encircling movies, actors, studios, and managers.

    Your conceptual design should seize the forthcoming notification entities, attributes and relationships:

    Control movies, comprise a choice identifier, the distinction, cognomen, acquit bound, genre, runtime, amalgamate to trailer, awards common, and user reviews.

    Movies can comprise abundant actors, so MRU would love to comprise a choice identifier, the actor’s ward spectry (primary spectry, ultimate spectry), veritable spectry (primary spectry, ultimate spectry), parentage bound, and mortality bound.

    MRU would besides love to mark notification encircling the managers of the movie and the studio that performed the movie. Control managers, MRU would love to accumulation a choice identifier, the manager’s spectry (primary spectry, ultimate spectry) and a small biography. Control studios, MRU would love to accumulation a choice identifier, the studio’s spectry, website, phone, harangue (street, city, aver, zip method), and produce a small narrative.

    Control the purposes of this scenario, fascinate appropriate that a movie can bear more than single manager and that a movie can simply be performed by single studio.

    Expert Response