Answered step by step
Verified Expert Solution
Question
1 Approved Answer
TABLE A: INCOMING STUDENTS DEPOSITS DepositDeposit Date Amount /12/2013 $1,000 212/2013 $1.000 2/13/2013 $1,000 /13/2013 $1,000 2/14/2013 $1,000 2/14/2013 $1,000 /15/2013 $1,000 2/15/2013 $1000 2/16/2013
TABLE A: INCOMING STUDENTS DEPOSITS DepositDeposit Date Amount /12/2013 $1,000 212/2013 $1.000 2/13/2013 $1,000 /13/2013 $1,000 2/14/2013 $1,000 2/14/2013 $1,000 /15/2013 $1,000 2/15/2013 $1000 2/16/2013 $1,000 2/16/2013 $1,000 Total No of Students E6.8 Consider the following scenario. At Albus International Academy, every incoming student makes a $1,000 deposit. Albus International Academy has 10incoming students, and each of them has made a deposit Thisinformation is reflected in Table A in Figure6.38. TableB in Figure 6.38 contains information about the incoming stu- dents populated by the data entry person at Albus Interna- tional Academy. Assume the following . Each deposit made by each incoming student is cor- 10 Total Amount of $10,000 Deposits TABLE B: INCOMING STUDENTS INFORMATION Student ID Student Student Passport Date of Deposit Student HomeStudent Home Lname Fname Number Town Detrot Tok Country USA 200602 McCoy Mark US2000001 02/12/2013 200603 Suzuki 200604 Jones 200605 Laime Prick CA3000001 February 13th, 2013 Montreal 200606 Van Basten Robin NE4000001 02/14/2013 rectly recorded in Table A The spellings of students last names are correct in Table B. The spellings of students' first names (and/or their abbreviations) are correct in Table B All the dates of deposit are correct in Table B. The re quired format for the date of deposit is MM/DD/YYYY All the passport numbers are correct in Table B The spellings of students' hometowns are correct in Table B AkikoJA7000001 02/12/2013 Mary US2000002 02/13/2013 USA 200607 Van Baston Rob 200608 Vrabec NE4000001 02/14/2013 AlenCR5000001 02/14/2013 Amsterdam Netherlands Croatia 200 Popoy Silian BU6000001 02/15/2013 200810 De BeersneNE4000002 02/15/2013 terdam Neverland Total Number of In Table B in Figure 6.38, identify and classify all instances of data quality problems (i.e., accuracy, uniqueness, completeness consistency, timeliness, and conformity problems). Students
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