I am creating a university database, where student can take sections and courses have prerequisites. I have to make sure that when user takes a section, he has met all the prerequisites for that course he is signing up for. And, when a course is deleted from the database, i have to make sure that the course to be deleted doesn't have any prerequisites.
here is my schema
Student(studentid, firstname, lastname, major, gpa)
course(courseid, title, credit)
I am not sure how do this in MYSQL. Can you guys get me started in the right direction?