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 |