Which type of table is an excellent candidate for improvement to second normal form?
A)table with duplicate records
B)lookup table
C)table with a multifield primary key field
D)table with an AutoNumber primary key field

Question

Quizplus · Accepted Answer

A table with a multifield primary key field is an excellent candidate for improvement to second normal form because 2NF requires that all non-key attributes are fully functional and dependent on the primary key, which can be complex to achieve with multifield primary keys.

Which Type of Table Is an Excellent Candidate for Improvement