Write descriptions for three data querying requirements

Assignment Help Database Management System

Reference no: EM131711617

Assignment: Query Your Classmate's Databas

In this sixth module, you will practice getting data back out of your database and manipulating data that are resident there. There are many ways for querying data and many ways to aggregate, group, and join your data. In this module's readings, you learned all about data manipulation language (DML), which is used to pull data out of a database and to manipulate data within the database. For the following discussion, you will get some practice with querying by doing some roleplay of real-world scenarios with your classmates.

Step I

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:

1. 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:

i. All sales transactions that occurred in the month of March
ii. All students enrolled in IT371 for the Fall 2018 semester
iii. The total amount spent per month on hair products

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

i. Change Bobby Ray's last name to "Jones"
ii. Change student number 64's birth date to 1/1/2001

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

i. Delete student number 23
ii. Delete all students enrollments for IT371 for the Fall 2018 semester

4. Attach your ER diagram to your post or

Step II

Select at least three classmates whose diagrams and queries sound . Write DML statements for each query and post them as replies to your classmates. Do not use a query generator or graphical tool to write these; write them on your own and test them in your chosen DBMS before posting. Try to pick classmates whose requirements have not been answered.

Reference no: EM131711617

Questions Cloud

Determine confidence interval about the mean difference : The standard error of the difference was 1.20. Establish a 99 percent confidence interval about the mean difference and write an interpretation.

Discuss houston food bank volunteering : Community engagement education or service learning is combination of learning goals and community service that enhance both student growth

Research and experience about scare tactics : Why are both "essentialistic" (or "objectivistic") and "constructionist" (or "subjective") definitions relevant to a sociological consideration of drug use?

How does cell phone use affect driving performance : How does cell phone use affect driving performance? Strayer, Drews, and Johnston (2003) had undergraduates drive a high-fidelity automobile simulator.

Write descriptions for three data querying requirements : Write descriptions for three data querying requirements that could be answered from the data stored in a database represented by your ER diagram.

How has the media defined crime and justice : Given the history of ad campaigns such as "this is your brain on drugs," should we be concerned about advertisements that teach us about crime?

Discuss what was it like to live in the ottoman rural : What was it like to live in the Ottoman rural or urban environment during the 18th century

Management implement new strategy : How could information systems help management implement this new strategy?

Calculate the depreciation for the second year : On June 1, Michael Company purchased equipment at a cost of $120,000, Using straight line depreciation, calculate the depreciation for the second year

User Account

All Pages