Students

IDFirstNameLastNameDateOfBirthEmailPhoneNumber
1JohnDoe2003-06-18john.doe@example.com+1234567890
2JaneSmith2002-05-20jane.smith@example.com+0987654321

Courses

CourseIDCourseTitleInstructorStartDateEndDate
1Introduction to ProgrammingDr. Jane Smith2023-01-012023-05-31
2Advanced Database ManagementProf. John Doe2023-01-152023-05-15

Enrollments

EnrollmentIDStudentIDCourseIDSemesterYear
(→ Students.ID)(→ Courses.CourseID)
111Fall2023
222Spring2023

Grades

GradeIDEnrollmentIDFinalGrade
(→ Enrollments.EnrollmentID)
1188.5
2292.3

Library

LibraryIDNumber_Of_VolumesShelving_SpaceLibraryAccessibleOpeningHours
15001000 sq ftUniversity Main LibraryYesMonday - Friday: 8am - 6pm, Saturday: 10am - 2pm, Sunday: Closed
2300750 sq ftEngineering LibraryNoMonday - Thursday: 8am - 8pm, Friday: 8am - 6pm, Weekends: Closed