Teachers must be able to manage test scores for students

[josepostiga]

Scenario

As a Teacher
I want to manage students' test scores
So that it can be accessible to headteachers, students, and their parents

Description

Test scores are one of the main sources of data for students' knowledge evaluation. Teachers should be able to create a new test entry and, for every student enrolled in the class, input a score. After inputting all scores for all students an email notification must be sent to the students themselves, and for their respective parents.

Database and schema information

Create a new test table holding a class foreign key, a name, and the usual timestamps.

Create a new test_score table holding a test and user foreign keys (mapping to a student) and a score (which can be a letter or a value).

Additional requirements

No additional requirements.