Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistical And Scientific Database Management International Working Conference Ssdbm Rome Italy June 21 23 1988 Proceedings Lncs 339

Authors: Maurizio Rafanelli ,John C. Klensin ,Per Svensson

1st Edition

354050575X, 978-3540505754

More Books

Students also viewed these Databases questions

Question

Define opportunity cost.

Answered: 1 week ago

Question

=+1. What does this key public know about this issue?

Answered: 1 week ago

Question

Explain the Neolithic age compared to the paleolithic age ?

Answered: 1 week ago

Question

What is loss of bone density and strength as ?

Answered: 1 week ago