Authors

AuthorIDNameDateOfBirthCountry
1Emily Dickinson1830-12-10USA
2John Doe1975-06-22Canada

WrittenWorks

WorkIDTitleTypePublicationDateWordCountAuthorID
(→ Authors.AuthorID)
1My LifeEssay2000-01-0110001
2NaturePoetry1890-01-012001
3A Different LifeEssay2010-01-0112002

Schools

SchoolIDNameAddressCityStateZipCodeFoundedYear
1Harvard UniversityMassachusetts HallCambridgeMA021381636
2Yale UniversityOld CampusNew HavenCT065101701

Students

StudentIDFirstNameLastNameBirthdateEnrollmentDateSchoolID
(→ Schools.SchoolID)
1AliceSmith1990-02-152006-08-251
2CharlieDoe1992-03-202008-08-252

Subjects

SubjectIDSubjectNameDescription
1MathematicsThe study of numbers, quantity, structure, space, and change.
2LiteratureThe study of written works.

CourseTeachings

CourseTeachingIDCourseSubjectIDTeacherIDSemesterYearStartDateEndDate
(→ Subjects.SubjectID)(→ Students.StudentID)
111Fall20212021-08-252021-12-21
222Spring20222022-01-132022-05-13