You Are Working with a QUOTATIONS Table That Contains No

question 15

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

---

Definitions:

Average Rate

An indicative value representing the mean of several different rates or prices, commonly used in finance.

Exchange Rates

The value of one currency for the purpose of conversion to another.

Inventory Purchase

The acquisition of goods and materials a company intends to sell or use in the production process.

Amount Record

The documentation of the monetary value of transactions or balances.