Using only DOS-based Oracle SQL and answer for the following questions. Again, you MUST use DOS-based SQL. NOT accept other SQL programs. For each question, copy each screen shot of the DOS-based SQL code run/output screens, and paste them into your Assignment. For example: DOS-Based SQL 1. Create a table (table name must be your first name (first letter)+last_name, (e.g., Kwang Lee => KLEE). The table must include following columns (fields): (10 points)

-. CWID

-. Name

-. Date of Birth

-. Address

-. Etc

2. Insert columns (School, Department) into the table and delete a column (Etc) from the table. Then copy the screen shot of SQL code and an output screen, and paste into the Assignment (10 points). 3. Insert at least three virtual data (you and your two friend data) into the table and list the students name, CWIID, and Address who are Computer Science Department. Then copy the screen shot of SQL code and an output screen, and paste into the Assignment (10 points). 4. Create another table (table name DEPT). The table must include following columns (fields):

-. CWID

-. Name

-. Class name

-. Grade

Insert at least three virtual data (you and your two friend data) into the table and display the form using Views command. Then copy the screen shot of SQl code and an output screen, and paste into the Assignment (10 points).

5. Containing two tables relation, then identify a primary key and a candidate key. List the students name, class name, grade, and address where the students age is over 5 years using the relational commands (10 points).