Question: OFFICE ( OfficeID ( PK ) , Address, Phone ) OWNER ( OwnerID ( PK ) , Name, ContactInfo ) PROPERTY ( PropertyID ( PK

OFFICE (OfficeID (PK), Address, Phone)
OWNER (OwnerID (PK), Name, ContactInfo)
PROPERTY (PropertyID (PK), Address, OwnerID (FK), OfficeID (FK))
SERVICE_CATEGORY (CategoryID (PK), Name, Description)
SERVICE_REQUEST (RequestID (PK), PropertyID (FK), CategoryID (FK), Description, Status)
RESIDENTS (ResidentID (PK), Name, PropertyID (FK), ContactInfo)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!