Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1 (ER/EER Diagram - Single Answer Multiple Choice Question) - 10 marks Write down the correct option (a, b, c, or d) in the

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Question 1 (ER/EER Diagram - Single Answer Multiple Choice Question) - 10 marks Write down the correct option (a, b, c, or d) in the provided answer aheet. There is only ONE correct answer. 5 marka will be awarded for the second-beat answer. "Punky Bizz" is a rental busines that rents musical inatrumente to bande. The Funky Bizz Operationi Database will keep track of inatruments that the busines owns. For each instrument, Funky Bizz will keep track of a unique inntrument nerial number as well an the inatrument model and brand, the year when the inatrument was made. and the age (measured in yeara) of the instrument. The customers of Funky Bizz are bandi. For each band, Funky Bizz will keep track of the unique band name ai well as the band's address, contact person's name. and a phone number. Funky Bizz also wante to atore the real name, alias name, and address of the band'a members. However if the information of the band is no longer required for whatever reason, the information of the members must be removed for privicy purposes. Funky Bizz will record information about shows that its curtomer bands perform in. For each show, it will keep track of a unique show identifier compoeed of the nhow venue name and date. For each ahow, it will also keep track of show type and uhow wize (in terms of the number of uudience). A band may perform in many ahown but doen not have to perform in any. Each show muat have at least ope band performing, but many have many bands performing. For each band, Funky Biza keeps track the order of their appearance in a thow. This is to track the popularity of the band. Which EER Diagram helow maat correctls models the problem deecribed above? band. Which EER Diagram below most correctly models the problem described above? b. Page 4 of 20 . d

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

Nested Relations And Complex Objects In Databases Lncs 361

Authors: Serge Abiteboul ,Patrick C. Fischer ,Hans-Jorg Schek

1st Edition

3540511717, 978-3540511717

More Books

Students also viewed these Databases questions

Question

What went well in the mediation process?

Answered: 1 week ago