## Students

ID | FirstName | LastName | DateOfBirth | Email | PhoneNumber
--- | --- | --- | --- | --- | ---
1 | John | Doe | 2003-06-18 | john.doe@example.com | +1234567890
2 | Jane | Smith | 2002-05-20 | jane.smith@example.com | +0987654321

## Courses

CourseID | CourseTitle | Instructor | StartDate | EndDate
--- | --- | --- | --- | ---
1 | Introduction to Programming | Dr. Jane Smith | 2023-01-01 | 2023-05-31
2 | Advanced Database Management | Prof. John Doe | 2023-01-15 | 2023-05-15

## Enrollments

EnrollmentID | StudentID | CourseID | Semester | Year
--- | --- | --- | --- | ---
| (→ Students.ID) | (→ Courses.CourseID) |  |
1 | 1 | 1 | Fall | 2023
2 | 2 | 2 | Spring | 2023

## Grades

GradeID | EnrollmentID | FinalGrade
--- | --- | ---
| (→ Enrollments.EnrollmentID) |
1 | 1 | 88.5
2 | 2 | 92.3

## Library

LibraryID | Number_Of_Volumes | Shelving_Space | Library | Accessible | OpeningHours
--- | --- | --- | --- | --- | ---
1 | 500 | 1000 sq ft | University Main Library | Yes | Monday - Friday: 8am - 6pm, Saturday: 10am - 2pm, Sunday: Closed
2 | 300 | 750 sq ft | Engineering Library | No | Monday - Thursday: 8am - 8pm, Friday: 8am - 6pm, Weekends: Closed