StudentID | FirstName | LastName |
---|---|---|
1 | John | Doe |
2 | Jane | Smith |
3 | Michael | Brown |
4 | Alice | Green |
5 | Tom | White |
DepartmentID | DepartmentName |
---|---|
1 | Computer Science |
2 | Mathematics |
3 | Physics |
4 | Biology |
5 | History |
CourseID | CourseTitle | RoomNumber | Building | StartTime | EndTime |
---|---|---|---|---|---|
1 | Introduction to Computer Science | 101 | Engineering | 9AM | 12PM |
2 | Calculus I | 201 | Liberal Arts | 10AM | 1PM |
3 | General Physics I | 301 | Science | 1PM | 4PM |
4 | Human Biology | 401 | Health Sciences | 2PM | 5PM |
5 | World History | 501 | Arts and Humanities | 8AM | 11AM |
BuildingID | Name | Address |
---|---|---|
1 | Engineering Building | 1 University Drive |
2 | Liberal Arts Building | 2 University Drive |
3 | Science Building | 3 University Drive |
4 | Health Sciences Building | 4 University Drive |
5 | Arts and Humanities Building | 5 University Drive |
RoomID | BuildingID | Capacity |
---|---|---|
(→ Buildings.BuildingID) | ||
101 | 1 | 100 |
201 | 2 | 200 |
301 | 3 | 250 |
401 | 4 | 150 |
501 | 5 | 100 |