Publishers

PublisherIDNameAddressEmailPhoneNumber
1PearsonNew Yorkpearson@example.com1234567890
2Random HouseLos Angelesrandomhouse@example.com0987654321

EducationalMaterials

MaterialIDTitleTypeISBNPublisherID
(→ Publishers.PublisherID)
1Math BookTextbook123451
2Physics BookTextbook678902
3Computer Science E-BookE-Book135791
4Biology E-BookE-Book246802

Students

StudentIDFirstNameLastNameDateOfBirthEmail
1JohnDoe2000-01-01john@example.com
2JaneSmith1999-02-02jane@example.com

Teachers

TeacherIDFirstNameLastNameEmail
1MichaelJohnsonmichael@example.com
2EmilyWilliamsemily@example.com

Enrollments

EnrollmentIDCourseIDStudentIDSemesterYearGrade
(→ Courses.CourseID)(→ Students.StudentID)
111Spring2021None
222Fall2021None

Courses

CourseIDCourseTitleDepartmentTeacherID
(→ Teachers.TeacherID)
1CalculusMathematics1
2English LiteratureLanguage Arts2