asked on

Database Relations - Class - Students - Grades

Hi,
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...
Tables:
- 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
Y8 Exam1
Exam 2

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!

Ryan Chong

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.

you also need to think the scenarios in which same student retake the same assignment in different trimester?

as a quick start, you probably can have a db design like this:

- Courses (id, coursename, status)
- Classess (id, courseid, classname, termyear, status)
- Students (id, studentname, age, status)
- Assigments (id, classid, date, status)
- StudentAssignment (id, assignmentid, studentid, mark, status)

arcross

ASKER

Thanks for your answer Ryan.
Im uploading a screenshot of what I have so far

Ryan Chong

ok, so based on what you have, I may come out with something like this, but you may or may not adopt accordingly.

- Courses (id, coursename, status)
- Classess (id, courseid, classname, termyear, status)
- Students (id, studentname, age, status)
- Assigments (id, classid, date, status)
- StudentAssignment (id, assignmentid, studentid, markingdate, mark, status)
- Grades (id, markrangebegin, markrangeend, grade)

You may probably need a View to join tables: StudentAssignment and Grades so that we know what grade a student get for his/her assignment if you don't want to put the grade into table: StudentAssignment

but I'm not sure how you define "Strength" for your classes and students.

arcross

ASKER

Thanks again :)

Strength will be the next step.

Each student for each assignment will have at least one strength
Let'say ...
Assigment 1 -
Student 1 - Grade A
Strengths 1 - Accurate description
Strength 2 - Range of vocabulary
... etc..
Student 2 - Grade B
Strengths 1 - Accurate description

and so on...

SOLUTION

Ryan Chong

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

arcross

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial