1. On page 25 Clearwater Traders database change the last and the first name of the customer (i.e. the first record C_LAST Graham, C_FIRST Neal) with C_ID to your last and first name. Save the table as CUSTOMER_last four digits of your student ID. Then proceed with the following:
2. Solve the problems 4 on page 119. In order to complete this assignment you must go over the tutorial on Northwoods database starting on Page 87.
3. You will create one input file and one output file (using notepad) as instructed in the class. SQL for all the problem 4 should be contained in one input file. Name the input file as Chapter3A_1_3_####_IN and output file as Chapter3A_1_3_####_OUT where #### is the last four digits of your student ID
4. Include comment lines for each problem while writing SQL and include them before the SQL code for each problem. Comment should refer to what the problem is about. For example, when writing and SQL for problem 4 you may include a comment “the following SQL provides the code (describe what the code will accomplish) in Clearwater Traders database”.
5. In the beginning of the input file you must include your name, course number and semester, project number, and your student ID.
6. Print hard copies of the input and output file and submit both the soft and hard copies.
Mayur S. Desai (MIS 675 _ Fall 2016) Database Management Systems Page 1
Homework Pro
3a_0.docx
0
