You Are Working with a QUOTATIONS Table That Contains No

Multiple Choice

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