Suppose That You Need to Update One Value of the Column

question 9

Multiple Choice

Suppose that you need to update one value of the column SalesCost in a relation.The way the relation is constructed,this value actually needs to be changed in three different rows.However,you only change the value in two of the rows.You have just created a(n) ________.

• A)normalization anomaly
• B)insertion anomaly
• C)update anomaly
• D)deletion anomaly
• E)removal anomaly

---

Definitions:

Distributors

Intermediaries in the supply chain who facilitate the movement of products from manufacturers to the marketplace.

Electronic Exchanges

Digital platforms that facilitate the trading of financial instruments, commodities, or other items between parties.

Third Party

An entity involved in a transaction or agreement that is separate from the two main parties, often providing additional services or products.

Direct Materials

Raw materials that are directly incorporated into a final product during the manufacturing process.