Question: Paragraph Styles Save on your computer Select an ER diagram that you have worked on during one of the discussions in a prior module. This

 Paragraph Styles Save on your computer Select an ER diagram that

you have worked on during one of the discussions in a prior

Paragraph Styles Save on your computer Select an ER diagram that you have worked on during one of the discussions in a prior module. This ER diagram should be in at least third normal form and contain at least three tables and at least two relationships. Post an initial message, in which you do the following: 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 Ray's last name to "Jones"Change student number 64's 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 to your post 1. 2. 3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!