Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You have a table full of data but have started finding some quality issues. Go through the table and identify the data quality issues that
You have a table full of data but have started finding some quality issues. Go through the table and identify the data quality issues that you notice, the field in which each issue occurs, and how you would fix it. Choose from the following data quality characteristics: comparability (consistency), understandability, error free, completeness, confirmatory value. ID Date Item Customer First Name Customer Last Name Amount A 000238 4/8/2020 Chocolate chip cookies Johnny Ramirez $9.56 B 239 4/9/2020 Oatmeal raisin cookies Johnny Ramirez $8.51 C 000240 4/31/2020 Snickerdoodle cookies Julia Rodriguez $4.20 D 000241 4/10/2020 PBC Annette lvarez $6.51 E 000242 4/11/2020 Chocolate chip cookies Brian $11.23 Type of Quality Characteristic A Consistency B C D E Confirmatory value Completeness Error Free Understandability Field(s) that failed How to fix Type of Quality Characteristic Field(s) that failed A Consistency B C D E Amount Customer First Name Customer Last Name Date ID Item N.A. How to fix Type of Quality Characteristic Field(s) that failed A Consistency B C D E How to fix No error PBC should be spelled out "Peanut Butter Cookies" There should be three leading O's The date was misstated - you can verify that there are not 31 days in April The last name is missing The first name is missing The amount is misstated
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started