## Students

StudentID | FirstName | LastName
--- | --- | ---
1 | John | Doe
2 | Jane | Smith
3 | Michael | Johnson
4 | Emily | Williams
5 | David | Brown

## Addresses

AddressID | StreetAddress | City | State | ZipCode | StudentID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Students.StudentID)
1 | 123 Main St | Anytown | CA | 90210 | 1
2 | 456 Elm St | Othertown | NY | 10001 | 2
3 | 789 Oak St | Anytown | TX | 77301 | 3
4 | 101 Pine St | Townville | IL | 60601 | 4
5 | 111 Maple Ave | Villagetown | NJ | 07601 | 5

## PhoneNumbers

PhoneNumberID | Number | Type | StudentID
--- | --- | --- | ---
|  |  | (→ Students.StudentID)
1 | (555) 123-4567 | Home | 1
2 | (555) 987-6543 | Mobile | 2
3 | (555) 321-0987 | Work | 3
4 | (555) 765-4321 | Home | 4
5 | (555) 135-7890 | Mobile | 5

## EmailAddresses

EmailAddressID | Email | IsPrimary | StudentID
--- | --- | --- | ---
|  |  | (→ Students.StudentID)
1 | johndoe@example.com | 1 | 1
2 | janedoe@example.com | 0 | 1
3 | emilywilliams@example.net | 1 | 4
4 | davidbrown@example.org | 0 | 5
5 | michaeljohnson@example.edu | 1 | 3

## Enrollments

EnrollmentID | CourseID | Semester | Year | Grade | StudentID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Students.StudentID)
1 | 1 | Fall | 2021 | A | 1
2 | 2 | Spring | 2022 | B+ | 2
3 | 3 | Summer | 2022 | A- | 3
4 | 4 | Fall | 2021 | B | 4
5 | 5 | Winter | 2022 | Incomplete | 5

## ExamScores

ScoreID | Month | Day | ExamDescription | Score | StudentID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Students.StudentID)
1 | 10 | 15 | Final Exam | 95 | 1
2 | 4 | 20 | Midterm | 85 | 2
3 | 6 | 5 | Quiz | 90 | 3
4 | 12 | 10 | Project | 92 | 4
5 | 3 | 15 | Assignment | 88 | 5