Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started