In the process of completing this assignment, deliver the following:
1. Complete 1 and 2 of the case exercises in Chapter 7.
a. For exercise 2, pick any 6 of the problems a-k.
2. For each question, define a problem (i.e., tell me in words what you are trying to do) and use SQL to execute the commands to produce the appropriate results.
What to Turn in: Document all of your SQL scripts by copying the script and the results of the query into an MS Word file. As with the previous assignment, please include a listing of the data in each table and the table fields (i.e., use the SELECT * command to show table contents and use the DESCRIBE command to show the table fields). Show all of the commands that you typed in for the queries and other commands in 1-2. Also include any output that is generated when the SQL commands are executed (if you can’t get it to work, show what you did; partial credit will be applied where appropriate). Each section of the project should be clearly labeled (e.g., designate which problem you are solving). The file components should be neatly and logically organized (e.g., place the commands for creating and inserting the tables in proximity to the display showing the records in the tables).
Note: I am open to other suggestions for assignment deliverables. If you wish to identify a different type of SQL problem that demonstrates competence in executing comparable SQL statements, please see me at least one week before the assignment is due with specifications on your suggested deliverables.