Making new table when data changes from original

[bjohran]

here is what I am trying to do. I have my original table that contains the total rosters for the campus
(instr_name, crse, desc, stu_id, stu_name)
I have 450 different courses, my attempt is to create a table for every course, so that each course will be in a separate table with all the students taking this course.

 

[tempclerk]

Why in the world would you want to do that?

 

[bjohran]

We are trying to get each instructors course in a separate file along with the students in the particular class.

 

[THoey]

You don't want to do this. I see the following:

tblInstructors
InstructorID
FName
LName
...

tblCourses
CourseID
Description
...

tblStudents
StudentID
FName
LName
...

tblCoursesOffered
CourseID
InstructorID
StartDate
EndDate
StartTime
EndTime
...

tblScheduled
CourseID
StudentID
...

Creating multiple tables like this and using Primary and Foreign Keys will allow you to reduce redundant data and allow you to create queries and reports that will work for all instructors, courses, etc...

Suggest a class be scheduled in database design... Terry M. Hoey