Students

StudentIDFirstNameLastName
1JohnDoe
2JaneSmith
3MichaelJohnson
4EmilyWilliams
5DavidBrown

Addresses

AddressIDStreetAddressCityStateZipCodeStudentID
(→ Students.StudentID)
1123 Main StAnytownCA902101
2456 Elm StOthertownNY100012
3789 Oak StAnytownTX773013
4101 Pine StTownvilleIL606014
5111 Maple AveVillagetownNJ076015

PhoneNumbers

PhoneNumberIDNumberTypeStudentID
(→ Students.StudentID)
1(555) 123-4567Home1
2(555) 987-6543Mobile2
3(555) 321-0987Work3
4(555) 765-4321Home4
5(555) 135-7890Mobile5

EmailAddresses

EmailAddressIDEmailIsPrimaryStudentID
(→ Students.StudentID)
1johndoe@example.com11
2janedoe@example.com01
3emilywilliams@example.net14
4davidbrown@example.org05
5michaeljohnson@example.edu13

Enrollments

EnrollmentIDCourseIDSemesterYearGradeStudentID
(→ Students.StudentID)
11Fall2021A1
22Spring2022B+2
33Summer2022A-3
44Fall2021B4
55Winter2022Incomplete5

ExamScores

ScoreIDMonthDayExamDescriptionScoreStudentID
(→ Students.StudentID)
11015Final Exam951
2420Midterm852
365Quiz903
41210Project924
5315Assignment885