I am having trouble grasping the ‘Relationship’ concept of an ERD. For example; You have Classroom and Furniture as your entities. If you were to put a relationship diamond with the word ‘Contains’ and a line between the two, how would one be able to tell which contains which? Obviously we know that Furniture cannot contain a Classroom, however, when it comes to applications and data models there are often foreign concepts and terms meaning we have no prior knowledge of the relationship or possibilities.
Without actually having words to describe the diagram, which would defeat the purpose of the ERD (as it should speak for itself), how would one determine visually which way the relationship was flowing?
Thanks in advance π
FYI; in case it is relevant – the line touching Classroom has a ‘one and only one’ symbol, the line touching Furniture has a ‘zero through many’ symbol.