
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 outputQuestions & Answers
Have a Question?
Be the first to ask a question about this.