Students

StudentIDFirstNameLastName
1JohnDoe
2JaneSmith
3MichaelBrown
4AliceGreen
5TomWhite

Departments

DepartmentIDDepartmentName
1Computer Science
2Mathematics
3Physics
4Biology
5History

Courses

CourseIDCourseTitleRoomNumberBuildingStartTimeEndTime
1Introduction to Computer Science101Engineering9AM12PM
2Calculus I201Liberal Arts10AM1PM
3General Physics I301Science1PM4PM
4Human Biology401Health Sciences2PM5PM
5World History501Arts and Humanities8AM11AM

Buildings

BuildingIDNameAddress
1Engineering Building1 University Drive
2Liberal Arts Building2 University Drive
3Science Building3 University Drive
4Health Sciences Building4 University Drive
5Arts and Humanities Building5 University Drive

Rooms

RoomIDBuildingIDCapacity
(→ Buildings.BuildingID)
1011100
2012200
3013250
4014150
5015100