ACC-315 Problem Set 1 Question 2

docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

315

Subject

History

Date

Feb 20, 2024

Type

docx

Pages

1

Uploaded by DeanGazelleMaster295

Report
Question 2 of 5 < View Policies Show Attempt History 10/10 = v Your answer is correct. 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 Alvarez $6.51 E 000242 4/11/2020 Chocolate chip cookies Brian $11.23 Type of Quality Characteristic Field(s) that failed How to fix A [ Error Free V‘ [ NA. V‘ [ No error B [ Consistency V‘ ID V‘ There should be three leading 0's C l Confirmatory value v‘ l Date v‘ l The date was misstated - you can verify that there are not 31 days in Apr D l Understandability Vl l Item Vl l PBC should be spelled out “Peanut Butter Cookies” E [ Completeness v‘ [ Customer Last Name v‘ [ The last name is missing
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help