Database Systems Help:

1. Draw an Entity-relationship diagram for the following description of a symphony orchestra. You can use any design or drawing tool for this (the notes use Google Draw).

A concert season schedules one or more concerts. A particular concert is scheduled for only one concert season. Identifier of the concerts season is the opening date, which includes month, day, and year.

A concert includes the performance of one or more compositions. A composition may be performed at one or more concerts or may not be performed. Identifier of the concert is a concert number. Another important attribute is concert date, which consists of the following: Months, day, year, and time. Each concert typically has more than one concert date.

Compositions are identified by a composition id. Other attributes are composer name and composition name. Compositions may have multiple movements with a movement name and movement number.

For each concert there is one conductor. A conductor may conduct any number of concerns or may not conduct any concerts. The identifier of the conductor is conductor id. Another attribute is conductor name.

Each composition may require one or more soloists or may not require a soloist. A soloist may perform one or more compositions at a given concert or may not perform any composition. The symphony orchestra wishes to record the date when a soloist last performed a given composition (Last Date Performed). The identifier for the soloist is a soloist id. Another attribute is the soloist name.

2. Draw a relational diagram for the above ER diagram. You can either use a drawing or database modeling tool for this task, or you can create the corresponding tables in Microsoft Access and submit the Access database.