## Authors

AuthorID | Name | DateOfBirth | Country
--- | --- | --- | ---
1 | Emily Dickinson | 1830-12-10 | USA
2 | John Doe | 1975-06-22 | Canada

## WrittenWorks

WorkID | Title | Type | PublicationDate | WordCount | AuthorID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Authors.AuthorID)
1 | My Life | 186e16">Essay | 2000-01-01 | 1000 | 1
2 | Nature | 186e16">Poetry | 1890-01-01 | 200 | 1
3 | A Different Life | Essay | 2010-01-01 | 1200 | 2

## Schools

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

## Students

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

## Subjects

SubjectID | SubjectName | Description
--- | --- | ---
1 | Mathematics | The study of numbers, quantity, structure, space, and change.
2 | Literature | The study of written works.

## CourseTeachings

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