Closed yoance closed 3 years ago
DROP TABLE IF EXISTS subject_class;
CREATE TABLE subject_class( subject_class_id VARCHAR(12) NOT NULL PRIMARY KEY ,class_id VARCHAR(6) NOT NULL ,academic_year VARCHAR(9) NOT NULL ,subject_id VARCHAR(5) NOT NULL FOREIGN KEY (class_id) REFERENCES class(class_id) FOREIGN KEY (subject_id) REFERENCES subject_master(subject_id) ); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG10A011920','10IPA1','2019/2020','BIG10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN10A011920','10IPA1','2019/2020','BIN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIO10A011920','10IPA1','2019/2020','BIO10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('FIS10A011920','10IPA1','2019/2020','FIS10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('KIM10A011920','10IPA1','2019/2020','KIM10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN10A011920','10IPA1','2019/2020','MAN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS10A011920','10IPA1','2019/2020','MDS10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK10A011920','10IPA1','2019/2020','MTK10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG10A011920','10IPA1','2019/2020','OLG10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK10A011920','10IPA1','2019/2020','PAK10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN10A011920','10IPA1','2019/2020','PKN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG10A012021','10IPA1','2020/2021','BIG10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN10A012021','10IPA1','2020/2021','BIN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIO10A012021','10IPA1','2020/2021','BIO10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('FIS10A012021','10IPA1','2020/2021','FIS10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('KIM10A012021','10IPA1','2020/2021','KIM10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN10A012021','10IPA1','2020/2021','MAN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS10A012021','10IPA1','2020/2021','MDS10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK10A012021','10IPA1','2020/2021','MTK10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG10A012021','10IPA1','2020/2021','OLG10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK10A012021','10IPA1','2020/2021','PAK10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN10A012021','10IPA1','2020/2021','PKN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG10S011920','10IPS1','2019/2020','BIG10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN10S011920','10IPS1','2019/2020','BIN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('EKO10S011920','10IPS1','2019/2020','EKO10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('GEO10S011920','10IPS1','2019/2020','GEO10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN10S011920','10IPS1','2019/2020','MAN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS10S011920','10IPS1','2019/2020','MDS10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK10S011920','10IPS1','2019/2020','MTK10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG10S011920','10IPS1','2019/2020','OLG10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK10S011920','10IPS1','2019/2020','PAK10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN10S011920','10IPS1','2019/2020','PKN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('SEJ10S011920','10IPS1','2019/2020','SEJ10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK10S012021','10IPS1','2020/2021','MTK10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG10S012021','10IPS1','2020/2021','BIG10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN10S012021','10IPS1','2020/2021','BIN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('EKO10S012021','10IPS1','2020/2021','EKO10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('GEO10S012021','10IPS1','2020/2021','GEO10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN10S012021','10IPS1','2020/2021','MAN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS10S012021','10IPS1','2020/2021','MDS10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG10S012021','10IPS1','2020/2021','OLG10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK10S012021','10IPS1','2020/2021','PAK10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN10S012021','10IPS1','2020/2021','PKN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('SEJ10S012021','10IPS1','2020/2021','SEJ10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG11A011920','11IPA1','2019/2020','BIG11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN11A011920','11IPA1','2019/2020','BIN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIO11A011920','11IPA1','2019/2020','BIO11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('FIS11A011920','11IPA1','2019/2020','FIS11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('KIM11A011920','11IPA1','2019/2020','KIM11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN11A011920','11IPA1','2019/2020','MAN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS11A011920','11IPA1','2019/2020','MDS11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK11A011920','11IPA1','2019/2020','MTK11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG11A011920','11IPA1','2019/2020','OLG11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK11A011920','11IPA1','2019/2020','PAK11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN11A011920','11IPA1','2019/2020','PKN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG11A012021','11IPA1','2020/2021','BIG11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN11A012021','11IPA1','2020/2021','BIN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIO11A012021','11IPA1','2020/2021','BIO11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('FIS11A012021','11IPA1','2020/2021','FIS11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('KIM11A012021','11IPA1','2020/2021','KIM11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN11A012021','11IPA1','2020/2021','MAN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS11A012021','11IPA1','2020/2021','MDS11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK11A012021','11IPA1','2020/2021','MTK11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG11A012021','11IPA1','2020/2021','OLG11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK11A012021','11IPA1','2020/2021','PAK11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN11A012021','11IPA1','2020/2021','PKN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG11S011920','11IPS1','2020/2021','BIG11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN11S011920','11IPS1','2020/2021','BIN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('EKO11S011920','11IPS1','2020/2021','EKO11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('GEO11S011920','11IPS1','2020/2021','GEO11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN11S011920','11IPS1','2020/2021','MAN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS11S011920','11IPS1','2020/2021','MDS11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK11S011920','11IPS1','2020/2021','MTK11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG11S011920','11IPS1','2020/2021','OLG11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK11S011920','11IPS1','2020/2021','PAK11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN11S011920','11IPS1','2020/2021','PKN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('SEJ11S011920','11IPS1','2020/2021','SEJ11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK11S012021','11IPS1','2020/2021','MTK11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG11S012021','11IPS1','2020/2021','BIG11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN11S012021','11IPS1','2020/2021','BIN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('EKO11S012021','11IPS1','2020/2021','EKO11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('GEO11S012021','11IPS1','2020/2021','GEO11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN11S012021','11IPS1','2020/2021','MAN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS11S012021','11IPS1','2020/2021','MDS11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG11S012021','11IPS1','2020/2021','OLG11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK11S012021','11IPS1','2020/2021','PAK11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN11S012021','11IPS1','2020/2021','PKN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('SEJ11S012021','11IPS1','2020/2021','SEJ11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG12A012021','12IPA1','2020/2021','BIG12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN12A012021','12IPA1','2020/2021','BIN12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIO12A012021','12IPA1','2020/2021','BIO12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('FIS12A012021','12IPA1','2020/2021','FIS12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('KIM12A012021','12IPA1','2020/2021','KIM12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN12A012021','12IPA1','2020/2021','MAN12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS12A012021','12IPA1','2020/2021','MDS12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK12A012021','12IPA1','2020/2021','MTK12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG12A012021','12IPA1','2020/2021','OLG12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK12A012021','12IPA1','2020/2021','PAK12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN12A012021','12IPA1','2020/2021','PKN12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK12S012021','12IPS1','2020/2021','MTK12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG12S012021','12IPS1','2020/2021','BIG12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN12S012021','12IPS1','2020/2021','BIN12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('EKO12S012021','12IPS1','2020/2021','EKO12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('GEO12S012021','12IPS1','2020/2021','GEO12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN12S012021','12IPS1','2020/2021','MAN12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS12S012021','12IPS1','2020/2021','MDS12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG12S012021','12IPS1','2020/2021','OLG12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK12S012021','12IPS1','2020/2021','PAK12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN12S012021','12IPS1','2020/2021','PKN12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('SEJ12S012021','12IPS1','2020/2021','SEJ12');
DROP TABLE IF EXISTS subject_class;
CREATE TABLE subject_class( subject_class_id VARCHAR(12) NOT NULL PRIMARY KEY ,class_id VARCHAR(6) NOT NULL ,academic_year VARCHAR(9) NOT NULL ,subject_id VARCHAR(5) NOT NULL FOREIGN KEY (class_id) REFERENCES class(class_id) FOREIGN KEY (subject_id) REFERENCES subject_master(subject_id) ); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG10A011920','10IPA1','2019/2020','BIG10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN10A011920','10IPA1','2019/2020','BIN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIO10A011920','10IPA1','2019/2020','BIO10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('FIS10A011920','10IPA1','2019/2020','FIS10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('KIM10A011920','10IPA1','2019/2020','KIM10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN10A011920','10IPA1','2019/2020','MAN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS10A011920','10IPA1','2019/2020','MDS10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK10A011920','10IPA1','2019/2020','MTK10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG10A011920','10IPA1','2019/2020','OLG10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK10A011920','10IPA1','2019/2020','PAK10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN10A011920','10IPA1','2019/2020','PKN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG10A012021','10IPA1','2020/2021','BIG10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN10A012021','10IPA1','2020/2021','BIN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIO10A012021','10IPA1','2020/2021','BIO10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('FIS10A012021','10IPA1','2020/2021','FIS10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('KIM10A012021','10IPA1','2020/2021','KIM10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN10A012021','10IPA1','2020/2021','MAN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS10A012021','10IPA1','2020/2021','MDS10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK10A012021','10IPA1','2020/2021','MTK10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG10A012021','10IPA1','2020/2021','OLG10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK10A012021','10IPA1','2020/2021','PAK10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN10A012021','10IPA1','2020/2021','PKN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG10S011920','10IPS1','2019/2020','BIG10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN10S011920','10IPS1','2019/2020','BIN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('EKO10S011920','10IPS1','2019/2020','EKO10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('GEO10S011920','10IPS1','2019/2020','GEO10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN10S011920','10IPS1','2019/2020','MAN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS10S011920','10IPS1','2019/2020','MDS10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK10S011920','10IPS1','2019/2020','MTK10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG10S011920','10IPS1','2019/2020','OLG10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK10S011920','10IPS1','2019/2020','PAK10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN10S011920','10IPS1','2019/2020','PKN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('SEJ10S011920','10IPS1','2019/2020','SEJ10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK10S012021','10IPS1','2020/2021','MTK10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG10S012021','10IPS1','2020/2021','BIG10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN10S012021','10IPS1','2020/2021','BIN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('EKO10S012021','10IPS1','2020/2021','EKO10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('GEO10S012021','10IPS1','2020/2021','GEO10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN10S012021','10IPS1','2020/2021','MAN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS10S012021','10IPS1','2020/2021','MDS10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG10S012021','10IPS1','2020/2021','OLG10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK10S012021','10IPS1','2020/2021','PAK10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN10S012021','10IPS1','2020/2021','PKN10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('SEJ10S012021','10IPS1','2020/2021','SEJ10'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG11A011920','11IPA1','2019/2020','BIG11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN11A011920','11IPA1','2019/2020','BIN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIO11A011920','11IPA1','2019/2020','BIO11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('FIS11A011920','11IPA1','2019/2020','FIS11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('KIM11A011920','11IPA1','2019/2020','KIM11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN11A011920','11IPA1','2019/2020','MAN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS11A011920','11IPA1','2019/2020','MDS11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK11A011920','11IPA1','2019/2020','MTK11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG11A011920','11IPA1','2019/2020','OLG11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK11A011920','11IPA1','2019/2020','PAK11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN11A011920','11IPA1','2019/2020','PKN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG11A012021','11IPA1','2020/2021','BIG11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN11A012021','11IPA1','2020/2021','BIN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIO11A012021','11IPA1','2020/2021','BIO11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('FIS11A012021','11IPA1','2020/2021','FIS11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('KIM11A012021','11IPA1','2020/2021','KIM11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN11A012021','11IPA1','2020/2021','MAN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS11A012021','11IPA1','2020/2021','MDS11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK11A012021','11IPA1','2020/2021','MTK11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG11A012021','11IPA1','2020/2021','OLG11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK11A012021','11IPA1','2020/2021','PAK11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN11A012021','11IPA1','2020/2021','PKN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG11S011920','11IPS1','2020/2021','BIG11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN11S011920','11IPS1','2020/2021','BIN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('EKO11S011920','11IPS1','2020/2021','EKO11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('GEO11S011920','11IPS1','2020/2021','GEO11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN11S011920','11IPS1','2020/2021','MAN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS11S011920','11IPS1','2020/2021','MDS11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK11S011920','11IPS1','2020/2021','MTK11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG11S011920','11IPS1','2020/2021','OLG11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK11S011920','11IPS1','2020/2021','PAK11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN11S011920','11IPS1','2020/2021','PKN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('SEJ11S011920','11IPS1','2020/2021','SEJ11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK11S012021','11IPS1','2020/2021','MTK11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG11S012021','11IPS1','2020/2021','BIG11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN11S012021','11IPS1','2020/2021','BIN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('EKO11S012021','11IPS1','2020/2021','EKO11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('GEO11S012021','11IPS1','2020/2021','GEO11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN11S012021','11IPS1','2020/2021','MAN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS11S012021','11IPS1','2020/2021','MDS11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG11S012021','11IPS1','2020/2021','OLG11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK11S012021','11IPS1','2020/2021','PAK11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN11S012021','11IPS1','2020/2021','PKN11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('SEJ11S012021','11IPS1','2020/2021','SEJ11'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG12A012021','12IPA1','2020/2021','BIG12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN12A012021','12IPA1','2020/2021','BIN12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIO12A012021','12IPA1','2020/2021','BIO12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('FIS12A012021','12IPA1','2020/2021','FIS12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('KIM12A012021','12IPA1','2020/2021','KIM12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN12A012021','12IPA1','2020/2021','MAN12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS12A012021','12IPA1','2020/2021','MDS12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK12A012021','12IPA1','2020/2021','MTK12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG12A012021','12IPA1','2020/2021','OLG12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK12A012021','12IPA1','2020/2021','PAK12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN12A012021','12IPA1','2020/2021','PKN12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MTK12S012021','12IPS1','2020/2021','MTK12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIG12S012021','12IPS1','2020/2021','BIG12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('BIN12S012021','12IPS1','2020/2021','BIN12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('EKO12S012021','12IPS1','2020/2021','EKO12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('GEO12S012021','12IPS1','2020/2021','GEO12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MAN12S012021','12IPS1','2020/2021','MAN12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('MDS12S012021','12IPS1','2020/2021','MDS12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('OLG12S012021','12IPS1','2020/2021','OLG12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PAK12S012021','12IPS1','2020/2021','PAK12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('PKN12S012021','12IPS1','2020/2021','PKN12'); INSERT INTO subject_class(subject_class_id,class_id,academic_year,subject_id) VALUES ('SEJ12S012021','12IPS1','2020/2021','SEJ12');