Oracle SQL DROP TABLE ENROLLMENT; DROP TABLE COURSE; DROP TABLE STUDENT; DROP TABLE TEACHER; create table TEACHER ( TEACHER_ID NUMBER not null primary key, LAST_NAME VARCHAR2(35), FIRST_NAME VARCHAR2(35), DEPT VARCHAR2(15), RANK VARCHAR2(15) ) ; create table STUDENT ( STUDENT_ID NUMBER not null primary key, LAST_NAME VARCHAR2(35), FIRST_NAME VARCHAR2(35), MAJOR VARCHAR2(15), PHONE VARCHAR2(15), TEACHER_ID NUMBER, FOREIGN KEY (TEACHER_ID) REFERENCES TEACHER(TEACHER_ID) ) ; create table COURSE ( COURSE_ID NUMBER not null primary key, COURSE_NUM VARCHAR2(15), TITLE VARCHAR2(35), DEPT VARCHAR2(15) ) ; create table ENROLLMENT ( STUDENT_ID NUMBER, COURSE_ID NUMBER, PRIMARY KEY (STUDENT_ID, COURSE_ID), FOREIGN KEY (STUDENT_ID) REFERENCES STUDENT(STUDENT_ID), FOREIGN KEY (COURSE_ID) REFERENCES COURSE(COURSE_ID) ) ; -- insert a record to TEACHER Table INSERT INTO TEACHER VALUES (1, 'john', 'Mr', 'CIS', 'PROFESSOR'); -- (1) Populate the rest of Teacher -- insert a record to STUDENT Table INSERT INTO STUDENT VALUES (1, 'Jones', 'Michael', 'CIS', '111-111-2222', 1); 

-- (2) Populate the rest of STUDENT -- (3) Populate table COURSE -- (4) Populate table ENROLLMENT -- (5) Show TEACHER table -- (6) Show STUDENT table -- (7) Show COURSE table -- (8) Show ENROLLMENT table