Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3.) Create an ER diagram that represents this situation. Movies show actors in roles. The role has a name. Each role in the movie

 

3.) Create an ER diagram that represents this situation. Movies show actors in roles. The role has a name. Each role in the movie relates to other roles as rivals. An example of rivals would be teams in the movie Glee where the role is best glee group. There are possibly many rivals for each role. There is also one particular role that relates to another role as a nemesis. An example of a nemesis is batman versus the jester where the role is dominant person in Gotham. Each role has only one nemesis. Show key(s). 4.) Construct an ER diagram representing the following situation. A "beer at a bar" is repesented as a combination of a particular bar having and name and address and a particular beer having a name and manufacturer. What is the key for "beer at a bar"? 5.) Construct an ER diagram representing the following situation: A sales-related company has StaffPersons. There are different kinds of staff, Salespersons, Administrative Assistants, and Managers. Only Managers get bonuses, only Admistrative Assistants are tested for word processing skill level, and only salespersons have a sales area and a car allowance. All staff have a name and SSN. The company has Branches, and a Manager manages only one Branch and a Branch has only one Manager. Staff all work in a particular branch.

Step by Step Solution

3.54 Rating (157 Votes )

There are 3 Steps involved in it

Step: 1

3 ER Diagram representing the situation Movies 1 M Actors 0 N Roles ... 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

Database management systems

Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff

3rd edition

72465638, 978-0072465631

More Books

Students also viewed these Programming questions

Question

Solve this system of equations -3x-y 5 -3x - 4y 83 || y = 1 11

Answered: 1 week ago

Question

What is the use of bootstrap program?

Answered: 1 week ago