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?

Question

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?

Quizplus · Accepted Answer

The Answer of 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?

Use the Database Table Below to Answer the Following Questions