Im looking to set up a database of multiple students /
multiple subjects, anyone help??????
The standard would have 3 tables:
Student, with StudentID(Primary Key), name address and phone fields
Subjects with SubjectID (Primary Key), and related info fields.
StudentSubject with StudentID, SubjectID (both are part of Primary
key and each is foreign key to respective table.
You may want additional tables for Teachers, TeacherSubject, and
StudentSubjectResults. The last is required only if you have
multiple tests throughout the course.
