Match the building blocks in Entity relationship diagram. A. Ellipse symbol — i. Relationship
Match the building blocks in Entity relationship diagram.
A. Ellipse symbol — i. Relationship
B. Line with a circle and a bar (─○|─) — ii. Attributes
C. Line with a double bar (─||─) — iii. Optional one
D. Diamond symbol — iv. Mandatory one
Show answerHide answer
Correct answer: (B) A-ii, B-iii, C-iv, D-i
Explanation
In an ER diagram an ellipse is an attribute and a diamond is a relationship. In crow's foot notation a circle with a bar means optional one, and a double bar means mandatory one.