Register

GATE CSE 2024 | Set 1 | Question: 12

• retagged by
3,757 views
3 votes
3 votes

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

  1. $\mathbf{R}$ can have a multi-attribute key
  2. $\mathbf{R}$ cannot have a foreign key
  3. $\mathbf{R}$ cannot have a composite attribute
  4. $\mathbf{R}$ cannot have more than one candidate key
• retagged by
User Avatar

2 Answers

Best answer
2 votes
2 votes

B ,D are straightforward false because we can have a foreign key in 1NF and also we can have more than one candidate key.

The correct answer is A and C.

Source: Navathe

Source: Korth

• selected by
User Avatar
3 votes
3 votes

Option A

R can have a multi-attribute key

C is correct

Relation not in 1NF if it has composite or multivalued attributes. (Thanks for correction @Philosophical_Virus)

D and B are ofcourse trivially wrong, take an example of any where we decompose any relation using 3NF decomposition, not after decomposition if it is in 3NF then for sure it will be in 1NF, having foreign key and more than one candidate key.

• edited by
User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
1 answer
2
Arjun asked Feb 16
2,401 views
GATE CSE 2024 | Set 1 | Question: 36
Consider the following read-write schedule $\text{S}$ over three transactions $T_{1}, T_{2}$, and $T_{3}$ ... to $\text{S}$? $T_{1} T_{2} T_{3}$ $T_{1} T_{3} T_{2}$ $T_{3} T_{2} T_{1}$ $T_{3} T_{1} T_{2}$
​​​​Consider the following read-write schedule $\text{S}$ over three transactions $T_{1}, T_{2}$, and $T_{3}$, where the subscripts in the schedule indicate trans...
User Avatar
Link Copied!