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
- Define a user-defined object type data type namedphone_type with attributes COUNTRY_CODE, AREA_CODE andPHONE_NUMBER.
- Define a user-defined VARRAY data type namedPhone_List_type as an array of size three of the typephone_type.
- Modify the table STUDENT1 such that the attribute PHONE is ofdata type Phone_List_type.
- 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.
Answer to Below requirements is using Oracle . This is object relational programming using Oracle. There is schema called Student …