id | name | location |
---|---|---|
1 | Harvard University | Cambridge, MA |
2 | Stanford University | Stanford, CA |
3 | University of California Berkeley | Berkeley, CA |
4 | Massachusetts Institute of Technology | Cambridge, MA |
5 | California Institute of Technology | Pasadena, CA |
id | type | description |
---|---|---|
1 | Library | A place where books and resources are stored. |
2 | Administration Building | The main office building on campus. |
3 | Lecture Hall | Large rooms used for lectures and presentations. |
4 | Dormitory | Residential living space for students. |
5 | Gymnasium | Facility for sports activities. |
campusId | buildingId |
---|---|
(→ College_Campuses.id) | (→ Buildings.id) |
1 | 1 |
1 | 2 |
2 | 1 |
2 | 3 |
3 | 1 |
4 | 1 |
5 | 1 |