Question Workspace

Your company is concerned there is a problem with the data in one of the database tables. They want you to look at the data and determine if there is a problem. They have stressed it is important to have correct data as it is used for making decisions, and as a basis for reports for various departments.

Examine the data in the table and identify column$($s$)$ that contain data consistencies or inconsistences. Select the dropdown that is appropriate for each column.

STUDENT$\_$ID STUDENT$\_$NAME ADDRESS CITY STATE PHONE

$02134$ Melissa, Tandy $145$ Mountain Hall Lake Tahoe NV $775\mathrm{.}321\mathrm{.}7879$

$035678$ Cindy Lou, Hardie $324$ Flower Hall Virginia City $775\mathrm{.}345\mathrm{.}3210$

$45678$ Clayton $,$Harvey $145$ Mountain Hall Nevada $398\mathrm{.}4560$

$27869$ William, Zander $14$ Bighorn Lane Reno $775\mathrm{.}345\mathrm{.}7539$