Question Workspace

Check My Work

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$

$1.$ STUDENT$\_$ID

Select

$2.$ STUDENT$\_$NAME

Select

$3.$ ADDRESS

Select

$4.$ CITY

Select

$5.$ STATE

Select

$6.$ PHONE

Select