Database Design Question

[IP076]

Hey all,

I'm trying to design a Database that keeps track of student loads per teacher per Course.

I have a table that includes all the teachers. I also have a table that includes all the courses. Now, what I want to be able to do is keep track of how many students each teacher has in each course.

I know I could make one table that keeps Teacher Info, and another that would have the TeacherID and fields for each course, but that really doesn't allow the flexibility I would like to have if the school would add or change a course name. I'd appreciate any ideas anyone may have.

Thank you,

 

[WayneRyan]

IPO,

Just some general ideas. Doesn't support things like multiple
teachers for a class, but it's a start.

tblTeachers
===========
TeacherID - AutoNumber
TeacherName
OtherStuff

tblStudents
===========
StudentID - AutoNumber
StudentName
OtherStuff

tblClasses
==========
ClassID - AutoNumber
ClassName
TeacherID - link to tblTeachers
ClassStartDate
ClassEndDate
OtherStuff

tblClassRoster
==============
RosterID - AutoNumber
ClassID - link to tblClasses (indirect link to Teachers)
StudentID - link to tblStudents
OtherStuff

Wayne

 

[IP076]

Thanks for the ideas.

I do have several teachers per course. Basically, I'm trying to see if I can come up with a way to track Instructor Loads in a flight training environment. We have instructors who have about 8 or so students which could be in any of 6 or 8 courses. Doing it in an excel spreadsheet now, but I think I could possibly do it better via access, but just trying to find out how.

Thanks for the idea anyways, I'll keep fiddling around with it and see what I come up with.