This question requires that you evaluate the underlined text to determine if it is correct.
A table whose attributes depend only on the primary key must be at least second normal
form.
Select the correct answer if the underlined text does not make the statement correct. Select
“No change is needed” if the underlined text makes the statement correct.
A.
No change is needed
B.
first
C.
third
D.
fourth
The correct answer is B
Correct is A. First normal form establish that no row has more than one value in a particular attribute. Second normal form determinates that all non-ley attributes depend only on primary key.
I think that correct answer is C. According to 3rd normal form; all fields that do not depend on the key must eliminated. ref : https://support.microsoft.com/en-us/help/283878/description-of-the-database-normalization-basics
Correct is A