Member Avatar for alkeshtech

Hi guys,
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)
requires(courseid, prerequisiteid)

I am not sure how do this in MYSQL. Can you guys get me started in the right direction?

Thanks,
Alkesh.

  • 3 Contributors
  • 4 Replies
  • 91 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by alkeshtech
Member Avatar for urtrivedi

create relation in requires table. both column will take value from course table. do not allow casacade update or delete to protect related data from deleting.

Member Avatar for alkeshtech

Yep that will work, but how do I check that a student has met all prerequisites when he wants to take a course?

Member Avatar for d5e5

Where in your schema do you record the fact that the student is taking, or has taken some courses? I think you need a table that has a one-many relation associating each student to courses that student is taking or has taken.

StudentCourses (studentid, courseid, date_completed)

Member Avatar for alkeshtech

Yes, I have that table.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.