BUILDING CODE ROOM_CODE KOM 204E Williston KOM 123 Cordoza LDB 504 Patroski FIGURE P1.9 THE FILE STRUCTURE FOR PROBLEMS 9-10 TEACHER_LNAME TEACHER_FNAME TEACHER INITIAL DAYS_TIME MVVF 8:00-8:50 MVVF 8:00-8:50 TTh 1:00-2:15 Horace Maria G L Donald J KOM 34 Hawkins Anne W MVVF 10:00-10:50 JKP 2258 Risell James TTH 9:00-10:15 LDB 301 Robertson Jeanette P TTH 9:00-10:15 KOM 204E Cordoza Maria MVVF 9:00-9:50 LDB 504 Williston Horace G TTh 1:00-2:15 KOM 34 Cordoza Maria L MVVF 11:00-11:50 LDB 504 Patroski Donald MVVF 2:00-2:50 9. Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.9. (The file is meant to be used as a teacher class assignment schedule. One of the many problems with data redundancy is the likely occurrence of data inconsistencies-two different initials have been entered for the teacher named Maria Cordoza.) 10. Given the file structure shown in Figure P1.9, what problem(s) might you encounter if building KOM were deleted?