Question 28Asked in DSSSB TGT Computer Science (Technical), 7 Aug 2021, Shift 2

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
  1. AA-ii, B-iii, C-i, D-iv
  2. BA-ii, B-iii, C-iv, D-i
  3. CA-iii, B-ii, C-iv, D-i
  4. DA-ii, B-i, C-iv, D-iii
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.

From DSSSB TGT Computer Science PYQ (Technical), 7 Aug 2021, Shift 2

This is question 28 of DSSSB TGT Computer Science PYQ (Technical), 7 Aug 2021, Shift 2. See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.