Database problem Design a realtional schema based on ER Diag

Database problem. Design a realtional schema based on E-R Diagram.

BuildingID ResidesIn INSPECTOR Relationship BUILDING H EF Manages ManagerID MANAGER nsID AgtNo Locatedln APARTMENT Relationship 5,10 Cleans (1,2) SMembdID STAFF MEMBER CCID C+ coPRCLIENT k Refers

Solution

INSPECTOR(InsID)

BUILDING(BuildingID,InsID)

APARTMENT(BuildingID,AptNo) where BuildingID and AptNo is composite primary key

COPRCLIENT(CCID,BuildingID,AptNo)

MANAGER(ManagerID,BuildingID)

STAFFMEMBER(SmembdID,BuildingID,AptNo)

primary key - underlined

foreign key -italics