Use the Database Table Below to Answer the Following Questions

question 27

Essay

Use the database table below to answer the following questions.
-An audit of customer records in the accounting database reveals data in the state field was entered inconsistently. Some customers' states were entered using the two letter abbreviation (MO, CA, or IA)and others were spelled out (Missouri, California, or Iowa). Which database integrity rule is not being followed? What type of controls can be implemented to prevent this in the future?

---

Definitions:

Trade-Off

A situation that involves losing one quality, quantity, or property of a set or design in return for gaining another.

Inflation

The speed at which the overall price level for goods and services increases, thereby diminishing the buying power.

Productive Capacity

The maximum output that an economy can produce without increasing inflation, given its current level of resources.

Equity

Fairness or justice in the way people are treated or the distribution of resources, often distinguished from equality by focusing on needs and outcomes.