## Building_Name

id | name | address
--- | --- | ---
1 | Building A | 123 Main St
2 | Building B | 456 Elm St

## University

id | university_name | website
--- | --- | ---
1 | University of Example | http://www.example.com/univ

## Libraries

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

## Students

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

## Buildings

id | building_type | capacity | address
--- | --- | --- | ---
1 | Administration Building | 1000 | 123 Main St
2 | Engineering Building | 500 | 456 Elm St

## Classrooms

id | classroom_number | building_id
--- | --- | ---
|  | (→ Buildings.id)
1 | 101 | 1
2 | 102 | 1
3 | 103 | 1
4 | 104 | 2
5 | 105 | 2