Which of the following statements about a relation R in first normal form (1NF) is/are TRUE ?
- (A)
R can have a multi-attribute key
- (B)
R cannot have a foreign key
- (C)
R cannot have a composite attribute
- (D)
R cannot have more than one candidate key
Which of the following statements about a relation R in first normal form (1NF) is/are TRUE ?
R can have a multi-attribute key
R cannot have a foreign key
R cannot have a composite attribute
R cannot have more than one candidate key
ANSWER
The true statements are (A) and (C).
Official answer: A, CSource: Official answer key, GATE 2024 CS1 (IISc Bengaluru)
First normal form requires every attribute value to be atomic: no multivalued attributes, no nested relations and no composite attributes. It places no restriction on keys, foreign keys or the number of candidate keys.
(A) A key may be made of several attributes, e.g. in an enrolment relation, and the relation can still be in 1NF. TRUE.
(B) Foreign keys are allowed in a 1NF relation, e.g. an enrolment relation that references a student relation. So "cannot have a foreign key" is FALSE.
(C) A composite attribute such as Address (street, city, PIN) is not atomic, so a relation in 1NF cannot have one; it must be split into simple attributes. TRUE.
(D) A relation can have several candidate keys and still be in 1NF (even in BCNF), e.g. with both EmpID and Email as candidate keys. So the statement is FALSE.
Hence the true statements are (A) and (C).
KEY IDEA
1NF only demands atomic attribute values, which rules out composite and multivalued attributes. Keys, foreign keys and the number of candidate keys are not restricted.
WATCH OUT FOR
Treating 1NF as if it limited keys, for example thinking a multi-attribute key, a foreign key or several candidate keys break it. Those concerns belong to higher normal forms or to the relational model in general.
From the GATE 2024 CS1 paper. Every question of this paper · Download the full paper · All 19 Normal forms questions, with notes