Loading

Student Management System Course and Session Issue

Balwant Singh

Hello I am working on a student management system in that system I want to record student admissions based on the session course and every course has sections and every course has different subjects in future I want to analyse or make some analysis based on the session course section or subject wise. Now I am confused how to create SQL tables for managing the session course sections and course subjects and their relationships

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mario Scheeren6y ago
Accepted answer
So what you have here ist pretty simple and a common thing to be solved. Mappings.

You create Tables for your Courses and Sessions and Subjects the same way:

ID, Name, other stuff optional

Now you Create a table that maps (use ForeignKeyConstrains!)

MappingID, CourseID, SessionID, SubjectID

Now you can Select all combinations using JOINS over those Tables while adding your Whereclauses to include / exclude certain combinations.
+2
Balwant Singh6y ago
Thanks I did in same Way
0