Hi All,
I am working on Automatic Time Table Generator program For that I created following tables in SQL Server 2008 :
AllSemeseters : (SemId (PK), SemName)
AllSubjects : (SubjectId (PK), SubjectName)
SemesterwiseSubjects : (SemId(PK), SubjectId(PK)
FacultywiseSubjects : (FacultyId(PK),SubjectId(PK) : [Which faculty know which subjects]
AllocateSubjectsToFacultySemwise : (FacultyId (PK), SemId(PK), SubjectId(PK) )
What I want to do :
1] HOD will click on the Button say " Allocate Faculty to Sem 1" then automatically particular faculty will allocate to that semester if the semeseter have the particular subject and fauclty know that subject.
ex : If Alex knows suppose C, CPP, DS, ASP.NET & PHP & in sem 1 there are 3 subjects : DS & ASP.NET
then Alex's entry save in "AllocateSubjectsToFacultySemwise" because he know both subjects / any one.
I need the guadance for you all. I hope I made the correct table structure.