For example:

Gardens have attribute gate, Condos have attribute door. Some of the Gardens and Condos are Private_Properties. On the other hand, Private_Properties are not restricted to only Gardens or Condos.

How can these non-exclusive relationship be illustrated with an enhanced entity-relationship diagram (EERD)?


You can represent a 1..* relationship

Notation is quite standard but it may vary a little depending on your EER tool... Since I work with Oracle, I'm used to Oracle Data Modeler notation...

Check the picture... and good luck!

Oracle Data Modeler diagram

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.