For this assignment, you should log on to SQL*Plus Worksheet as CLASSMATE and run the script called ho0808setup.sql in the Data\Chapter08 directory on your student disk. This creates a table called CH08FAMILYTIES and an object type called CH08CHILDINFO that is used in the table in a column called CHILD_DATA. After creating the table, the script modifies theCH08CHILDINFO object type sothat it contains an additional attribute.Write the SQL command needed to modify the attributes in the CHILD_DATA column in the CH08FAMILYTIES table. Save your command in a file named ho0808.sql in the Solutions\Chapter08 directory on your student disk.

Using the table that you created in Hands-on Assignment 8, you now find that more changes are needed to the tables columns. Write the SQL commands to make these changes, and run them using SQL*Plus Worksheet.

? The PARENT_ONE column needs to be split into two columns: PARENT1_FIRST_ NAME and PARENT1_LAST_NAME. (Hint: use an UPDATE command with a SUBSTR function to load the data from the old column into the new columns.) The PARENT_TWO column should be split the same way that PARENT_ONE was split. Remove the old columns after the data has been transferred to the new columns. Save your script in a file named ho0809.sql in the Solutions\Chapter08 directory on your student disk.