Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are asked to design part of a database about stage performers on sea-cruise shows, including information as follows: A performer has an employee number,

You are asked to design part of a database about stage performers on sea-cruise shows, including information as follows:

A performer has an employee number, given name, contact address, bank account number and a list of shows that they are ready to perform. Note being ready to perform on a show doesnt mean they actually will perform it (they could be in the capacity of an understudy). It is also desired to be able to list the IDs of cruises that the performer has actually performed on.

A show has a unique title, a duration and type. A show may require multiple performers.

A cruise has a cruise ID, a start and destination port and associated start and end dates, and a list of shows scheduled for during the cruise.

Based on the above information, model the database requirements as an Entity-Relationship (ER) diagram. Carefully state any assumptions that you make. In your ER diagram, you must properly denote all applicable concepts, including weak or strong entities, keys, composite or multi-valued attributes; relationships and their cardinality and participation constraints.

After presenting your ER model to management, you are asked if it can be used to perform the following additional task: produce, for each cruise, a list of scheduled shows and, for each such show, a list of the performers who performed on it.

Explain, referring to your ER model how to produce the requested list. If it is not possible to produce the list from the model, state why, modify the model and provide the modified ER diagram (in addition to your original ER diagram), explaining how it can accommodate this requirement.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

101 Database Exercises Text Workbook

Authors: McGraw-Hill

2nd Edition

0028007484, 978-0028007489

More Books

Students also viewed these Databases questions