The GATE Grind

GATE 2012 CS (CS1) – Question 24

Databases · ER-Model and Database Architecture · 1 mark · Multiple choice

For basic ER and relational models, which is incorrect?

  1. An entity attribute can have several values.
  2. An entity attribute can be composite.
  3. One relational-table row can contain several values for one attribute.
  4. One relational-table row can contain one value or NULL for an attribute.

Practise this question in The GATE Grind →

Show answer and explanation

Correct answer: (C) One relational-table row can contain several values for one attribute.

Explanation

ER modelling permits multivalued and composite attributes. In the basic first-normal-form relational model each row/attribute cell contains one atomic value, or an allowed null marker, rather than multiple values. Thus C is the incorrect statement.

More ER-Model and Database Architecture questions

All ER-Model and Database Architecture questions →