HOMEWORK ATTATCHED

given the file structure shown in the following figure.

  HOMEWORK ATTATCHED 1

a)   Identify and discuss the serious data redundancy problems

b)   Looking at the storage format of the EMP_NAME and EMP_PHONE columns, what change(s) would you recommend?

c)   Identify the different data themes or topics in the file

d)   Given your answer to question c), what new files should you create to help eliminate the data redundancies found in the file shown in the figure?