(Solved) : Requirements Using Oracle Object Relational Programming Using Oracle Schema Called Studen Q42759321 . . .

Below requirements is using Oracle . This is object relationalprogramming using Oracle. There is schema called Student thatcontains different tables such as STUDENT, COURSE, GRADE,ENROLLMENT

1. Define a user-defined object type data type namedphone_type with attributes COUNTRY_CODE, AREA_CODE andPHONE_NUMBER.
2. Define a user-defined VARRAY data type namedPhone_List_type as an array of size three of the typephone_type.
3. Modify the table STUDENT1 such that the attribute PHONE is ofdata type Phone_List_type.
4. Create a nested table object type named TRANSCRIPTthat contains the following enrollment information for student:COURSE.COURSE_NO, COURSE.DESCRIPTION, ENROLLMENT.ENROLL_DATE andENROLLMENT.FINAL_GRADE.

Expert Answer

Answer to Below requirements is using Oracle . This is object relational programming using Oracle. There is schema called Student …