Table 1 Relation (assessmentscores)
From: A data model for enhanced data comparability across multiple organizations
Tuple | School ID | Student ID | Assesment type | Subject | Session ID | Score |
|---|---|---|---|---|---|---|
T1 | SCH1 | 6823 | CA | MATHS | 2017/18 | 45 |
T2 | SCH1 | 6823 | EXAM | MATHS | 2016/17 | 70 |
T3 | SCH2 | 2677 | CA | MATHS | 2017/18 | 73 |
T4 | SCH2 | 2677 | EXAM | MATHS | 2016/17 | 24 |
T5 | SCH3 | 9418 | CA | MATHS | 2017/18 | 90 |
T6 | SCH3 | 9418 | EXAM | MATHS | 2016/17 | 65 |