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.