Amsterdam quired format for the date of deposit is MM/DD/YYYY • The spellings of students' hometowns...

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.