I am trying to redesign an Access database of instructor and course information.
Currently, the database I inherited has only one table with about one hundred fields, roughly in the following categories:
Course title, course number, type, unit number
Instructor contact and biographical information
Teaching Assistant contact and biographical information (more than one per course)
Reader Assistant contact and biographical information (more than one per course)
Course schedule, day/time/
Course location, room
Discussion section schedule, day/time
Discussion section location
Final exam day/time
Final exam location
Instructor compensation
TA compensation (more than one TA per course)
Reader compensation (more than one Reader per course)
Total compensation
Course cap
A list of fields with document names that indicate when a form was sent and received.
My feeling is that all of this information should not be in one table, but I am not sure why. Should it be divided into different tables? Why?
If so, what tables should I create? The obvious ones seem to be:
Course Information
Instructor Information
TA Information
Reader Information
Compensation - should this be separate from Instructor/TA/Reader tables?
How do I deal with the list of documents and procedures that contain sent and received dates?
Any help would be appreciated!
Thanks.