Create db to track students' grades

[ttcorp]

I am trying to create a db to track grades for three classes. I created 4 tables:

Classes - Fields: ClassID (grades -10, 11, 12), ClassDescription
Students - Fields: StudentID (autonumber), ClassID, FName, LName
Assignments - Fields: AssignmentID (autonumber), AssignmentName, Points, Date...etc..
Grades - Fields: GradesID (autonumber), PointsEarned, LetterGrade, StudentID, AssignmentID

Tbl Relationships:

Classes - Students (ClassID)
Students - Grades (StudentID)
Assignments - Classes (ClassID)
Assignments - Grades (AssignmentID)

I have an Assignement form that is linked to the Assignments tbl and allows the user to enter the ClassID and name of the assignment and the other fields. I am trying to create another form that is linked to the Assignments form. On this form I want the names of the students from the ClassID selected on the Assignments form to appear. I then want to enter the students grade that will link to the GradesID.

Are my tables set up properly? I'm new to this so I'm not quite if I'm using the right approach.
Any advice would be greatly appreciated!!!

 

[lespaul]

Just glancing at your structure, it looks fine, but I wanted to know if you had seen this website:

http://www.gradebookwizard.com/

It allows you to assign an id to the students so they can check their assignments and grades on-line! And depending on the ages of your students, the parents can also see how their child is doing.

As a parent of a 6th grader who's teachers use this site, I have to give it 5 stars!!



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design