| ID | FirstName | LastName | |
|---|---|---|---|
| 1 | John | Doe | johndoe@example.com |
| 2 | Jane | Smith | janesmith@example.com |
| ID | FirstName | LastName | Department |
|---|---|---|---|
| 1 | Alice | Johnson | Mathematics |
| 2 | Bob | Williams | Physics |
| RegistrationID | StudentID | CourseCode | Grade |
|---|---|---|---|
| (→ Students.ID) | |||
| 1 | 1 | MATH-101 | A |
| 2 | 2 | PHYS-101 | B |
| EditionNumber | YearPublished | Publisher | ISBN | Textbooks |
|---|---|---|---|---|
| 1 | 2020 | Pearson Education | 9780321606389 | Introduction to Algorithms |
| 2 | 2019 | Wiley Publishing | 9780470689571 | Fundamentals of Physics |
| OfferingID | CourseCode | Semester | Year | InstructorID |
|---|---|---|---|---|
| (→ Instructors.ID) | ||||
| 1 | MATH-101 | Fall | 2021 | 1 |
| 2 | PHYS-101 | Spring | 2021 | 2 |
| CopyID | CourseOfferingID | TextbookEditionID | Quantity |
|---|---|---|---|
| (→ CourseOfferings.OfferingID) | (→ TextbookEditions.EditionNumber) | ||
| 1 | 1 | 1 | 30 |
| 2 | 2 | 2 | 20 |