Student

IDName
1Alice Johnson
2Bob Smith
3Carol Williams
4David Brown
5Eva Green

Attendance

AttendIDStudentIDDateStatus
(→ Student.ID)
112023-01-01Present
222023-01-01Absent
312023-01-02Present
422023-01-02Absent
532023-01-01Present
642023-01-01Present

Grades

GradeIDStudentIDSubjectScore
(→ Student.ID)
11Math98
22English87
31History93
42Biology76
53Chemistry92
64Physics97

Teacher

TeachIDName
1Mr. White
2Mrs. Black
3Ms. Blue
4Dr. Red
5Professor Green

Classroom

ClassIDTeachIDLocation
(→ Teacher.TeachID)
11Room A
22Room B
33Room C
44Room D
55Room E

Enrollment

EnrollIDStudentIDClassID
(→ Student.ID)(→ Classroom.ClassID)
111
222
333
444
555