Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Joy Symphony Orchestra (JSO) plays two types of concerts: private parties and outdoor concerts and four types of music: classical (western), Chinese, Malay, and Indian.

image text in transcribed

image text in transcribed

Joy Symphony Orchestra (JSO) plays two types of concerts: private parties and outdoor concerts and four types of music: classical (western), Chinese, Malay, and Indian. JSO always plays classical music on private parties and plays a blend of the four types of music when playing outdoors. It should be possible to find in the database the music works that are suitable for each type of concert so that the repertoire can be easily planned well in advance. For each musical work, the database should store the instruments required to play the work. The database should store composer names for classical music, but not for other types of music. The database should store information for each coming concert, i.e., the place, date and time of the concert as well as the type of concert and the repertoire that will be played. In particular, each private party should have the name and phone number of the contact person. Each outdoor concert may or may not require audio or video equipment. For each musician in JSO, the database should store his/her name and phone number, the instrument that he/she plays, and in which of the coming concerts he/she will participate. If you need additional information, you may make reasonable assumptions. Do this (a)_Design an Entity-Relationship (ER) diagram for JSO. (b) Convert the ER diagram in part (a) to a relational model. For each relation, state the highest normal form (up to 3NF) in which the relation is in and explain your answer. ER Diagram CONCERT OUTDOOR CONCERT PARK Phone on Person FK Music CC REPERTOIRE MUSIC WORK, PRIVATE PARTY instruments MUSIC Pron Contact Person Suitable Concerts Music AlEelamae

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

Mastering Apache Cassandra 3 X An Expert Guide To Improving Database Scalability And Availability Without Compromising Performance

Authors: Aaron Ploetz ,Tejaswi Malepati ,Nishant Neeraj

3rd Edition

1789131499, 978-1789131499

More Books

Students also viewed these Databases questions