You are working with a QUOTATIONS table that contains no repeating groups and has a primary key consisting of the SERVICE_CODE and SPECS columns. You realize that some other columns in the table functionally depend on either SERVICE_CODE or SPECS, but not both, whereas the rest depend on both. How should you improve this table?
A) remove the multiple entries from the SERVICE_CODE and SPECS columns
B) eliminate any columns that determine other columns from the table
C) combine SERVICE_CODE and SPECS into a single-column primary key
D) replace it with three tables with the following primary keys: SERVICE_CODE, SPECS, and SERVICE_CODE plus SPECS

Question

Quizplus · Accepted Answer

The table violates the Second Normal Form (2NF) because it has partial dependency; some columns depend on part of the primary key. Splitting the table into three, where one table has SERVICE_CODE as a primary key, another has SPECS as a primary key, and the third combines both, resolves the partial dependency issue and achieves 2NF.

You Are Working with a QUOTATIONS Table That Contains No