Prepare dml statement for each dml requirement

Assignment Help Database Management System

Reference no: EM131721226

Assignment

In the last module, you build your database. But a database without any data isn't useful at all! In the last module, you build your database. But a database without any data isn't useful at all! So now that you have had some practice in writing SQL queries and you have a functional database in at least third normal form (from the previous module), it's time to populate your database and write some queries!

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 GUI 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 II:

• 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

• A screenshot of the resulting query output when executed on your database.

Reference no: EM131721226

Questions Cloud

Define stages of conducting a feasibility analysis : Nate Jones, a friend of yours, is in the early stages of conducting a feasibility analysis for an e-commerce website that will focus on the sale of products.

Supply more of a good when the price increases : Why is it that producers are willing to supply more of a good when the price increases?

Describe the gestures : What kind of gestures did you see? Describe the gestures. Don't just say, "she used her hands a lot." How?

The standard variable overhead application rate : Calculate (and provide details for) each of the following variances. The standard variable overhead application rate. The total overhead spending variance

Prepare dml statement for each dml requirement : In a Word document, prepare the following for each DML requirement you came up during Step II: The description for your requirement.

Example related to environmental justice : Can you think of an example related to environmental justice? No landfill though as we have had extensive discussions on that example.

Evaluate kelly approach to selling products : Kelly Andrews has developed a new line of jewelry that has created some positive buzz among friends and some stores in her local community.

Analysis of cybersecurity occurrence and data defense : Identification of cybersecurity tenets that were violated and rationale of cause

Develop a new type of space heater : Shannon has developed a new type of space heater that is quieter and safer than previous generations of space heaters and is particularly geared to people.

User Account

All Pages