## Students

StudentID | FirstName | LastName
--- | --- | ---
1 | John | Doe
2 | Jane | Smith
3 | Michael | Brown
4 | Alice | Green
5 | Tom | White

## Departments

DepartmentID | DepartmentName
--- | ---
1 | Computer Science
2 | Mathematics
3 | Physics
4 | Biology
5 | History

## Courses

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

## Buildings

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

## Rooms

RoomID | BuildingID | Capacity
--- | --- | ---
| (→ Buildings.BuildingID) |
101 | 1 | 100
201 | 2 | 200
301 | 3 | 250
401 | 4 | 150
501 | 5 | 100