DBM 294 Week 3 Individual Assignment Data Manipulation Language


Ask a Question

DBM 294 Week 3 Individual Assignment Data Manipulation Language

Sale price $15.00 Regular price $30.00

DBM 294 Week 3 Individual Assignment  Data Manipulation Language


 
Instructions:

Extend the SQL script you developed for the Week Two individual

assignment.

Populate the tables you created with appropriate sample data. Use at

least 5 rows for each table. Some tables may require more than 5 rows

to create a sensible data set. Take all of the INSERT commands you

used to add this data and add them to your SQL script.

Write additional SQL commands in your script that demonstrate use of

the following keywords and techniques (one separate command to

demonstrate each bullet). These commands should interact with the

tables you have been creating.

  • UPDATE
  • DELETE
  • BETWEEN
  • LIKE
  • TOP
  • DISTINCT
  • Named columns
  • Calculated columns

Using the Assignment Files tab:

Submit your SQL script.

Submit a document containing screen shots of each SQL command

and the corresponding output

Questions & Answers

Have a Question?

Be the first to ask a question about this.

Ask a Question