Computer Science

INDIVIDUAL PROJECT ASSIGNMENT 3B (ORACLE CH.3B)

DUE DATE: DECEMBER 8, 2016, 5:30PM (20 points)

Refer to Problem-Solving Cases (pages156-157) in Oracle Chapter 3B. Datafile needed for this project assignment is Ch3Clearwater.sql that is attached to the assignment link for Project Assignment 3B

1. Solve all the odd problems 1, 5, 10, 15, 20 on pages 156-157.

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 Chapter3B_1_20_####_IN and output file as Chapter3B_1_20_####_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. 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 file and submit both the soft and hard copies.

POINTS WILL BE DEDUCTED IF THE DIRECTIONS ARE NOT FOLLOWED.

NOTE:

· These are individual assignments and any trace of student copying another student’s work will be given an automatic F for the course. Maintain the ethical integrity .

Mayur S. Desai (MIS 675 _ Fall 2016) Database Management Systems Page 1