## Publishers

PublisherID | Name | Address | Email | PhoneNumber
--- | --- | --- | --- | ---
1 | Pearson | New York | pearson@example.com | 1234567890
2 | Random House | Los Angeles | randomhouse@example.com | 0987654321

## EducationalMaterials

MaterialID | Title | Type | ISBN | PublisherID
--- | --- | --- | --- | ---
|  |  |  | (→ Publishers.PublisherID)
1 | Math Book | Textbook | 12345 | 1
2 | Physics Book | Textbook | 67890 | 2
3 | Computer Science E-Book | E-Book | 13579 | 1
4 | Biology E-Book | E-Book | 24680 | 2

## Students

StudentID | FirstName | LastName | DateOfBirth | Email
--- | --- | --- | --- | ---
1 | John | Doe | 2000-01-01 | john@example.com
2 | Jane | Smith | 1999-02-02 | jane@example.com

## Teachers

TeacherID | FirstName | LastName | Email
--- | --- | --- | ---
1 | Michael | Johnson | michael@example.com
2 | Emily | Williams | emily@example.com

## Enrollments

EnrollmentID | CourseID | StudentID | Semester | Year | Grade
--- | --- | --- | --- | --- | ---
| (→ Courses.CourseID) | (→ Students.StudentID) |  |  |
1 | 1 | 1 | Spring | 2021 | None
2 | 2 | 2 | Fall | 2021 | None

## Courses

CourseID | CourseTitle | Department | TeacherID
--- | --- | --- | ---
|  |  | (→ Teachers.TeacherID)
1 | Calculus | Mathematics | 1
2 | English Literature | Language Arts | 2