GateAI
ER Model

GATE CSE 2018 · Q11

MCQ1 markMedium

Time

In an Entity-Relationship (ER) model, suppose RR is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 and E2 participate totally in RR and that the cardinality of E1 is greater than the cardinality of E2.

Which one of the following is true about RR?

Select one answerSingle correct

Pick an option to check

Solution

Step-by-step verified solution

Official answer: A) Every entity in E1 is associated with exactly one entity in E2.

ER Model
  1. In a many-to-one relationship from entity set E1E_1 to entity set E2E_2, each entity in E1E_1 can be associated with at most one entity in E2E_2.

  2. Total participation of E1E_1 in RR means that every entity in E1E_1 must be associated with at least one entity in E2E_2.

Combining both conditions ("at most one" and "at least one"), every entity in E1E_1 must be associated with exactly one entity in E2E_2. Therefore, option (A) is correct.

Analysis of other options:

  • (B) False: A many-to-one mapping forbids any entity in E1E_1 from being linked to multiple entities in E2E_2.

  • (C) & (D) False: Since ∣E1∣>∣E2∣|E_1| > |E_2| and all entities of E1E_1 participate, by the Pigeonhole Principle, at least one entity in E2E_2 must be linked to more than one entity in E1E_1.

Try the question first, then check your work.

Think the official key or this write-up is wrong?

Report error or challenge

Examiner trap

The misconception this question tests

This ER Model previous year question is Q11 of the GATE CSE 2018 paper. Find more GATE CSE PYQs on ER Model in Databases, or browse all GATE CSE PYQs.

Free diagnostic

Where do you stand for GATE?

Take the 20-minute diagnostic: the 3 topics that cost you the most marks, and a rank range. Or sit 5 related ER Model PYQs now with no account.

One GATE CSE PYQ every morning

An official question by email at 7 AM IST, with a link to its verified solution. Unsubscribe in one click.

ER Model in GATE CSE

ER Model has 8 GATE CSE PYQs across 8 papers from 2012 to 2026. 7 of them are 1-mark MCQs like this one, and it is the only one in GATE CSE 2018.

How GATE tests ER Model

More from GATE CSE 2018

Share this solution

A plain-text card for WhatsApp or Telegram study groups.

GateAI solution cardGATE CSE 2018 · Q11 · MCQ

In an Entity-Relationship (ER) model, suppose R is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 and E2 participate totally in R and that the cardinality of E1 is greater than the cardinality of E2. Which one of the following is true about R?

Topic-wise GATE CS PYQs with verified steps

Independent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.