Joy Symphony Orchestra (JSO) plays two types of concerts: private parties and outdoor concerts and four...

 

Transcribed Image Text:

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. (a) Design an Entity-Relationship (ER) diagram for JSO. Convert the ER diagram 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. 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. (a) Design an Entity-Relationship (ER) diagram for JSO. Convert the ER diagram 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.