first_name Sum of score
Emily 180.5
John 177.5
Michael 183.5
Sarah 162.5
Grand Total 704
Student Table
student_i last_nam
d first_name e date_of_birth grade_level
1 John Smith 3/15/2005 10
2 Sarah Johnson 6/22/2006 9
3 Michael Davis 9/10/2007 9
4 Emily Wilson 1/30/2006 10
Teachers Table:
teacher_i last_nam
d first_name e subject email
1 Mr. Anderson Mathematics [Link]@[Link]
2 Ms. Brown Science [Link]@[Link]
3 Mrs. Clark English [Link]@[Link]
4 Dr. Evans History [Link]@[Link]
Classes Table:
teacher_i
class_id class_name d room_number schedule
101 Math 101 1 A-101 Monday, 9:00 AM
102 Science 102 2 B-205 Tuesday, 10:30 AM
103 English 101 3 C-301 Wednesday, 8:15 AM
104 History 102 4 D-102 Thursday, 11:45 AM
Enrollments Table:
enrollme enrollment_dat
nt_id student_id class_id e
1 1 101 8/15/2023
2 2 102 8/15/2023
3 3 101 8/15/2023
4 4 103 8/15/2023
Grades Table:
grade_id student_id class_id assignment score
1 1 101 Midterm 85.5
2 1 101 Homework 1 92
3 2 102 Quiz 1 78
4 2 102 Quiz 2 84.5
5 3 101 Homework 1 88.5
6 3 101 Homework 2 95
7 4 103 Essay 1 89
8 4 103 Essay 2 91.5
Attendance Table:
attendan
ce_id student_id class_id date status
1 1 101 9/3/2023 Present
2 2 102 9/3/2023 Present
3 3 101 9/3/2023 Present
4 4 103 9/3/2023 Present
address parent_email
123 Main St, Anytown, USA [Link]@[Link]
456 Elm St, Othertown, USA [Link]@[Link]
789 Oak St, Different City [Link]@[Link]
101 Pine St, Nearby City [Link]@[Link]
date
9/5/2023
8/25/2023
8/30/2023
9/5/2023
8/25/2023
9/5/2023
9/1/2023
9/10/2023
