InstitutionID | Name | Type | AddressID |
---|---|---|---|
(→ Addresses.AddressID) | |||
1 | ABC Kindergarten | Kindergarten | 1 |
2 | XYZ Kindergarten | Kindergarden | 2 |
3 | PQR High School | High School | 1 |
4 | STU High School | High School | 2 |
5 | MNO College | College | 3 |
6 | DEF University | University | 4 |
AddressID | Street |
---|---|
1 | 123 Main St |
2 | 456 Elm St |
3 | 789 Oak St |
4 | 000 Pine St |
StudentID | FirstName | LastName | EnrollmentDate | InstituteID |
---|---|---|---|---|
(→ Educational_Institutions.InstitutionID) | ||||
1 | John | Doe | 2021-01-01 | 1 |
2 | Jane | Smith | 2021-01-02 | 2 |
3 | Emily | Brown | 2021-01-03 | 3 |
4 | Tom | White | 2021-01-04 | 4 |
5 | Nick | Green | 2021-01-05 | 5 |
CourseID | Title | Description | StartDate | EndDate | InstituteID |
---|---|---|---|---|---|
(→ Educational_Institutions.InstitutionID) | |||||
1 | Math 101 | Introduction to Mathematics | 2021-01-01 | 2021-05-31 | 1 |
2 | English 101 | Basic English Skills | 2021-02-01 | 2021-06-30 | 2 |
3 | Biology 101 | Fundamentals of Biology | 2021-03-01 | 2021-07-31 | 3 |
4 | Physics 101 | Introduction to Physics | 2021-04-01 | 2021-08-31 | 4 |
5 | History 101 | World History Overview | 2021-05-01 | 2021-09-30 | 5 |