CALL mark_attendance(1, '2026-09-05', '{"1":"present"}');

SELECT * FROM vw_daily_rollcall WHERE session_date = '2026-09-05';

SELECT attendance_percentage(1, 2026, 9) AS monthly_rate;

FOREIGN KEY (class_id) REFERENCES classes(class_id) ON DELETE CASCADE

SELECT user_id, role FROM users WHERE username = 'admin';

CREATE TRIGGER trg_auto_absent AFTER INSERT ON sessions…

INSERT INTO attendance (…) ON DUPLICATE KEY UPDATE status = VALUES(status);

SELECT session_date, SUM(CASE WHEN status='present' THEN 1 ELSE 0 END)…

mysqldump –single-transaction –routines –databases attendance_db