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 |