i1QZguqF

1-- many-to-many relationship needs join table
2CREATE TABLE IF NOT EXISTS student_course (
3  student_id INTEGER,
4  course_id INTEGER,
5  PRIMARY KEY (student_id, course_id),
6  FOREIGN KEY (student_id) REFERENCES student (id),
7  FOREIGN KEY (course_id) REFERENCES course (id) );