Adding "Options" in ER-diagram

HTHVampire

New member
Local time
Today, 20:32
Joined
Mar 12, 2014
Messages
1
1. From the ERD attached, for entity property_for_rent, may I know that how can I make it to have options like there are 3 types of property to be rent: Room, Flat or House.
and for each property, there will be 2 options whether the room/flat/house are furnished or not furnished.

May I know that how should I add them in?

2. Can someone tells me what is the purpose of having client_staff entity present in the above ERD?
Thank you.
 

Attachments

  • ERD.PNG
    ERD.PNG
    70.3 KB · Views: 3,738
I would suggest a table with 3 (or more) type Room Flat House..
tblPropertyType
PropertyTypeCode PK
PropertyTypeName

And for Furnished
I would add a boolean field to PropertyFotRent

PropertyFurnishedYN Yes if funished No if not
 

Users who are viewing this thread

Back
Top Bottom