I work in a school and my HOD wants to computerise our exam results but I am haing problems with the tables and would appreciate some guidance.

To describe our setup:

We have 920 odd students who study up to 15 subject and we wish to record the marks/grades that the students obtain for these subjects. Some subject are taught by more than one teacher as per the departmental setup so I am surmising that I will need tables for the following:

Students: StudenstID, Surname, Forename, Class Reg, Notes

Subjects: SubjectID,Subject, Notes

Grades: {studentID, SubjectID}, Grade, Notes

Teachers: TeacherID, Surname, Salutation

TeachSub: {TeacherID, SubjectID}

One of my problems is setting up and linking the Teachers and TeachSub tables(s) info to record the teacher details and the subject taught as a teacher can teach one or more subjects.

Are my table layouts correct and are there any missing?

Would anyone be able to assist and/or dummy up a quick setup in access to see the design.

Many thanks

Declan