Class Exercises: FIGURE P1.3 The File Structure for Problems 9-10 page 34 FIGURE P1.3 The file structure for Problems 9-10 DAYS TIME ROOM CODE 204E BUILDING CODE KOM KOM TEACHER LNAME Mbhato TEACHER FNAME TEACHER INITIAL Horace G 123 Adam Maria L LDB 504 Donald J KOM 34 Patroski Hawkins Risell Anne w JKP 225B James MWF 8:00-8:50 MWF 8:00-8:50 TTh 1:00-2:15 MWF 10:00-10:50 TTh 9:00-10:15 TTh 9:00-10:15 MWF 9:00-9:50 TTh 1:00-2:15 MWF 11:00-11:50 MWF 2:00-2:50 LDB 301 Robertson Jeanette Maria 204E 1 KOM LDB 504 Horace G Adam Mbhato Adam Patroski KOM 34 L Maria Donald LDB 504 J 9 Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.3. (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 Adam.) 10 Given the file structure shown in Figure P1.3, which problem(s) might you encounter if building KOM were deleted