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 |