Consider the a following scenario. At Albus International Academy, every incoming student makes a $1,000 deposit. Albus International Academy has 10 incoming students, and each of them has made a deposit. This information is reflected in Table A in Figure 6.38. Table B in Figure 6.38 contains information about the incoming students populated by the data entry person at Albus International Academy. Assume the following:
• Each deposit made by each incoming student is correctly 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 required 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.
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).