information-system/lab11/views.sql

CREATE VIEW student_performance AS
SELECT
    s.student_id,
    s.last_name,
    s.first_name,
    d.discipline_name,
    e.grade,
    e.exam_date
FROM students s
JOIN exams e ON s.student_id = e.student_id
JOIN disciplines d ON d.discipline_id = e.discipline_id;

CREATE VIEW teacher_workload AS
SELECT
    t.teacher_id,
    t.last_name,
    d.discipline_name,
    ta.lecture_hours,
    ta.practice_hours,
    ta.lab_hours
FROM teachers t
JOIN teaching_assignments ta
ON t.teacher_id = ta.teacher_id
JOIN disciplines d
ON ta.discipline_id = d.discipline_id;