Exercise $1$ Identify and discuss the serious data redundancy problems exhibited by the file structure.

Looking at the EMP$\_$NAME and EMP$\_$PHONE contents, what change$($s$)$ would you

recommend?

Given your answer to Problem $4,$ what new files should you create to help eliminate the data

redundancies?

Please put your response under each question.

FIGURE $1$ The File Structure for Problems $1-3$

How many records does the file contain? How many fields are there per record?

What problem would you encounter if you wanted to produce a listing by city? How would you

solve this problem by altering the file structure?

What data redundancies do you detect? How could those redundancies lead to anomalies?