Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Successful Keyword Searching Initiating Research On Popular Topics Using Electronic Databases

Authors: Randall MacDonald, Susan MacDonald

1st Edition

0313306761, 978-0313306761

More Books

Students also viewed these Databases questions

Question

c. Will leaders rotate periodically?

Answered: 1 week ago

Question

b. Will there be one assigned leader?

Answered: 1 week ago

Question

d. How will lack of trust be handled?

Answered: 1 week ago