Closed BastiaanMatt closed 3 years ago
CREATE TABLE class_schedule( period_id VARCHAR(4) NOT NULL ,subject_class_id VARCHAR(12) NOT NULL ,day VARCHAR(9) NOT NULL ,PRIMARY KEY(period_id,subject_class_id) ); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','KIM10A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','KIM10A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','MDS10A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','MAN10A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','BIO10A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','BIO10A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','PAK10A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','PAK10A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','FIS10A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','FIS10A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','BIG10A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','PKN10A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','BIN10A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','BIG10A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','BIN10A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','PKN10A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','MTK10A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','MTK10A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','MAN10A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','OLG10A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','PAK10S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','PAK10S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','PKN10S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','PKN10S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P008','SEJ10S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P009','SEJ10S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P011','MDS10S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P013','OLG10S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P015','BIG10S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P016','BIG10S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P018','EKO10S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P020','EKO10S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P022','MAN10S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P023','MAN10S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P025','GEO10S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P027','GEO10S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P029','BIN10S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P030','BIN10S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P032','MTK10S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P034','MTK10S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','MAN11A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','MAN11A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','KIM11A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','BIO11A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P008','PAK11A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P009','PAK11A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P011','MTK11A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P013','MTK11A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P015','KIM11A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P016','BIN11A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P018','BIN11A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P020','MDS11A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P022','FIS11A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P023','FIS11A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P025','BIG11A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P027','BIG11A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P029','BIO11A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P030','OLG11A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P032','PKN11A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P034','PKN11A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','BIG11S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','BIG11S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','EKO11S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','EKO11S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P008','MTK11S012020','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P009','OLG11S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P011','MAN11S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P013','MAN11S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P015','PKN11S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P016','PKN11S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P018','GEO11S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P020','GEO11S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P022','SEJ11S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P023','SEJ11S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P025','MDS11S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P027','MTK11S012020','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P029','PAK11S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P030','PAK11S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P032','BIN11S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P034','BIN11S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','PKN12A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','PKN12A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','MTK12A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','MTK12A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P008','BIN12A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P009','BIN12A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P011','KIM12A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P013','KIM12A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P015','MDS12A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P016','MAN12A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P018','MAN12A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P020','OLG12A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P022','BIG12A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P023','BIG12A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P025','BIO12A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P027','BIO12A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P029','FIS12A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P030','FIS12A012022','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P032','PAK12A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P034','PAK12A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','GEO12S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','GEO12S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','PAK12S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','BIN12S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P008','MDS12S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P009','MTK12S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P011','SEJ12S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P013','BIG12S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P015','SEJ12S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P016','MTK12S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P018','PAK12S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P020','BIN12S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P022','PKN12S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P023','PKN12S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P025','MAN12S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P027','MAN12S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P029','BIG12S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P030','OLG12S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P032','EKO12S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P034','EKO12S012021','Friday');
check the period_id
yudisentosa
commented
3 years ago yudisentosa
commented
3 years ago
CREATE TABLE class_schedule( period_id VARCHAR(4) NOT NULL ,subject_class_id VARCHAR(12) NOT NULL ,day VARCHAR(9) NOT NULL ,PRIMARY KEY(period_id,subject_class_id) ); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','KIM10A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','KIM10A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','MDS10A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','MAN10A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','BIO10A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','BIO10A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','PAK10A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','PAK10A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','FIS10A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','FIS10A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','BIG10A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','PKN10A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','BIN10A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','BIG10A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','BIN10A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','PKN10A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','MTK10A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','MTK10A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','MAN10A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','OLG10A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','PAK10S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','PAK10S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','PKN10S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','PKN10S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P008','SEJ10S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P009','SEJ10S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P011','MDS10S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P013','OLG10S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P015','BIG10S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P016','BIG10S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P018','EKO10S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P020','EKO10S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P022','MAN10S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P023','MAN10S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P025','GEO10S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P027','GEO10S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P029','BIN10S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P030','BIN10S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P032','MTK10S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P034','MTK10S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','MAN11A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','MAN11A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','KIM11A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','BIO11A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P008','PAK11A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P009','PAK11A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P011','MTK11A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P013','MTK11A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P015','KIM11A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P016','BIN11A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P018','BIN11A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P020','MDS11A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P022','FIS11A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P023','FIS11A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P025','BIG11A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P027','BIG11A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P029','BIO11A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P030','OLG11A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P032','PKN11A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P034','PKN11A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','BIG11S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','BIG11S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','EKO11S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','EKO11S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P008','MTK11S012020','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P009','OLG11S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P011','MAN11S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P013','MAN11S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P015','PKN11S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P016','PKN11S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P018','GEO11S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P020','GEO11S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P022','SEJ11S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P023','SEJ11S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P025','MDS11S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P027','MTK11S012020','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P029','PAK11S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P030','PAK11S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P032','BIN11S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P034','BIN11S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','PKN12A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','PKN12A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','MTK12A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','MTK12A012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P008','BIN12A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P009','BIN12A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P011','KIM12A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P013','KIM12A012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P015','MDS12A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P016','MAN12A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P018','MAN12A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P020','OLG12A012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P022','BIG12A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P023','BIG12A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P025','BIO12A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P027','BIO12A012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P029','FIS12A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P030','FIS12A012022','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P032','PAK12A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P034','PAK12A012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P001','GEO12S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P002','GEO12S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P004','PAK12S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P006','BIN12S012021','Monday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P008','MDS12S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P009','MTK12S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P011','SEJ12S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P013','BIG12S012021','Tuesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P015','SEJ12S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P016','MTK12S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P018','PAK12S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P020','BIN12S012021','Wednesday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P022','PKN12S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P023','PKN12S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P025','MAN12S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P027','MAN12S012021','Thursday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P029','BIG12S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P030','OLG12S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P032','EKO12S012021','Friday'); INSERT INTO class_schedule(period_id,subject_class_id,day) VALUES ('P034','EKO12S012021','Friday');