Thanks a lot Michael, that was so helpful you got me out of a jam!

yea thanks for the advice, what i did is for example the quiz table now looks like this:

quiz(student_id(PK), course_id(PK), quiz_number(PK), quiz_grade)

the homeworks, worksheets, and quizzes table is the same thing.

the...

No it isn't a homework assignment, I'm actually doing this for my schools math department for this new program they have for incoming remedial math students.

This is the schema:

(student_id is...