| id | name | address |
|---|---|---|
| 1 | Building A | 123 Main St |
| 2 | Building B | 456 Elm St |
| id | university_name | website |
|---|---|---|
| 1 | University of Example | http://www.example.com/univ |
| id | library_name | building_id | university_id |
|---|---|---|---|
| (→ Building_Name.id) | (→ University.id) | ||
| 1 | Library A | 1 | 1 |
| 2 | Library B | 2 | 1 |
| 3 | Library C | 1 | 2 |
| 4 | Library D | 2 | 2 |
| id | student_name | birthdate | major |
|---|---|---|---|
| 1 | John Doe | 2000-09-01 | Computer Science |
| 2 | Jane Smith | 2002-08-15 | Biology |
| 3 | Mike Johnson | 2003-10-20 | Mathematics |
| 4 | Emily Davis | 2004-11-25 | English Literature |
| 5 | David Brown | 2005-12-10 | Physics |
| id | building_type | capacity | address |
|---|---|---|---|
| 1 | Administration Building | 1000 | 123 Main St |
| 2 | Engineering Building | 500 | 456 Elm St |
| id | classroom_number | building_id |
|---|---|---|
| (→ Buildings.id) | ||
| 1 | 101 | 1 |
| 2 | 102 | 1 |
| 3 | 103 | 1 |
| 4 | 104 | 2 |
| 5 | 105 | 2 |