Changeset bcacc91 for sql/schema_creation.sql

Timestamp:

09/16/26 22:22:43 (7 days ago)

Author:

Boris Gjorgjievski <boris@…>

Branches:

master

Children:

e7bafc0

Parents:

1b20b22

Message:

Phase 6: advanced reports as SQL, relational algebra and stored routines

sql/reports.sql adds five reporting routines over the project schema:
pass rate per subject and semester, student dossier, top student per
major, busiest professor per semester and semester-over-semester growth.
Top-1-per-group is done with NOT EXISTS so it maps directly onto a
relational-algebra difference, and payments are joined through
enrolled_semesters per the normalized model from phase 5.

docs/Ph6.md is the wiki page: every report with its SQL, relational
algebra, stored routine and the output it produces on data_load.sql.

(No files)