Educational_Institutions

InstitutionIDNameTypeAddressID
(→ Addresses.AddressID)
1ABC KindergartenKindergarten1
2XYZ KindergartenKindergarden2
3PQR High SchoolHigh School1
4STU High SchoolHigh School2
5MNO CollegeCollege3
6DEF UniversityUniversity4

Addresses

AddressIDStreet
1123 Main St
2456 Elm St
3789 Oak St
4000 Pine St

Students

StudentIDFirstNameLastNameEnrollmentDateInstituteID
(→ Educational_Institutions.InstitutionID)
1JohnDoe2021-01-011
2JaneSmith2021-01-022
3EmilyBrown2021-01-033
4TomWhite2021-01-044
5NickGreen2021-01-055

Courses

CourseIDTitleDescriptionStartDateEndDateInstituteID
(→ Educational_Institutions.InstitutionID)
1Math 101Introduction to Mathematics2021-01-012021-05-311
2English 101Basic English Skills2021-02-012021-06-302
3Biology 101Fundamentals of Biology2021-03-012021-07-313
4Physics 101Introduction to Physics2021-04-012021-08-314
5History 101World History Overview2021-05-012021-09-305