Closed licyawatidewi closed 3 years ago
DROP TABLE IF EXISTS examination; CREATE TABLE examination( exam_id VARCHAR(9) NOT NULL PRIMARY KEY ,subject_id VARCHAR(5) NOT NULL ,component VARCHAR(50) NOT NULL ,type VARCHAR(3) NOT NULL ,academic_year VARCHAR(9) NOT NULL ); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIN10','BIN10','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIG10','BIG10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MAN10','MAN10','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1PKN10','PKN10','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1PAK10','PAK10','Essay 15 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1OLG10','OLG10','Pilihan Ganda 30 soal, Isian 20 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MDS10','MDS10','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MTK10','MTK10','Pilihan Ganda 40 soal, Essay 10 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIO10','BIO10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1KIM10','KIM10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1FIS10','FIS10','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1EKO10','EKO10','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1SEJ10','SEJ10','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1GEO10','GEO10','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIN11','BIN11','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIG11','BIG11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MAN11','MAN11','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1PKN11','PKN11','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1PAK11','PAK11','Essay 15 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1OLG11','OLG11','Pilihan Ganda 30 soal, Isian 20 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MDS11','MDS11','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MTK11','MTK11','Pilihan Ganda 40 soal, Essay 10 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIO11','BIO11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1KIM11','KIM11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1FIS11','FIS11','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1EKO11','EKO11','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1SEJ11','SEJ11','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1GEO11','GEO11','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIN12','BIN12','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIG12','BIG12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MAN12','MAN12','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1PKN12','PKN12','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1PAK12','PAK12','Essay 15 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1OLG12','OLG12','Pilihan Ganda 30 soal, Isian 20 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MDS12','MDS12','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MTK12','MTK12','Pilihan Ganda 40 soal, Essay 10 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIO12','BIO12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1KIM12','KIM12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1FIS12','FIS12','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1EKO12','EKO12','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1SEJ12','SEJ12','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1GEO12','GEO12','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIN10','BIN10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIG10','BIG10','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MAN10','MAN10','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1PKN10','PKN10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1PAK10','PAK10','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1OLG10','OLG10','Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MDS10','MDS10','Pilihan Ganda 30 soal, Isian 20 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MTK10','MTK10','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIO10','BIO10','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1KIM10','KIM10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1FIS10','FIS10','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1EKO10','EKO10','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1SEJ10','SEJ10','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1GEO10','GEO10','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIN11','BIN11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIG11','BIG11','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MAN11','MAN11','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1PKN11','PKN11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1PAK11','PAK11','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1OLG11','OLG11','Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MDS11','MDS11','Pilihan Ganda 30 soal, Isian 20 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MTK11','MTK11','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIO11','BIO11','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1KIM11','KIM11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1FIS11','FIS11','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1EKO11','EKO11','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1SEJ11','SEJ11','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1GEO11','GEO11','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIN12','BIN12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIG12','BIG12','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MAN12','MAN12','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1PKN12','PKN12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1PAK12','PAK12','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1OLG12','OLG12','Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MDS12','MDS12','Pilihan Ganda 30 soal, Isian 20 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MTK12','MTK12','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIO12','BIO12','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1KIM12','KIM12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1FIS12','FIS12','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1EKO12','EKO12','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1SEJ12','SEJ12','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1GEO12','GEO12','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIN10','BIN10','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIG10','BIG10','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MAN10','MAN10','Pilihan Ganda 30 soal, Isian 20 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2PKN10','PKN10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2PAK10','PAK10','Essay 15 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2OLG10','OLG10','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MDS10','MDS10','Pilihan Ganda 40 soal, Essay 10 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MTK10','MTK10','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIO10','BIO10','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2KIM10','KIM10','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2FIS10','FIS10','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2EKO10','EKO10','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2SEJ10','SEJ10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2GEO10','GEO10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIN11','BIN11','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIG11','BIG11','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MAN11','MAN11','Pilihan Ganda 30 soal, Isian 20 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2PKN11','PKN11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2PAK11','PAK11','Essay 15 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2OLG11','OLG11','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MDS11','MDS11','Pilihan Ganda 40 soal, Essay 10 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MTK11','MTK11','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIO11','BIO11','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2KIM11','KIM11','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2FIS11','FIS11','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2EKO11','EKO11','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2SEJ11','SEJ11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2GEO11','GEO11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIN12','BIN12','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIG12','BIG12','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MAN12','MAN12','Pilihan Ganda 30 soal, Isian 20 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2PKN12','PKN12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2PAK12','PAK12','Essay 15 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2OLG12','OLG12','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MDS12','MDS12','Pilihan Ganda 40 soal, Essay 10 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MTK12','MTK12','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIO12','BIO12','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2KIM12','KIM12','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2FIS12','FIS12','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2EKO12','EKO12','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2SEJ12','SEJ12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2GEO12','GEO12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIN10','BIN10','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIG10','BIG10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MAN10','MAN10','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2PKN10','PKN10','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2PAK10','PAK10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2OLG10','OLG10','Pilihan Ganda 30 soal, Isian 20 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MDS10','MDS10','Essay 15 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MTK10','MTK10','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIO10','BIO10','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2KIM10','KIM10','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2FIS10','FIS10','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2EKO10','EKO10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2SEJ10','SEJ10','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2GEO10','GEO10','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIN11','BIN11','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIG11','BIG11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MAN11','MAN11','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2PKN11','PKN11','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2PAK11','PAK11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2OLG11','OLG11','Pilihan Ganda 30 soal, Isian 20 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MDS11','MDS11','Essay 15 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MTK11','MTK11','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIO11','BIO11','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2KIM11','KIM11','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2FIS11','FIS11','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2EKO11','EKO11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2SEJ11','SEJ11','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2GEO11','GEO11','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIN12','BIN12','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIG12','BIG12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MAN12','MAN12','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2PKN12','PKN12','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2PAK12','PAK12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2OLG12','OLG12','Pilihan Ganda 30 soal, Isian 20 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MDS12','MDS12','Essay 15 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MTK12','MTK12','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIO12','BIO12','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2KIM12','KIM12','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2FIS12','FIS12','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2EKO12','EKO12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2SEJ12','SEJ12','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2GEO12','GEO12','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021');
DROP TABLE IF EXISTS examination; CREATE TABLE examination( exam_id VARCHAR(9) NOT NULL PRIMARY KEY ,subject_id VARCHAR(5) NOT NULL ,component VARCHAR(50) NOT NULL ,type VARCHAR(3) NOT NULL ,academic_year VARCHAR(9) NOT NULL ); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIN10','BIN10','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIG10','BIG10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MAN10','MAN10','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1PKN10','PKN10','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1PAK10','PAK10','Essay 15 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1OLG10','OLG10','Pilihan Ganda 30 soal, Isian 20 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MDS10','MDS10','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MTK10','MTK10','Pilihan Ganda 40 soal, Essay 10 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIO10','BIO10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1KIM10','KIM10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1FIS10','FIS10','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1EKO10','EKO10','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1SEJ10','SEJ10','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1GEO10','GEO10','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIN11','BIN11','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIG11','BIG11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MAN11','MAN11','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1PKN11','PKN11','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1PAK11','PAK11','Essay 15 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1OLG11','OLG11','Pilihan Ganda 30 soal, Isian 20 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MDS11','MDS11','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MTK11','MTK11','Pilihan Ganda 40 soal, Essay 10 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIO11','BIO11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1KIM11','KIM11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1FIS11','FIS11','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1EKO11','EKO11','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1SEJ11','SEJ11','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1GEO11','GEO11','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIN12','BIN12','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIG12','BIG12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MAN12','MAN12','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1PKN12','PKN12','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1PAK12','PAK12','Essay 15 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1OLG12','OLG12','Pilihan Ganda 30 soal, Isian 20 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MDS12','MDS12','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1MTK12','MTK12','Pilihan Ganda 40 soal, Essay 10 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1BIO12','BIO12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1KIM12','KIM12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1FIS12','FIS12','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1EKO12','EKO12','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1SEJ12','SEJ12','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS1GEO12','GEO12','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIN10','BIN10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIG10','BIG10','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MAN10','MAN10','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1PKN10','PKN10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1PAK10','PAK10','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1OLG10','OLG10','Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MDS10','MDS10','Pilihan Ganda 30 soal, Isian 20 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MTK10','MTK10','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIO10','BIO10','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1KIM10','KIM10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1FIS10','FIS10','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1EKO10','EKO10','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1SEJ10','SEJ10','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1GEO10','GEO10','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIN11','BIN11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIG11','BIG11','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MAN11','MAN11','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1PKN11','PKN11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1PAK11','PAK11','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1OLG11','OLG11','Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MDS11','MDS11','Pilihan Ganda 30 soal, Isian 20 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MTK11','MTK11','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIO11','BIO11','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1KIM11','KIM11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1FIS11','FIS11','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1EKO11','EKO11','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1SEJ11','SEJ11','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1GEO11','GEO11','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIN12','BIN12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIG12','BIG12','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MAN12','MAN12','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1PKN12','PKN12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1PAK12','PAK12','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1OLG12','OLG12','Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MDS12','MDS12','Pilihan Ganda 30 soal, Isian 20 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1MTK12','MTK12','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1BIO12','BIO12','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1KIM12','KIM12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1FIS12','FIS12','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1EKO12','EKO12','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1SEJ12','SEJ12','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS1GEO12','GEO12','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIN10','BIN10','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIG10','BIG10','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MAN10','MAN10','Pilihan Ganda 30 soal, Isian 20 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2PKN10','PKN10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2PAK10','PAK10','Essay 15 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2OLG10','OLG10','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MDS10','MDS10','Pilihan Ganda 40 soal, Essay 10 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MTK10','MTK10','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIO10','BIO10','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2KIM10','KIM10','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2FIS10','FIS10','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2EKO10','EKO10','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2SEJ10','SEJ10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2GEO10','GEO10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIN11','BIN11','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIG11','BIG11','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MAN11','MAN11','Pilihan Ganda 30 soal, Isian 20 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2PKN11','PKN11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2PAK11','PAK11','Essay 15 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2OLG11','OLG11','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MDS11','MDS11','Pilihan Ganda 40 soal, Essay 10 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MTK11','MTK11','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIO11','BIO11','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2KIM11','KIM11','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2FIS11','FIS11','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2EKO11','EKO11','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2SEJ11','SEJ11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2GEO11','GEO11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIN12','BIN12','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIG12','BIG12','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MAN12','MAN12','Pilihan Ganda 30 soal, Isian 20 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2PKN12','PKN12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2PAK12','PAK12','Essay 15 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2OLG12','OLG12','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MDS12','MDS12','Pilihan Ganda 40 soal, Essay 10 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2MTK12','MTK12','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2BIO12','BIO12','Pilihan Ganda 45 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2KIM12','KIM12','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2FIS12','FIS12','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2EKO12','EKO12','Pilihan Ganda 40 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2SEJ12','SEJ12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UTS2GEO12','GEO12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UTS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIN10','BIN10','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIG10','BIG10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MAN10','MAN10','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2PKN10','PKN10','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2PAK10','PAK10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2OLG10','OLG10','Pilihan Ganda 30 soal, Isian 20 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MDS10','MDS10','Essay 15 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MTK10','MTK10','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIO10','BIO10','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2KIM10','KIM10','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2FIS10','FIS10','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2EKO10','EKO10','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2SEJ10','SEJ10','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2GEO10','GEO10','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIN11','BIN11','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIG11','BIG11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MAN11','MAN11','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2PKN11','PKN11','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2PAK11','PAK11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2OLG11','OLG11','Pilihan Ganda 30 soal, Isian 20 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MDS11','MDS11','Essay 15 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MTK11','MTK11','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIO11','BIO11','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2KIM11','KIM11','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2FIS11','FIS11','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2EKO11','EKO11','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2SEJ11','SEJ11','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2GEO11','GEO11','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIN12','BIN12','Pilihan Ganda 30 soal, Isian 5 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIG12','BIG12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MAN12','MAN12','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2PKN12','PKN12','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2PAK12','PAK12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2OLG12','OLG12','Pilihan Ganda 30 soal, Isian 20 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MDS12','MDS12','Essay 15 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2MTK12','MTK12','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2BIO12','BIO12','Pilihan Ganda 40 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2KIM12','KIM12','Pilihan Ganda 30 soal, Isian 15 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2FIS12','FIS12','Pilihan Ganda 40 soal, Essay 10 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2EKO12','EKO12','Pilihan Ganda 40 soal, Isian 10 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2SEJ12','SEJ12','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021'); INSERT INTO examination(exam_id,subject_id,component,type,academic_year) VALUES ('UAS2GEO12','GEO12','Pilihan Ganda 45 soal, Essay 5 soal','UAS','2020/2021');