Building_Name

idnameaddress
1Building A123 Main St
2Building B456 Elm St

University

iduniversity_namewebsite
1University of Examplehttp://www.example.com/univ

Libraries

idlibrary_namebuilding_iduniversity_id
(→ Building_Name.id)(→ University.id)
1Library A11
2Library B21
3Library C12
4Library D22

Students

idstudent_namebirthdatemajor
1John Doe2000-09-01Computer Science
2Jane Smith2002-08-15Biology
3Mike Johnson2003-10-20Mathematics
4Emily Davis2004-11-25English Literature
5David Brown2005-12-10Physics

Buildings

idbuilding_typecapacityaddress
1Administration Building1000123 Main St
2Engineering Building500456 Elm St

Classrooms

idclassroom_numberbuilding_id
(→ Buildings.id)
11011
21021
31031
41042
51052