1. What data redundancies do you detect? How could those redundancies lead to anomalies? Give an example? 2. Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.1. FIGURE P1.1 The File Structure for Problems 1-4 FIGURE P1.1 THE FILE STRUCTURE FOR PROBLEMS 1-4 PROJECT BD PRICE 16833460.00 12500000.00 32512420.00 PROJECT CODE PROJECT MANAGER Holly B Parker Jane D. Grant MANAGER PHONE MANAGER ADDRESS George F. Dorts Holly B. Parker George F. Dorts Holly B Parker William K. Moor 904-338-3416 615-098-9909 615-227-1245 904-338-3416 615-227-1245 904-338-3416 904-445-2719 3334 Lee Rd, Gainesville, FL 37123 218 Clark Blvd, Nashville, TN 36362 124 River Dr. Franklin, IN 29105 3334 Lee Rd, Gainesville, FL 37123 124 River Dr., Frankdin, TN 29185 3334 Lee Rd, Gainesville, FL 37123 216 Morton Rd, Stetson, FL 30156 Given the file structure shown in Figure P1.1, answer Problems 1-4. 21-52 25-20 25-5A 25-91 27-40 29-20 31-7P 21563234 00 10314545.00 25559999.00 56850000.00 FIGURE P1.9 THE FILE STRUCTURE FOR PROBLEMS 9-10 BUILDING CODE ROOM CODE TEACHER UNAME TEACHER FNAME TEACHER INITIAL 204E Horace 123 Maria 504 Donald 34 Anne Janes Jeanette Maria Horace Maria Donald KOM KOM LDB KOM JKP LDB LDB KOM LDB 2258 301 204E 504 34 504 Williston Cordoza Patroski Hawkins Risell Robertson Cordoza Williston Cordoza Patrosk G - L 3 W P 1 0 L J DAYS TIME MAF 8:00-8:50 MMF 8,00-8:50 7Th 1:00-215 MAF 10.00-10:50 TTh 9:00-10-15 TTh 9:00-10:15 MAF 9:00-9.50 1Th 1:00-215 MMF 11:00-11:50 MAF 200-250 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.) 2. Given the file structure shown in Figure P1.9, what problem(s) might you encounter if building KOM were deleted?