ome 1. Using DOS-based Orade SQL to create a table (table name must be your la (e.g, Kwang Lee-> KLEE). The table must indlude following columns (fields): CWID -. Name -. Date of Birth . Address . Etc Then copy the screen shot (code and result) and insert here (10 points). 2. Insert columns (School, Department) into the table and delete a column (Etc) from the table. Then copy the screen shot (code and result) and insert here (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 Sclence Department. Then copy the screen shot (code and result) and insert here (10 points). 4. Using Orade SQL to create another table (table name DEPT). The table must indlude 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 (code and result) and insert here ( 0 points). 5. Containing two tables relation, then identify a primary key and a candidate key. List the students name, dlass name, grade, and address where the students' age is over 5 years using the relational commands. Then copy the screen shot (code and result) (20 points). 6. Consider the following relational database for Happy Cruise ines (See the attached file). It keeps track of ships, cruises, ports, and passengers. A "cruise" is a particular sailing of a ship on a particular date. For example, the seven-day journey of the ship Pride of Tampa that leaves on June 13, 2003, is a cruise. Note the following facts about this environment (40 points). - Identify the primary key and any alternate keys of each relation (20 points). . Using the informal relational command language described in this chapter, write commands to: (30 points) what was the gross weight of the ship used for cruise number 394827 a List the home address of every passenger on cruise Relational Database Concepts 5:17 a myleoonline.tamuc.edu Week of 2/18 v Instructions Write a program that prints the following pattern to the screen, using two for loops. ome 1. Using DOS-based Orade SQL to create a table (table name must be your la (e.g, Kwang Lee-> KLEE). The table must indlude following columns (fields): CWID -. Name -. Date of Birth . Address . Etc Then copy the screen shot (code and result) and insert here (10 points). 2. Insert columns (School, Department) into the table and delete a column (Etc) from the table. Then copy the screen shot (code and result) and insert here (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 Sclence Department. Then copy the screen shot (code and result) and insert here (10 points). 4. Using Orade SQL to create another table (table name DEPT). The table must indlude 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 (code and result) and insert here ( 0 points). 5. Containing two tables relation, then identify a primary key and a candidate key. List the students name, dlass name, grade, and address where the students' age is over 5 years using the relational commands. Then copy the screen shot (code and result) (20 points). 6. Consider the following relational database for Happy Cruise ines (See the attached file). It keeps track of ships, cruises, ports, and passengers. A "cruise" is a particular sailing of a ship on a particular date. For example, the seven-day journey of the ship Pride of Tampa that leaves on June 13, 2003, is a cruise. Note the following facts about this environment (40 points). - Identify the primary key and any alternate keys of each relation (20 points). . Using the informal relational command language described in this chapter, write commands to: (30 points) what was the gross weight of the ship used for cruise number 394827 a List the home address of every passenger on cruise Relational Database Concepts 5:17 a myleoonline.tamuc.edu Week of 2/18 v Instructions Write a program that prints the following pattern to the screen, using two for loops