Closed marcelinalinaa closed 3 years ago
DROP TABLE IF EXISTS extracurricular_schedule; CREATE TABLE extracurricular_schedule( extracurricular_id VARCHAR(6) NOT NULL ,academic_year VARCHAR(9) NOT NULL ,day VARCHAR(9) NOT NULL ,PRIMARY KEY(extracurricular_id,academic_year) ,FOREIGN KEY (extracurricular_id) REFERENCES extracurricular(extracurricular_id) ); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC001','2018/2019','Monday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC002','2018/2019','Tuesday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC003','2018/2019','Wednesday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC004','2018/2019','Thursday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC005','2018/2019','Friday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC001','2019/2020','Monday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC002','2019/2020','Wednesday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC003','2019/2020','Friday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC004','2019/2020','Tuesday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC005','2019/2020','Thursday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC001','2020/2021','Monday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC002','2020/2021','Wednesday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC003','2020/2021','Tuesday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC004','2020/2021','Friday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC005','2020/2021','Thursday');
DROP TABLE IF EXISTS extracurricular_schedule; CREATE TABLE extracurricular_schedule( extracurricular_id VARCHAR(6) NOT NULL ,academic_year VARCHAR(9) NOT NULL ,day VARCHAR(9) NOT NULL ,PRIMARY KEY(extracurricular_id,academic_year) ,FOREIGN KEY (extracurricular_id) REFERENCES extracurricular(extracurricular_id) ); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC001','2018/2019','Monday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC002','2018/2019','Tuesday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC003','2018/2019','Wednesday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC004','2018/2019','Thursday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC005','2018/2019','Friday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC001','2019/2020','Monday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC002','2019/2020','Wednesday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC003','2019/2020','Friday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC004','2019/2020','Tuesday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC005','2019/2020','Thursday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC001','2020/2021','Monday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC002','2020/2021','Wednesday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC003','2020/2021','Tuesday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC004','2020/2021','Friday'); INSERT INTO extracurricular_schedule(extracurricular_id,academic_year,day) VALUES ('EXC005','2020/2021','Thursday');