Goal Draw an Entity Relationship diagram using https://app.diagrams.net Scenario: Movies R US (MRU) has hired you...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) 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)
Expert Answer:
Answer rating: 100% (QA)
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... View the full answer
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these databases questions
-
You must have a driver's license to legally operate a motor vehicle in the United States. If you are new to driving, start with a learner's permit. Take your time and practice, and schedule your...
-
Algebraic Representation: Write the function that gives the height of water at a given time t measured in minutes for a tank that is 5 ft in diameter that has 4 feet of water in the tank at the...
-
For this milestone, you will frame the entity relationship model (ERM) and define the entities and attributes for the business. Your next steps will be to normalize your entities, define primary and...
-
Let R denote the set of continuous functions with domain R (as in calculus). Then R is a commutative ring with identity. The additive identity OR is the zero function (that is, the function h(x)...
-
A plane loop shown in Fig. 3.91 is shaped as two squares with sides a = 20 cm and b = 10 cm and is introduced into a uniform magnetic field at right angles to the loop's plane. The magnetic induction...
-
Explain the importance of having a cross-functional enterprise architecture.
-
What are the primary purposes of ESS and MSS? What are the advantages and disadvantages of each?
-
Sea Green Enterprises has the following assets and liabilities on its balance sheet: Sea Green has just lost a product liability suit with damages of $10 million being awarded to the plaintiff....
-
Assume the appropriate discount rate for the following cash flows is 9.4 percent. Year 1 234 Cash Flow $1,700 1,600 1,300 1,100 What is the present value of the cash flows?
-
It is January 2 and Twin Pines Farm is putting together its annual net worth statement Following are a nurmher of pieces of information they have collected. Help them fit it all together using the...
-
3. A tire starts from rest and rolls without slipping downhill at a constant acceleration of 13.6 m/s. The diameter of the tire is 170 cm. (a) Find the angular acceleration of the tire. (b) How long...
-
Interest rate swaps are agreements between two parties to exchange a fixed for a variable interest rate payment over a future period. a. The fixed rate payer in a swap typically pays the U.S....
-
If a video game costs $30 in the United States and 27 in the United Kingdom, what is the real video game exchange rate? Look up the current dollarpound exchange rate and compare the two prices. What...
-
Describe how moral hazard and adverse selection are managed by intermediaries and how they influence business finance.
-
In the aftermath of the financial crisis of 20072009, there were calls to reinstate the separation of commercial and investment banking activities that was removed with the repeal of the...
-
Options give the buyer (option holder) a right and the seller (option writer) an obligation to buy or sell an underlying asset at a predetermined price on or before a fixed future date. a. A call...
-
Which of the following statements contains an error? a) Select * from emp where empid = 10003; b) Select empid from emp where empid = 10006; c) Select empid from emp; d) Select empid where empid =...
-
Read the following description and Write a response of it. The discretion of public administrators can be decreased, but not altogether eliminated. Officials will use their discretion in any given...
-
What is a DFD? Why do systems analysts use DFDs?
-
Investigate the displays used in another field (e.g., aviation). What types of forms and reports are used in this field? What standards, if any, are used to govern the use of these outputs?
-
In Problem and Exercise 9-45, you developed integrated normalized relations. Choose primary keys for the files that would hold the data for these relations. Did you use attributes from the relations...
-
As wind speed is reduced, what happens to the sediment carried by wind?
-
How are surface processes different from tectonic processes?
-
Why is topsoil essential to conserve and protect? (a) Topsoil holds subsoil in place, preventing landslides. (b) Plants require topsoil to growand plants are vital because they provide food and...
Study smarter with the SolutionInn App