Write descriptions for three data querying requirements that could be answered from the data stored in a database represented by your ER diagram. Your classmates will provide answers based on the requirements. Answers to your three requests should contain at least one JOIN; an aggregation function ; a GROUP By clause; and a WHERE or HAVING clause. Some examples:

All sales transactions that occurred in the month of March

All students enrolled in IT371 for the Fall 2018 semester

The total amount spent per month on hair products

Write descriptions for two modifications for data already in the database. Some examples:

Change Bobby Rays last name to Jones

Change student number 64s birth date to 1/1/2001

Write descriptions for two deletions for data already in the database. Some examples:

Delete student number 23

Delete all students enrollments for IT371 for the Fall 2018 semester

Attach your ER diagram