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.