Closed marcelinalinaa closed 3 years ago
DROP TABLE IF EXISTS extracurricular_score; CREATE TABLE extracurricular_score( student_id VARCHAR(5) NOT NULL ,extracurricular_id VARCHAR(6) NOT NULL ,academic_year VARCHAR(9) NOT NULL ,extracurricular_score INTEGER NOT NULL ,PRIMARY KEY(student_id, extracurricular_id, academic_year) ,FOREIGN KEY (student_id) REFERENCES student(student_id) ,FOREIGN KEY (extracurricular_id) REFERENCES extracurricular(extracurricular_id) ); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00001','EXC001','2018/2019',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00002','EXC003','2018/2019',75); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00003','EXC002','2018/2019',90); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00004','EXC003','2018/2019',88); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00005','EXC004','2018/2019',90); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00006','EXC001','2019/2020',95); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00007','EXC002','2019/2020',75); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00012','EXC002','2019/2020',75); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00013','EXC001','2019/2020',90); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00014','EXC005','2019/2020',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00015','EXC005','2019/2020',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00001','EXC001','2019/2020',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00002','EXC002','2019/2020',85); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00003','EXC003','2019/2020',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00004','EXC004','2019/2020',78); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00005','EXC005','2019/2020',85); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00008','EXC001','2019/2020',70); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00009','EXC003','2019/2020',75); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00010','EXC004','2019/2020',100); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00011','EXC005','2019/2020',85); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00003','EXC005','2020/2021',9); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00006','EXC002','2020/2021',94); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00010','EXC005','2020/2021',76); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00011','EXC002','2020/2021',89); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00018','EXC003','2020/2021',65); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00020','EXC001','2020/2021',88); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00009','EXC001','2020/2021',90); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00022','EXC001','2020/2021',90); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00001','EXC001','2020/2021',75); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00013','EXC001','2020/2021',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00004','EXC002','2020/2021',75); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00016','EXC002','2020/2021',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00017','EXC001','2020/2021',90); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00019','EXC005','2020/2021',85); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00002','EXC003','2020/2021',88); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00007','EXC002','2020/2021',85); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00008','EXC001','2020/2021',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00015','EXC003','2020/2021',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00021','EXC003','2020/2021',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00023','EXC001','2020/2021',90); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00024','EXC004','2020/2021',90); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00005','EXC004','2020/2021',75); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00012','EXC004','2020/2021',67); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00014','EXC003','2020/2021',85); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00025','EXC004','2020/2021',75);
DROP TABLE IF EXISTS extracurricular_score; CREATE TABLE extracurricular_score( student_id VARCHAR(5) NOT NULL ,extracurricular_id VARCHAR(6) NOT NULL ,academic_year VARCHAR(9) NOT NULL ,extracurricular_score INTEGER NOT NULL ,PRIMARY KEY(student_id, extracurricular_id, academic_year) ,FOREIGN KEY (student_id) REFERENCES student(student_id) ,FOREIGN KEY (extracurricular_id) REFERENCES extracurricular(extracurricular_id) ); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00001','EXC001','2018/2019',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00002','EXC003','2018/2019',75); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00003','EXC002','2018/2019',90); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00004','EXC003','2018/2019',88); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00005','EXC004','2018/2019',90); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00006','EXC001','2019/2020',95); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00007','EXC002','2019/2020',75); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00012','EXC002','2019/2020',75); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00013','EXC001','2019/2020',90); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00014','EXC005','2019/2020',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00015','EXC005','2019/2020',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00001','EXC001','2019/2020',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00002','EXC002','2019/2020',85); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00003','EXC003','2019/2020',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00004','EXC004','2019/2020',78); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00005','EXC005','2019/2020',85); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00008','EXC001','2019/2020',70); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00009','EXC003','2019/2020',75); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00010','EXC004','2019/2020',100); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00011','EXC005','2019/2020',85); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00003','EXC005','2020/2021',9); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00006','EXC002','2020/2021',94); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00010','EXC005','2020/2021',76); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00011','EXC002','2020/2021',89); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00018','EXC003','2020/2021',65); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00020','EXC001','2020/2021',88); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00009','EXC001','2020/2021',90); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00022','EXC001','2020/2021',90); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00001','EXC001','2020/2021',75); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00013','EXC001','2020/2021',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00004','EXC002','2020/2021',75); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00016','EXC002','2020/2021',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00017','EXC001','2020/2021',90); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00019','EXC005','2020/2021',85); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00002','EXC003','2020/2021',88); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00007','EXC002','2020/2021',85); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00008','EXC001','2020/2021',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00015','EXC003','2020/2021',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00021','EXC003','2020/2021',80); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00023','EXC001','2020/2021',90); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00024','EXC004','2020/2021',90); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00005','EXC004','2020/2021',75); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00012','EXC004','2020/2021',67); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00014','EXC003','2020/2021',85); INSERT INTO extracurricular_score(student_id,extracurricular_id,academic_year,extracurricular_score) VALUES ('00025','EXC004','2020/2021',75);