Faculties, groups, students, teachers, subjects and grades. The kind of database a dean’s office uses every day.
6 tables · 2,045 rows
One table: selecting, sorting, conditions
Grouping, counting, joining two tables
Subqueries, several JOINs, window functions
The lines show foreign keys: which table points to which.
Faculties
Study groups
faculty_id → faculties.idcurator_id → teachers.id
Students
group_id → study_groups.id
Teachers
faculty_id → faculties.id
Subjects
faculty_id → faculties.id
Grades
student_id → students.idsubject_id → subjects.idteacher_id → teachers.id