Kelompok 2 BDRO

create or replace type Person_t1 as object
(person_id varchar2(10), 
person_name varchar2(20));
/

create table course21
(course_id varchar2(10),
course_name varchar2(20),
lecturer Person_t1);
/

create or replace type persons1 as VARRAY(3) OF Person_t1
/

create table course22
(course_id varchar2(10),
course_name varchar2(20),
lecturer persons1);
/

CREATE OR REPLACE TYPE Person_T2 AS OBJECT
(person_id VARCHAR2(10),
person_name VARCHAR2(30))
/
CREATE OR REPLACE TYPE Person_Table_T2 AS TABLE OF Person_T2
/
CREATE TABLE Course23
(course_id VARCHAR2(10),
course_name VARCHAR2(20),
lecturer Person_Table_T2)
NESTED TABLE lecturer STORE AS Person_tab;

CREATE OR REPLACE TYPE Person_T3 AS OBJECT
(person_id VARCHAR2(10),
person_name VARCHAR2(30))
/
CREATE OR REPLACE TYPE Employee_T AS OBJECT
(person_id VARCHAR2(10),
title VARCHAR2(10),
salary NUMBER)
/
CREATE TABLE Person1 OF Person_T3
(person_id NOT NULL,
PRIMARY KEY (person_id));

CREATE TABLE Employee1 OF Employee_T
(person_id NOT NULL,
PRIMARY KEY (person_id),
FOREIGN KEY (person_id) REFERENCES Person1(person_id));

CREATE OR REPLACE TYPE Person_T4 AS OBJECT
(person_id VARCHAR2(10),
person_name VARCHAR2(30))
/
CREATE TABLE Academic_Staff OF Person_T4;
CREATE TABLE Course24
(course_id VARCHAR2(10),
course_name VARCHAR2(20),
lecturer REF Person_T4 SCOPE IS Academic_Staff);

CREATE CLUSTER HD_Cluster
(hd_id VARCHAR2(10));
CREATE TABLE Hard_Disk
(hd_id VARCHAR2(10) NOT NULL,
capacity VARCHAR2(20),
PRIMARY KEY (hd_id))
CLUSTER HD_Cluster(hd_id);
CREATE INDEX HD_Cluster_Index
ON CLUSTER HD_Cluster;

CREATE OR REPLACE TYPE Person_T5 AS OBJECT
(id VARCHAR2(10),
name VARCHAR2(20),
address VARCHAR2(35)) NOT FINAL
/
CREATE OR REPLACE TYPE Student_T5 UNDER Person_T5
(course VARCHAR2(10),
year VARCHAR2(4))
/
CREATE TABLE Person2 OF Person_T5
(id NOT NULL,

PRIMARY KEY (id));