Question

Amsterdam quired format for the date of deposit is MM/DD/YYYY • The spellings of students' hometowns are correct in In Table B in Figure 6.38, identify and classify all instances of data quality problems (i.e., accuracy, uniqueness, completeness Bulgaria Neverland E6.8 Consider the 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. 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- 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 • All the passport numbers are correct in Table B. Table B. consistency, timeliness, and conformity problems).

Answer 1

The given table B has below problems:

1. Incorrect Date of Deposit for student id 200605. As per given details, date format should be MM/DD/YYYY but this record has full month name in date. Thus this column suffers from consistency issue.

2. Correctness and consistence problem in Student Home Town and Student Country

Consider the student ID -> 200606,200607 and 200610. All student has same ‘Student Home Town’ i.e. ‘Amesterdam’ , but their ‘Student Country’ is different which states that data is not consistence in these columns.

3. Completeness problem with Student Home Country attribute

All the students have ‘Student Home Country’ value except 200603 which makes the attribute incomplete.

4. Redundancy in Address fields (Student Home Town and Student Home Country)

If we consider values for 200606,200607 and 200610 students, all have same home address. The same value ‘Amesterdam’ is repeated multiple time. This could have been handled as a separate table providing a reference to this table to remove the redundancy. Thus the table suffers from redundancy problem also.

5. Recording of fees deposit in table A is inaccurate

The fee deposit has been done based on ‘Date of Deposit’ column which makes the data in table A incorrect. As a same date can have multiple students registered on it, there will be duplicate records and have a heavy risk of inaccurate data as there is no unique reference.

The table should have referred StudentID to store the fees which would have resulted in 9 total records.

6. Table A not required at all

As per given instruction, all the students are depositing some fee amount, instead of storing that in separate table, it would have been stored in same table also. OR not stored at all as fees is same for all students i.e. 1000.

7. Consistency in ‘Student Country Name’ as some shows country code and other shows name

First and second record on the table has stored the country code i.e. USA instead of ‘United State America’, but rest of the records has full country name. Thus the data is not consistence in it.