Question: Please develop ER Model for the following situations, upload an e - copy of your ER model in LucidChart Concert, Inc., is a performance agency

Please develop ER Model for the following situations, upload an e-copy of your ER model in LucidChart
Concert, Inc., is a performance agency that organizes classical performances. A database is required to keep track of a concert planner, concert, conductor, performance, etc.
A concert planner may not or may schedule one or more concert. Each concert planner can be identified by a unique employee ID. Each concert planner receives a bonus according to the number of audiences.
A particular concert is scheduled for only one concert planner. Each concert can be identified by a unique concert number, and the same concert (e.g., Mozart special, classical music in movies) can be held more than once in a day or in a month. Concert, Inc. records the number of audiences to each concert.
For each concert, there is one conductor. A conductor may conduct any number of concerts or may not conduct any concerts. Conductors can form a mentor-mentee relationship. A mentor can have a relationship with a maximum of one mentee, and a mentee can also have a relationship with a maximum of one mentor.
A concert includes the performance of one or more compositions. Concert, Inc. also tracks average audience satisfaction for each composition performance.
A composition may be performed at one or more concerts or may not be performed. Each composition can be identified with a unique ID. Also, each composition has a composition name and composer's name.
 Please develop ER Model for the following situations, upload an e-copy

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!