final ourput 1

SQL> CREATE TABLE stephensow1_final_Dept (
  2      Dept_Code CHAR(5) PRIMARY KEY, Dept_Name VARCHAR2(32),
  3      Dept_Phone VARCHAR2(16), College_Name VARCHAR2(32));

Table created.

SQL>
SQL> CREATE TABLE stephensow1_final_Advisor (
  2     Advisor_ID CHAR(5) PRIMARY KEY, Advisor_LName VARCHAR2(16),
  3     Advisor_Office VARCHAR2(4), Advisor_Bldg VARCHAR2(32),
  4     Advisor_Phone VARCHAR2(16), Dept_Code CHAR(5));

Table created.

SQL>
SQL> ALTER TABLE stephensow1_final_Advisor ADD CONSTRAINT stephensow1_final_fk1
  2      FOREIGN KEY (Dept_Code) REFERENCES stephensow1_final_Dept(Dept_Code)
  3      INITIALLY DEFERRED DEFERRABLE;

Table altered.

SQL> CREATE TABLE stephensow1_final_Student (
  2      Stu_Num CHAR(6) PRIMARY KEY, Stu_LName VARCHAR2(16),
  3      Stu_Major VARCHAR2(5), Stu_GPA NUMBER(1, 2),
  4      Stu_Hours NUMBER(3), Stu_Class VARCHAR2(10),
  5     Advisor_ID CHAR(5), Dept_Code CHAR(5));

Table created.

SQL>
SQL> ALTER TABLE stephensow1_final_Student ADD CONSTRAINT stephensow1_final_fk2
  2      FOREIGN KEY (Dept_Code) REFERENCES stephensow1_final_Dept(Dept_Code)
  3      INITIALLY DEFERRED DEFERRABLE;

Table altered.

SQL>
SQL> ALTER TABLE stephensow1_final_Student ADD CONSTRAINT stephensow1_final_fk3
  2      FOREIGN KEY (Advisor_ID) REFERENCES stephensow1_final_Advisor(Advisor_ID)
  3      INITIALLY DEFERRED DEFERRABLE;

Table altered.





SQL> INSERT INTO stephensow1_final_Dept VALUES ('ACCT', 'Accounting', '4356', 'Business Admin');

1 row created.

SQL> INSERT INTO stephensow1_final_Dept VALUES ('MKTG', 'Marketing', '4378', 'Business Admin');

1 row created.

SQL> SET DEFINE OFF;
SQL> INSERT INTO stephensow1_final_Dept VALUES ('MATH', 'Mathematics', '3420', 'Arts & Sciences');

1 row created.

SQL> SET DEFINE ON;
SQL> INSERT INTO stephensow1_final_Dept VALUES ('CS', 'Computer Science', '5234', 'Informatics');

1 row created.

SQL> INSERT INTO stephensow1_final_Dept VALUES ('IS', 'Business Informatics', '3951', 'Informatics');

1 row created.


SQL> INSERT INTO stephensow1_final_Advisor VALUES ('001', 'Grastand', 'T201', 'Torre Building', '2115', 'ACCT');

1 row created.

SQL> INSERT INTO stephensow1_final_Advisor VALUES ('002', 'Gentry', 'T228', 'Torre Building', '2123', 'MKTG');

1 row created.

SQL> INSERT INTO stephensow1_final_Advisor VALUES ('003', 'Tillery', 'T356', 'Torre Building', '2159', 'MKTG');

1 row created.

SQL> INSERT INTO stephensow1_final_Advisor VALUES ('004', 'Chen', 'J331', 'Jones Building', '3209', 'MATH');

1 row created.

SQL> INSERT INTO stephensow1_final_Advisor VALUES ('005', 'Lewis', '5132', 'Griffin', '1603', 'CS');

1 row created.

SQL> INSERT INTO stephensow1_final_Advisor VALUES ('006', 'Zang', '3452', 'Griffin', '3512', 'IS');

1 row created.

SQL> INSERT INTO stephensow1_final_Advisor VALUES ('007', 'Goh', '5612', 'Griffin', '7922', 'IS');

1 row created.


SQL> INSERT INTO stephensow1_final_Student VALUES ('211343', 'Stephanos', 'Accounting', 3.87, 75, 'Junior', '001', 'ACCT');

1 row created.

SQL> INSERT INTO stephensow1_final_Student VALUES ('200128', 'Smith', 'Accounting', 2.78, 45, 'Sophomore', '001', 'ACCT');

1 row created.

SQL> INSERT INTO stephensow1_final_Student VALUES ('199876', 'Jones', 'Marketing', 2.31, 117, 'Senior', '002', 'MKTG');

1 row created.

SQL> INSERT INTO stephensow1_final_Student VALUES ('200888', 'Ortiz', 'Marketing', 3.45, 113, 'Senior', '003', 'MKTG');

1 row created.

SQL> INSERT INTO stephensow1_final_Student VALUES ('223456', 'McKulski', 'Statistics', 3.58, 87, 'Junior', '004', 'MATH');

1 row created.

SQL> INSERT INTO stephensow1_final_Student VALUES ('123984', 'Thomas', 'CIT', 2.5, 93, 'Senior', '005', 'CS');

1 row created.

SQL> INSERT INTO stephensow1_final_Student VALUES ('995133', 'Thompson', 'BIS', 2.4, 58, 'Junior', '006', 'IS');

1 row created.

SQL> INSERT INTO stephensow1_final_Student VALUES ('367181', 'Meyers', 'BIS', 2.3, 63, 'Junior', '007', 'IS');

1 row created.