/* SQL file creates Tables and Inserts DAta into Tables */ select systimestamp from dual;

/*create the COURSE table*/ CREATE TABLE COURSE( CRS_CODE VARCHAR(8) NOT NULL, CRS_DESCRIPTION VARCHAR(35) NOT NULL, CRS_CREDIT INTEGER DEFAULT 4 NOT NULL CHECK(CRS_CREDIT IN (1,2,3,4)), PRIMARY KEY (CRS_CODE));

/* create the Class table */ CREATE TABLE CLASS( CLASS_CODE DECIMAL(5,0) NOT NULL, CRS_CODE VARCHAR(8) NOT NULL, CLASS_SECTION INTEGER NOT NULL CHECK(CLASS_SECTION IN (0,1,2,3,4,5,6,7,8)), CLASS_TIME VARCHAR(25) NOT NULL, CLASS_ROOM CHAR(6), PRIMARY KEY (CLASS_CODE), CONSTRAINT FK_CRS_CODE FOREIGN KEY(CRS_CODE) REFERENCES COURSE(CRS_CODE) );

/* create the STUDENT table */ CREATE TABLE STUDENT( STU_NUM INTEGER NOT NULL, STU_LNAME VARCHAR(25) NOT NULL, STU_FNAME VARCHAR(20) NOT NULL, STU_INIT CHAR(1), STU_DOB DATE, STU_HRS INTEGER NOT NULL CHECK(STU_HRS>=0 AND STU_HRS<=0), STU_CLASS CHAR(2) NOT NULL, STU_GPA DECIMAL(3,2)DEFAULT 0.00 NOT NULL, STU_PHONE DECIMAL(4,0), PRIMARY KEY(STU_NUM) );

/*create the ENROLL table */ CREATE TABLE ENROLL( CLASS_CODE NUMBER(5,0) NOT NULL, STU_NUM INTEGER NOT NULL, ENROLL_GRADE CHAR(1) DEFAULT 'Z' NOT NULL CHECK(ENROLL_GRADE IN('A','B','C','D','F','I','W','Z')), PRIMARY KEY(CLASS_CODE,STU_NUM), CONSTRAINT FK_CLASS_CODE FOREIGN KEY (CLASS_CODE) REFERENCES CLASS(CLASS_CODE), CONSTRAINT FK_STU_NUM FOREIGN KEY (STU_NUM) REFERENCES STUDENT(STU_NUM) );

/* Insert the data into the COURSE table */ INSERT INTO COURSE VALUES('ACCT-211','Accounting I',3); INSERT INTO COURSE VALUES('ACCT-212','Accounting II',3); INSERT INTO COURSE VALUES('CIS-220','Intro to Microcomputing',3); INSERT INTO COURSE VALUES('CIS-420','Database Design and Implementation',4);

/* Insert the data into the CLASS table */ INSERT INTO CLASS VALUES(10012,'ACCT-211',1,'MWF 8:00-8:50 a.m.','BUS311'); INSERT INTO CLASS VALUES(10013,'ACCT-211',2,'MWF 9:00-9:50 a.m.','BUS200'); INSERT INTO CLASS VALUES(10014,'ACCT-211',3,'TTh 2:30-3:45 p.m.','BUS252'); INSERT INTO CLASS VALUES(10015,'ACCT-212',1,'MWF 10:00-10:50 a.m.','BUS311'); INSERT INTO CLASS VALUES(10016,'ACCT-212',2,'Th 6:00-8:40 p.m.','BUS252'); INSERT INTO CLASS VALUES(10017,'CIS-220',1,'MWF 9:00-9:50 a.m.','KLR209'); INSERT INTO CLASS VALUES(10018,'CIS-220',2,'MWF 9:00-9:50 a.m.','KL211'); INSERT INTO CLASS VALUES(10019,'CIS-220',3,'MWF 10:00-10:50 a.m.','KLR209'); INSERT INTO CLASS VALUES(10020,'CIS-420',1,'W 6:00-8:40 p.m.','KLR209');

/* Insert the data into the STUDENT table */ INSERT INTO STUDENT VALUES(321421,'Bowser','William','C','1975-02-12',42,'So',2.84,2134); INSERT INTO STUDENT VALUES(324257,'Smithson','Anne','K','1981-11-15',81,'Jr',3.27,2256); INSERT INTO STUDENT VALUES(324258,'Brewer','Juliette',' ','1968-08-23',38,'So',2.26,2256); INSERT INTO STUDENT VALUES(324299,'Smith','John','B','1986-11-30',15,'Fr',2.92,2315);

/* Insert the data into the ENROLL table */ INSERT INTO ENROLL VALUES (10014,321452,'C'); INSERT INTO ENROLL VALUES (10014,324257,'B'); INSERT INTO ENROLL VALUES (10018,321452,'A'); INSERT INTO ENROLL VALUES (10018,324257,'B');

getting many errors when running in oracle for SQL. What I'm I missing?