Solved

Use the Database Table Below to Answer the Following Questions

Question 85

Essay

Use the database table below to answer the following questions. 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?
-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?

Correct Answer:

verifed

Verified

The database integrity rule 3: domain in...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions