TEACHER_INITIAL BUILDING_CODE KOM KOM LDB KOM L J W JKP ROOM_CODE- 204E 123 504 34 225B 301 204E 504 34 504 TEACHER_LNAME Williston Cordoza Patroski Hawkins Risell Robertson Cordoza Williston Cordoza Patroski TEACHER_FNAME Horace Maria Donald Anne James Jeanette Maria Horace Maria Donald DAYS_TIME 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 KOM LDB KOM LDB G L J Questions 7-10 refer to Figure 3: 7.Explain why the existing data structure does not succeed in uniquely identify the teacher, and what change(s) should be made to address this. 8. What change(s) would be necessary to support a need to find a classes that have meetings on a specific day of the week? (For example, if you wanted to be able to easily produce a list that have course meetings on Fridays.) 9. What change(s) would be necessary to support a need to list only classes that end before noon? 10.Imagine that the LDB building is to be demolished over the summer break, and therefore must be deleted from this classroom assignments file. What problem(s) arise(s) if every occurrence of LDB" from the Building Code field is deleted, and what solutions do you propose for dealing with it/them? TEACHER_INITIAL BUILDING_CODE KOM KOM LDB KOM L J W JKP ROOM_CODE- 204E 123 504 34 225B 301 204E 504 34 504 TEACHER_LNAME Williston Cordoza Patroski Hawkins Risell Robertson Cordoza Williston Cordoza Patroski TEACHER_FNAME Horace Maria Donald Anne James Jeanette Maria Horace Maria Donald DAYS_TIME 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 KOM LDB KOM LDB G L J Questions 7-10 refer to Figure 3: 7.Explain why the existing data structure does not succeed in uniquely identify the teacher, and what change(s) should be made to address this. 8. What change(s) would be necessary to support a need to find a classes that have meetings on a specific day of the week? (For example, if you wanted to be able to easily produce a list that have course meetings on Fridays.) 9. What change(s) would be necessary to support a need to list only classes that end before noon? 10.Imagine that the LDB building is to be demolished over the summer break, and therefore must be deleted from this classroom assignments file. What problem(s) arise(s) if every occurrence of LDB" from the Building Code field is deleted, and what solutions do you propose for dealing with it/them