A B C D E A B C D E Type of Quality Characteristic Consistency Type of Quality Characteristic # Consistency Field(s) that failed Amount Customer First Name Customer Last Name Date ID Item N.A. Show Transcribed Text Ű Field(s) that failed How to fix How to fix No error PBC should be spelled out "Peanut Butter Cookies" There should be three leading 0'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 A

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
Please do not Give image format and Proper solution
A
B
с
D
E
A
B
с
D
E
Type of Quality
Characteristic
Consistency
Type of Quality
Characteristic
#
Consistency
Field(s) that failed
Amount
Customer First Name
Customer Last Name
Date
ID
Item
N.A.
Show Transcribed Text
Field(s) that failed
Ċ
The first name is missing
The amount is misstated
How to fix
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
#
;
#
#
#
Transcribed Image Text:A B с D E A B с D E Type of Quality Characteristic Consistency Type of Quality Characteristic # Consistency Field(s) that failed Amount Customer First Name Customer Last Name Date ID Item N.A. Show Transcribed Text Field(s) that failed Ċ The first name is missing The amount is misstated How to fix 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 # ; # # #
A
B
с
D
E
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.
A
B
ID
000238
239
4/8/2020
Date
4/9/2020
C
000240
4/31/2020
D 000241 4/10/2020 PBC
E
✓ Consistency
Type of Quality
Chaunabauintin
Item
Chocolate chip cookies
Oatmeal raisin cookies
000242 4/11/2020 Chocolate chip cookies
Confirmatory value
Completeness
Error Free
Understandability
Snickerdoodle cookies
J
Customer First Name
Johnny
Johnny
Julia
Field(s) that failed
Annette
Show Transcribed Text
Brian
Customer Last Name
Ramirez
Ramirez
Rodriguez
Álvarez
Amount
How to fix
$9.56
$8.51
$4.20
$6.51
$11.23
;
Transcribed Image Text:A B с D E 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. A B ID 000238 239 4/8/2020 Date 4/9/2020 C 000240 4/31/2020 D 000241 4/10/2020 PBC E ✓ Consistency Type of Quality Chaunabauintin Item Chocolate chip cookies Oatmeal raisin cookies 000242 4/11/2020 Chocolate chip cookies Confirmatory value Completeness Error Free Understandability Snickerdoodle cookies J Customer First Name Johnny Johnny Julia Field(s) that failed Annette Show Transcribed Text Brian Customer Last Name Ramirez Ramirez Rodriguez Álvarez Amount How to fix $9.56 $8.51 $4.20 $6.51 $11.23 ;
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Database management system (DBMS)
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education