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:

Less Cautious

Characterized by a diminished level of carefulness, vigilance, or prudence, potentially leading to increased risk-taking behavior.

Bigger

Describes something of larger size, volume, or extent than others of its kind.

Aggressive-rejected

Describes individuals, often children or adolescents, who are frequently excluded or marginalized by their peers due to hostile or aggressive behavior.

Withdrawn-rejected

Describes individuals, often in psychological and educational contexts, who are both socially withdrawn and rejected by peers.