What is the relational schema / logical schema of below digaram: For each relational schema created clearly list the names of attributes, primary keys, candidate keys (if any), and foreign keys (if any).

 

name City ID streetName streetNumber Hosts - 0..1 name Campus ID1 building Has 0..1 Building total floors building name [0..1] Faculty name budget De an Located at A room ID Has - 0..1 Laboratory total equipment area Room Lecture capacity Office total_chairs