Given the file structure shown in the the attachment.
- 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?
It is do in 3 hours.