| 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 |