Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Joy Symphony Orchestra (ISO) 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

Joy Symphony Orchestra (ISO) 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. (a) Design an Entity-Relationship (ER) diagram for JSO

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

More Books

Students also viewed these Databases questions