## Students

ID | FirstName | LastName | Email
--- | --- | --- | ---
1 | John | Doe | johndoe@example.com
2 | Jane | Smith | janesmith@example.com

## Instructors

ID | FirstName | LastName | Department
--- | --- | --- | ---
1 | Alice | Johnson | Mathematics
2 | Bob | Williams | Physics

## Enrollments

RegistrationID | StudentID | CourseCode | Grade
--- | --- | --- | ---
| (→ Students.ID) |  |
1 | 1 | MATH-101 | A
2 | 2 | PHYS-101 | B

## TextbookEditions

EditionNumber | YearPublished | Publisher | ISBN | Textbooks
--- | --- | --- | --- | ---
1 | 2020 | Pearson Education | 9780321606389 | Introduction to Algorithms
2 | 2019 | Wiley Publishing | 9780470689571 | Fundamentals of Physics

## CourseOfferings

OfferingID | CourseCode | Semester | Year | InstructorID
--- | --- | --- | --- | ---
|  |  |  | (→ Instructors.ID)
1 | MATH-101 | Fall | 2021 | 1
2 | PHYS-101 | Spring | 2021 | 2

## BookCopies

CopyID | CourseOfferingID | TextbookEditionID | Quantity
--- | --- | --- | ---
| (→ CourseOfferings.OfferingID) | (→ TextbookEditions.EditionNumber) |
1 | 1 | 1 | 30
2 | 2 | 2 | 20