1

How do I illustrate relationships which has an attribute in chen notation to crows foot notation?

Example:

enter image description here

There is an attribute "quantity" in the relation. How do I draw that in crow's foot notation? Thanks

1 Answer 1

1

You want an intersection entitiy:

Intersection entities are used in the resolution of a many to many relationship. This resolution is done in order to store additional information which doesn’t fit into the attribute list of either entity in the M:M relationship.

See the Class entity below.

Example of an intersection entity


Image source.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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