1. Identify and discuss the serious data redundancy problems exhibited by the fi
ID: 3747680 • Letter: 1
Question
1. 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 - that two different initials have been entered for the teacher named Maria Cordoza.) FIGURE P1.9 The File Structure for Problems 9-10 BUILDING_CODE ROOM_CODE TEACHER_LNAME TEACHER_FNAME TEACHER INITIALDAYS_TIME KOM KOM LDB KOM JKP LDB KOM LDB KOM LDB 204E 123 504 34 225B 301 204E 504 34 504 Williston Cordoza Patroski Hawkins Risell Robertsorn Cordoza Williston Cordoza Patroski Horace Maria Donald Anne James Jeanette Maria Horace Maria Donald MWWF 8.00-8:50 MWF 8:00-8:50 TTh 1:00-2:15 MVVF 10:00-10:50 TTh 9:00-10:15 TTh 9:00-10:15 MWF 9:00-9:50 TTh 1:00-2:15 MWWF 11:00-11:50 MVWF 2:00-2:50 2. Given the file structure shown in Figure P1.9, what problem(s) might you encounter if building KOM were deleted?Explanation / Answer
Answer :
1. The data redundancy problems exhibited by the file are:
The TEACHER_INITIAL column holds two different initials for the teacher, Maria Cordoza, that are ‘I’ and ‘L’.
This would lead to inconsistency and inaccuracy of data regarding the identification of the teacher Maria Cordoza. Both the initials would retrieve only partial and incomplete details of her classes. The DAYS_TIME column holds two classes, one with Horace Willingston and the other with Maria Cordoza, on the same days and timings “MWF 8:00-8:50”.
This would lead inconsistency of data regarding the lecture on “MWF 8:00-8:50”.
2. Deletion of building KOM would lead to the below mentioned consequences:
Details of the teacher Maria Cordoza would be deleted from the database. Details of classes on “MWF” would be deleted from the database.
This would lead to lack of data integrity in the database as the data would no longer be accurate and consistent with the real-life scenario.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.