Question: 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

 Your company is concerned there is a problem with the data

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 NV 775.321.7879 Lake Tahoe 035678 775.345.3210 Cindy Lou, Hardie Virginia City 145 Mountain Hall 324 Flower Hall 145 Mountain Hall 14 Bighorn Lane 45678 Clayton , Harvey Nevada 398.4560 27869 William, Zander Reno 775.345.7539 1. STUDENT_ID Select 2. STUDENT_NAME Select 3. ADDRESS Select . 4. CITY Select + 5. STATE Select 6. PHONE Select 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 NV 775.321.7879 Lake Tahoe 035678 775.345.3210 Cindy Lou, Hardie Virginia City 145 Mountain Hall 324 Flower Hall 145 Mountain Hall 14 Bighorn Lane 45678 Clayton , Harvey Nevada 398.4560 27869 William, Zander Reno 775.345.7539 1. STUDENT_ID Select 2. STUDENT_NAME Select 3. ADDRESS Select . 4. CITY Select + 5. STATE Select 6. PHONE Select

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!