Students

StudentIDFirstNameLastNameDateOfBirth
1JohnDoe2003-06-18
2JaneSmith2004-09-07
3MichaelJohnson2002-11-22

Academics

CourseIDDisciplineGradeLevelTeacherRoomNumberCapacity
1MathematicsAlgebra IMs. Smith10130
2EnglishCompositionMr. Brown20125
3HistoryWorld HistoryMrs. Johnson30135

Enrollments

EnrollmentIDStudentIDCourseIDEnrolDateFinalGrade
(→ Students.StudentID)(→ Academics.CourseID)
1112021-09-01None
2222021-09-01None
3332021-09-01None

Addresses

AddressIDStreetAddressCityStatePostalCodeCountryPhoneNumber
1123 Main St.AnytownCA12345USA555-1234
2456 Elm St.OthertownNY67890USA555-5678
3789 Oak St.NowhereTX98765USA555-9012

Guardians

GuardianIDFirstNameLastNameRelationshipHomePhoneWorkPhoneEmail
1JohnDoeParent555-1234john.doe@example.com
2EmilySmithAunt555-5678emily.smith@example.com

EmergencyContacts

ContactIDGuardianIDNameRelationshipPhoneNumber
(→ Guardians.GuardianID)
11Uncle BobUncle555-9012
22Dr. JonesFamily Friend555-1234