this is my first post to this site and m looking forward to solution of my problem thru this site.
my problem is very common but i don find it simple as m quite new to this area.
i am creating a site for student registration in asp.net in that i want to design the database..so far i cd only think of the following tables. please help me with that so that in future i will not face any problem because of bad databse design... student table:
StudentID, CourseID, name ,(other personal info course table:
CourseID, courseName CourseDetail(one for each course ID)
Sem,Sub1....Sub10(as the number of subjects may vary from course to course) college table
is this pattern alright?
my mail query iswhilke connecting the coursedetail table to course table.
for every course i need one seperate table as one course has different sujects in different semesters.
please lemme know any other way out also if easier or better than this
thanx in advance...
looking forward to get my query solved.
I think you may need to add one more table , something like "student_course" , this would have at least 2 columns "StudentID" and CourseID , rather than having CourseID in the Student Tabble. This is on the assumption a student may be on more than 1 course