AuthorID | Name | DateOfBirth | Country |
---|---|---|---|
1 | Emily Dickinson | 1830-12-10 | USA |
2 | John Doe | 1975-06-22 | Canada |
WorkID | Title | Type | PublicationDate | WordCount | AuthorID |
---|---|---|---|---|---|
(→ Authors.AuthorID) | |||||
1 | My Life | Essay | 2000-01-01 | 1000 | 1 |
2 | Nature | Poetry | 1890-01-01 | 200 | 1 |
3 | A Different Life | Essay | 2010-01-01 | 1200 | 2 |
SchoolID | Name | Address | City | State | ZipCode | FoundedYear |
---|---|---|---|---|---|---|
1 | Harvard University | Massachusetts Hall | Cambridge | MA | 02138 | 1636 |
2 | Yale University | Old Campus | New Haven | CT | 06510 | 1701 |
StudentID | FirstName | LastName | Birthdate | EnrollmentDate | SchoolID |
---|---|---|---|---|---|
(→ Schools.SchoolID) | |||||
1 | Alice | Smith | 1990-02-15 | 2006-08-25 | 1 |
2 | Charlie | Doe | 1992-03-20 | 2008-08-25 | 2 |
SubjectID | SubjectName | Description |
---|---|---|
1 | Mathematics | The study of numbers, quantity, structure, space, and change. |
2 | Literature | The study of written works. |
CourseTeachingID | CourseSubjectID | TeacherID | Semester | Year | StartDate | EndDate |
---|---|---|---|---|---|---|
(→ Subjects.SubjectID) | (→ Students.StudentID) | |||||
1 | 1 | 1 | Fall | 2021 | 2021-08-25 | 2021-12-21 |
2 | 2 | 2 | Spring | 2022 | 2022-01-13 | 2022-05-13 |