Suppose That You Need to Update One Value of the Column

question 50

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

---

Definitions:

Production Costs

Expenses directly associated with the creation of goods or services, including raw materials, direct labor, and manufacturing overhead.

Markup

The amount added to the cost price of goods to cover overhead and profit.

Predetermined Overhead Rate

A rate used to allocate indirect costs to products or services, estimated before the costs are incurred.

Direct Material

Raw materials directly used in the manufacturing of a product, explicitly traceable to the goods being produced.