Question: Step I Populate your database that you created in module 5 with some representative testing data. Include at least 15 records for each of the

 Step I Populate your database that you created in module 5

with some representative testing data. Include at least 15 records for each

of the tables (use INSERT commands or GUl tools provided by the

DBMS you select). Step II Think of descriptions for six data querying

Step I Populate your database that you created in module 5 with some representative testing data. Include at least 15 records for each of the tables (use INSERT commands or GUl tools provided by the DBMS you select). Step II Think of descriptions for six data querying requirements that could be answered from the data stored in your database, three requirements to change data already in the database, and three requirements to delete data already in the database. Answers to your querying requirements should contain at least two JOINs; two aggregation functions; a GROUP BY clause; and three WHERE or HAVING clauses. See the discussion instructions for examples. Step III In a Word document, prepare the following for each DML requirement you came up during Step li: . The description for your requirement . The DML statement (SQL command) that will get you the data you need - do not use a query generator or graphical tool to write this: write it on your own e A screenshot of the resulting query output when executed on your database

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!