I'm putting an access database together where I can track students assignments and grades but Im having trouble deciding which is the best designing solution.
This is the starting point...
- Classess (id, classname)
- Students (id, classid)
- Assigments (id, classid, date)
I want to assign each class assignments students will be doing during the year...This is the starting poing of what Im trying to achieve.
Class Assignments Students
------- ----------------- --------------
Y7 Exam1 Stu1 - A
Stu2 - B
Exam 2 Stu1 - A
Stu1 - B
Y9 Exam 1
My first though is I cant store all the grades in the table students as it will potentially will have lots of duplicate records for each students for different assigments.
Any starting point will be appreciated! Thanks!