BuildingID NoOfFloors BUILDING Manages Resides In MANAGER Ma

BuildingID NoOfFloors BUILDING Manages Resides In MANAGER Manager Manager Name

Solution

There are two tables included in the above given ER diagram

BUILDING

MANAGER

hence

Table BUILDING(BuildingID, NoOfFloors)

Table MANAGER( ManagerId, ManagerName)

Relational Schema for Manages:

Primary key for BUILDING is BuildingID

Primary Key for MANAGER is ManagerId

Manages(BuildingID, ManagerId)

MANAGER(ManagerId, ManagerName)

  BUILDING ( BuildingID, NoOfFloors,ManagerId)

Relational Schema for ResidesIn

It is zero or one to one relation, either zero or one manager resides in 1 building

  

BUILDING(BuildingID, NoOfFloors)

MANAGER( ManagerId, ManagerName,BuildingID)