1. Solve all the even problems 2, 6, 8, and 10 on pages 188.
2. You will create one input file and one output file (using notepad) as instructed in the class. SQL for all the problems should be contained in one input file. Name the input file as Chapter3C_1_10_####_IN and output file as Chapter3C_1_10_####_OUT where #### is the last four digits of your student ID.
3. Include comment lines for each problem while writing SQL and include them before the SQL code for each problem. Comment should refer to each of the query asked in the question. Make sure to identify each question answered. In the beginning of the input file you must include your name, course number and semester, project number, and your student ID.
4. Print hard copies of the input and output files and submit both the soft and hard copies.
POINTS WILL BE DEDUCTED IF THE DIRECTIONS ARE NOT FOLLOWED.
Mayur S. Desai (MIS 675 _ Fall 2016) Database Management Systems Page 1