/* Database Systems, Coronel/Morris */
/* Type of SQL : Oracle */

ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';

CREATE TABLE CLASS (
CLASS_CODE varchar2(5),
STU_NUM integer,
CRS_CODE varchar2(10),
CLASS_SECTION varchar2(2),
CLASS_TIME varchar2(20),
CLASS_ROOM varchar2(8),
PROF_NUM float(8)
);
INSERT INTO CLASS VALUES('10014','321452','ACCT-211','3','TTh 2:30-3:45 p.m.','BUS252','342');
INSERT INTO CLASS VALUES('10014','324257','ACCT-211','3','TTh 2:30-3:45 p.m.','BUS252','342');
INSERT INTO CLASS VALUES('10018','321452','CIS-220','2','MWF 9:00-9:50 a.m.','KLR211','114');
INSERT INTO CLASS VALUES('10018','324257','CIS-220','2','MWF 9:00-9:50 a.m.','KLR211','114');
INSERT INTO CLASS VALUES('10021','321452','QM-261','1','MWF 8:00-8:50 a.m.','KLR200','114');
INSERT INTO CLASS VALUES('10021','324257','QM-261','1','MWF 8:00-8:50 a.m.','KLR200','114');

/* -- */


CREATE TABLE STUDENT (
STU_NUM integer,
STU_LNAME varchar2(15),
CLASS_CODE varchar2(5)
);
INSERT INTO STUDENT VALUES('321452','Bowser','10014');
INSERT INTO STUDENT VALUES('321452','Bowser','10018');
INSERT INTO STUDENT VALUES('321452','Bowser','10021');
INSERT INTO STUDENT VALUES('324257','Smithson','10014');
INSERT INTO STUDENT VALUES('324257','Smithson','10018');
INSERT INTO STUDENT VALUES('324257','Smithson','10021');
