The GATE Grind

GATE 2024 CS (CS1) – Question 22

Databases · Integrity Constraints and Normal Forms · 1 mark · Multiple select

Which of the following statements about a relation $\mathbf{R}$ in first normal form (1NF) is/are TRUE?

  1. R can have a multi-attribute key
  2. R cannot have a foreign key
  3. R cannot have a composite attribute
  4. R cannot have more than one candidate key

Practise this question in The GATE Grind →

Show answer and explanation

Correct answer: (A) R can have a multi-attribute key; (C) R cannot have a composite attribute

Explanation

1NF requires atomic attributes, so composite attributes are disallowed, but composite (multi-attribute) keys, foreign keys and multiple candidate keys are all allowed.