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 |