Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure. (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€“that two different initials have been entered for the teacher named Maria Cordoza.)

Transcribed Image Text:

BUILDING KOM KOM LDB KOM _CODE ROOM CODE TEACHER LNAME TEACHER FNAME TEACHER NITIAL DAYS_TIME Horace Maria illiston Cordoza Patroski Hawkins Risell Robertson Cordoza M/VF 8:00-8:50 M/VF 8:00-8:50 TTh 1:00-2:15 MVF 10:00-10:50 TTh 9:00-10:15 TTh 9:00-10:15 MVVF 9:00-9:50 TTh 1:00-2:15 MWF 11:00-11:50 M/vF 2:00-2:50 204E 504 34 225日 301 204E 504 34 504 Anne LDB KOM LDB KOM LDB ames Jeanette Maria Horace Maria illiston Cordoza Patroski