After completing a course in database management, you have been asked to develop a preliminary ER diagram for a symphony orchestra. You discover that the following entity types should be included: Concert Season the season during which a series of concerts will be performed. Identifier is opening_date, which includes month, day and year. Concert a given performance of one or more compositions. Identifier is concert_number. Another important attributes are month, day, year and time a given concert will be performed. Composition compositions (music or song) to be performed at each concert. Identifiers are composer_name and composition_name. Another attribute is movement_id. Conductor person who will conduct the concert. Attributes are conductor_id and conductor_name. Soloist solo artist (performer) who performs a given composition on a particular concert. Attributes are soloist_id and soloist_name. During further discussions you discover the following: A concert season schedules one or more concerts. A particular concert is scheduled for only one concert season. A concern includes the performance of one or more compositions. A composition may be performed at one or more concerts, or may not be performed. For each concert there is one conductor. A conductor may conduct any number of concerts, or may not conduct any concerts. 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.

Task 1: Construct the Entity Relationship Diagram (ERD) for the above given scenario. Identify the different entities, the attributes of each entity including the Primary key, and the relationship between the entities.

Include different table constraints (e.g. primary key, foreign key, check, etc.)

b. Insert at least five records to each table.

c. Write at least 8 different SQL SELECT statements with WHERE clauses that will show different result.

d. Write one SQL statement that uses any one of the aggregate functions with group by clause.

e. Write one update statement that will modify the data inserted in task 3b.

f. Alter any of the tables by adding a new column