I am creating a database for a student management system. The system have the following requirements:
- Students enroll classes
- For every class, a student must be evaluated with multiple scores (projects, quizzes, homework, etc.) and a final exam.
I created this entity relation diagram:
And This is the SQL schema
However, I think that in the
scores
the testName
and testWeight
attributes are redundancy as these attributes are the same for every student with same classCode
. How can I remove this redundancy.
P.s: The two pictures just a part of my design.