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 |