This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE COLLEGE ( | |
| CollegeID NUMBER(10) PRIMARY KEY, | |
| College_Name VARCHAR2(100) NOT NULL, | |
| College_Details VARCHAR2(500) | |
| ); | |
| CREATE TABLE DEPARTMENT ( | |
| DeptID NUMBER(10) PRIMARY KEY, | |
| DeptName VARCHAR2(100) NOT NULL, |