Match List I with List II Choose the correct answer from the options given…
2020
Match List I with List II
Choose the correct answer from the options given below:
- A.
A-II,B-IV,C-III,D-I
- B.
A-IV,B-I,C-II,D-III
- C.
A-II,B-I,C-IV,D-III
- D.
A-III,B-IV,C-I,D-II
Attempted by 806 students.
Show answer & explanation
Correct answer: C
Answer: The correct mapping is the one that matches each E-R symbol to its standard meaning.
Key insight: identify each symbol by its graphical convention in E-R diagrams.
Symbol: a rectangle with a double border → Weak Entity Type. Reason: Weak entities are drawn using a double rectangle to indicate dependence on an identifying relationship.
Symbol: an oval with an underline (attribute name underlined) → Key Attribute Type. Reason: Key attributes are shown by underlining the attribute name.
Symbol: a double oval → Multivalued Attribute Type. Reason: Multiple values for an attribute are represented by a double (nested) oval.
Symbol: a relationship diamond connected to an entity by a double line → Total Participation of the entity in the relation. Reason: Total participation is indicated by a double line between the entity and the relationship.
Therefore the correct matching is: double-bordered rectangle → Weak Entity Type; underlined oval → Key Attribute; double oval → Multivalued Attribute; relationship with double line → Total Participation.