Proposal
Only Week 2 has a dedicated `rubric.md` with scoring criteria. Other weeks define grading criteria in their READMEs but without point values or structured rubrics.
Add `rubric.md` files for all graded weeks:
| Week |
Suggested rubric areas |
| 1 |
Anomaly identification (update/insert/delete), exercise completeness |
| 3 |
Schema correctness, FK relationships, normalization level, integrity pass |
| 4 |
FD analysis, constraint identification, v2 schema improvements |
| 5 |
Trigger correctness, negative test results, integrity pass |
| 6 |
Billing schema, trigger coverage, view correctness, integrity pass |
| 7 |
Index selection rationale, EXPLAIN before/after comparison |
Why
Consistent rubrics across weeks ensure fair grading and help TAs evaluate submissions.
Scope / files impacted
- `course/01_week01_basics/rubric.md` (new)
- `course/03_week03_normalization/rubric.md` (new)
- `course/04_week04_constraints/rubric.md` (new)
- `course/05_week05_joins/rubric.md` (new)
- `course/06_week06_transactions/rubric.md` (new)
- `course/07_week07_indexing/rubric.md` (new)
Proposal
Only Week 2 has a dedicated `rubric.md` with scoring criteria. Other weeks define grading criteria in their READMEs but without point values or structured rubrics.
Add `rubric.md` files for all graded weeks:
Why
Consistent rubrics across weeks ensure fair grading and help TAs evaluate submissions.
Scope / files impacted