Software Development Fundamentals — Question 56

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.

Answer options

• A. No change is needed
• B. first
• C. third
• D. fourth

Correct answer: A

Explanation

The correct answer is 'No change is needed' because a table that has attributes dependent only on the primary key indeed meets the criteria for second normal form. The other options, 'first', 'third', and 'fourth', incorrectly imply that the table's design should meet higher or different levels of normalization, which is not required in this case.