Hi all..
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
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