Students

IDFirstNameLastNameEmail
1JohnDoejohndoe@example.com
2JaneSmithjanesmith@example.com

Instructors

IDFirstNameLastNameDepartment
1AliceJohnsonMathematics
2BobWilliamsPhysics

Enrollments

RegistrationIDStudentIDCourseCodeGrade
(→ Students.ID)
11MATH-101A
22PHYS-101B

TextbookEditions

EditionNumberYearPublishedPublisherISBNTextbooks
12020Pearson Education9780321606389Introduction to Algorithms
22019Wiley Publishing9780470689571Fundamentals of Physics

CourseOfferings

OfferingIDCourseCodeSemesterYearInstructorID
(→ Instructors.ID)
1MATH-101Fall20211
2PHYS-101Spring20212

BookCopies

CopyIDCourseOfferingIDTextbookEditionIDQuantity
(→ CourseOfferings.OfferingID)(→ TextbookEditions.EditionNumber)
11130
22220