Critical Thinking Questions Case 2 in Your Database Course, Your

question 136

Multiple Choice

Critical Thinking Questions Case 2 In your database course, your instructor has given you a small database that has a lot of invalid data, issuing the challenge to you that you work to apply validation rules to the data and determine what checks need to be applied in order to restore integrity to the data. The instructor tells you that this is a mailing database, and yet you can see at a glance that there are some records with no data in the city fiel d. What kind of check should you run on this field?

• A) completeness check
• B) consistency check
• C) range check
• D) check digit

---

Definitions:

Annual Interest Rate

The percentage increase in money that borrowers pay lenders over a year, based on the original amount of the loan.

U.S. Income Tax System

The progressive tax system in the United States where taxes are based on income levels and include deductions and credits, resulting in varying rates.

Indexed for Inflation

A mechanism to adjust income payments or prices by taking into account the rate of inflation to preserve purchasing power.

Price Level

An index that measures the average of the prices of goods and services in an economy, indicating the cost of living or inflation.