for my itec class

Chapter 1 Database Syste FIGURE P1.5 THE FILE STRUCTURE FOR PROBLEMS 5-8 HEM 101 110 41016233.59 14 75 18 25 151 115-1335 2017 2000 2 6. Looking at the EMP_NAME and EMP_PHONE contents in Figure P1.5, what change(s) would you recommend? 7. Identify the various data sources in the file you examined in Problem 5. 8. Given your answer to Problem 7, what new files should you create to help eliminate the data redundancies found in the file shown in Figure P1.5? 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.) FIGURE P1.9 THE FILE STRUCTURE FOR PROBLEMS 9-10 ROND GOOONO TRADE CE TEACHER NAMETERDENTAL DAYS TIME W 0050 OM 23 wer WWF-050 Per Do Th00-215