PLEASE ANSWER ALL QUESTIONS!!!!!!!

With the above ER diagram complete the following tasks:

a. Create the tables. Include different table constraints (e.g. primary key, foreign key, check, etc.).

b. Insert at least two records to each table.

c. Write at least 9 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 b.

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

CONCERT SEASON Season Open Dat Year, Month, Day) Schedules CONDUCTOR CONCERT Concert Number Conductor IDH Conductor NameConducts (Concert Date, Time, Year, Month, Day)) SOLOIST Soloist ID Soloist Name PERFORMANCE Date Last Performedy COMPOSITION Composition ID (Composer Name, Composition Name) Movement ID (Movement Name, Movement Number)) CONCERT SEASON Season Open Dat Year, Month, Day) Schedules CONDUCTOR CONCERT Concert Number Conductor IDH Conductor NameConducts (Concert Date, Time, Year, Month, Day)) SOLOIST Soloist ID Soloist Name PERFORMANCE Date Last Performedy COMPOSITION Composition ID (Composer Name, Composition Name) Movement ID (Movement Name, Movement Number))