## Students

StudentID | FirstName | LastName | DateOfBirth
--- | --- | --- | ---
1 | John | Doe | 2003-06-18
2 | Jane | Smith | 2004-09-07
3 | Michael | Johnson | 2002-11-22

## Academics

CourseID | Discipline | GradeLevel | Teacher | RoomNumber | Capacity
--- | --- | --- | --- | --- | ---
1 | Mathematics | Algebra I | Ms. Smith | 101 | 30
2 | English | Composition | Mr. Brown | 201 | 25
3 | History | World History | Mrs. Johnson | 301 | 35

## Enrollments

EnrollmentID | StudentID | CourseID | EnrolDate | FinalGrade
--- | --- | --- | --- | ---
| (→ Students.StudentID) | (→ Academics.CourseID) |  |
1 | 1 | 1 | 2021-09-01 | None
2 | 2 | 2 | 2021-09-01 | None
3 | 3 | 3 | 2021-09-01 | None

## Addresses

AddressID | StreetAddress | City | State | PostalCode | Country | PhoneNumber
--- | --- | --- | --- | --- | --- | ---
1 | 123 Main St. | Anytown | CA | 12345 | USA | 555-1234
2 | 456 Elm St. | Othertown | NY | 67890 | USA | 555-5678
3 | 789 Oak St. | Nowhere | TX | 98765 | USA | 555-9012

## Guardians

GuardianID | FirstName | LastName | Relationship | HomePhone | WorkPhone | Email
--- | --- | --- | --- | --- | --- | ---
1 | John | Doe | Parent | 555-1234 |  | john.doe@example.com
2 | Emily | Smith | Aunt | 555-5678 |  | emily.smith@example.com

## EmergencyContacts

ContactID | GuardianID | Name | Relationship | PhoneNumber
--- | --- | --- | --- | ---
| (→ Guardians.GuardianID) |  |  |
1 | 1 | Uncle Bob | Uncle | 555-9012
2 | 2 | Dr. Jones | Family Friend | 555-1234