Which of the following statements about Third Normal Form (3NF) is true?
PYQ IBPS SO CRP SPL-XII (2022)
Which of the following statements about Third Normal Form (3NF) is true?
- A.
A table is in 3NF if it is in 2NF and every non-prime attribute is non-transitively dependent on every key of the table.
- B.
A table is in 3NF if it is in 2NF and every non-prime attribute is dependent on every non-key attribute of the table.
- C.
A table is in 3NF if it has no transitive dependencies and every non-prime attribute is partially dependent on a candidate key.
- D.
A table is in 3NF if it has no repeating groups and all attributes are atomic.
- E.
A table is in 3NF if it is in 1NF and has only one candidate key.
Attempted by 74 students.
Sign up free to check your answer
Sign up freeLoading lesson…

