Assignment 1Given the file structure shown in the following figure. a) Identify and discuss the serious data redundancy problemsb) 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 filed) 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?