Change database structure to have attendance.student_id and discipline.student_id be foreign keys of students.student_id
Change primary key in students table