| ID | FirstName | LastName | DateOfBirth | PhoneNumber | |
|---|---|---|---|---|---|
| 1 | John | Doe | 2003-06-18 | john.doe@example.com | +1234567890 |
| 2 | Jane | Smith | 2002-05-20 | jane.smith@example.com | +0987654321 |
| 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 |
| EnrollmentID | StudentID | CourseID | Semester | Year |
|---|---|---|---|---|
| (→ Students.ID) | (→ Courses.CourseID) | |||
| 1 | 1 | 1 | Fall | 2023 |
| 2 | 2 | 2 | Spring | 2023 |
| GradeID | EnrollmentID | FinalGrade |
|---|---|---|
| (→ Enrollments.EnrollmentID) | ||
| 1 | 1 | 88.5 |
| 2 | 2 | 92.3 |
| 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 |