Concert, Inc., is a performance agency that organizes classical perflermances. 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$-$mentec 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.