DBM 294 Week 3 Individual Assignment Data Manipulation Language

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