Closed marcelinalinaa closed 3 years ago
DROP TABLE IF EXISTS extracurricular_student; CREATE TABLE extracurricular_student( academic_year VARCHAR(9) NOT NULL ,student_id CHAR(5) NOT NULL ,extracurricular_id VARCHAR(6) NOT NULL ,PRIMARY KEY(student_id, academic_year) ,FOREIGN KEY (student_id) REFERENCES student(student_id) ,FOREIGN KEY (extracurricular_id) REFERENCES extracurricular(extracurricular_id) ); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2018/2019','00001','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2018/2019','00002','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2018/2019','00003','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2018/2019','00004','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2018/2019','00005','EXC004'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00006','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00007','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00012','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00013','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00014','EXC005'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00015','EXC005'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00001','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00002','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00003','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00004','EXC004'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00005','EXC005'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00008','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00009','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00010','EXC004'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00011','EXC005'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00003','EXC005'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00006','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00010','EXC005'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00011','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00018','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00020','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00009','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00022','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00001','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00013','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00004','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00016','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00017','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00019','EXC005'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00002','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00007','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00008','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00015','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00021','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00023','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00024','EXC004'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00005','EXC004'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00012','EXC004'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00014','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00025','EXC004');
DROP TABLE IF EXISTS extracurricular_student; CREATE TABLE extracurricular_student( academic_year VARCHAR(9) NOT NULL ,student_id CHAR(5) NOT NULL ,extracurricular_id VARCHAR(6) NOT NULL ,PRIMARY KEY(student_id, academic_year) ,FOREIGN KEY (student_id) REFERENCES student(student_id) ,FOREIGN KEY (extracurricular_id) REFERENCES extracurricular(extracurricular_id) ); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2018/2019','00001','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2018/2019','00002','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2018/2019','00003','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2018/2019','00004','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2018/2019','00005','EXC004'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00006','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00007','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00012','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00013','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00014','EXC005'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00015','EXC005'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00001','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00002','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00003','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00004','EXC004'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00005','EXC005'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00008','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00009','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00010','EXC004'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2019/2020','00011','EXC005'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00003','EXC005'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00006','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00010','EXC005'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00011','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00018','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00020','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00009','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00022','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00001','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00013','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00004','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00016','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00017','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00019','EXC005'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00002','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00007','EXC002'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00008','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00015','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00021','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00023','EXC001'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00024','EXC004'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00005','EXC004'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00012','EXC004'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00014','EXC003'); INSERT INTO extracurricular_student(academic_year,student_id,extracurricular_id) VALUES ('2020/2021','00025','EXC004');