Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Statement Basics From Confusion To Comfort In Under 100 Pages

Authors: Axel Tracy

1st Edition

1522937285, 978-1522937289

More Books

Students also viewed these Accounting questions