Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Goal Draw an Entity Relationship diagram using https://app.diagrams.net Scenario: Movies R US (MRU) has hired you to design a database for them. MRU is

Goal Draw an Entity Relationship diagram using https://app.diagrams.net Scenario: Movies R US (MRU) has hired 

Goal Draw an Entity Relationship diagram using https://app.diagrams.net 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: 1. For movies, include a unique identifier, the title, description, release date, genre, runtime, link to trailer, awards received, and user reviews. 2. 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. 3. 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. 4. 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. Reading through the description above, think about the entities you would need to create (remembering that they would each be a table in a database), the attributes each record in the entity wold have (and which attribute would uniquely identify the record), and how each of the entities are related to each other. Submission: Save your diagram as a PNG or JPG file. Submissions in any other format will NOT be graded. Submitted file should be named using the following schema IS206-A4-NetlD.png (or .jpg) (eg IS206-A4-CSEVANS2.png)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

This is a stepbystep on how you can create an EntityRelationship Diagram ERD using the online tool drawio httpsappdiagramsnet 1 Open drawio in your we... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Systems Analysis And Design

Authors: Joseph Valacich, Joey George

8th Edition

0134204921, 978-0134204925

More Books

Students also viewed these Databases questions

Question

What is a DFD? Why do systems analysts use DFDs?

Answered: 1 week ago