1. Ch.1, Problems #9, Page 33.

Ch.1. Problems #10, Page 33.

Ch.2. Problem #14, Page 65 (Note: you will need to use MS Word or MS Visio to draw the preliminary ER model)

Ch.2. Problem #15, Page 65

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 inconsistenciestwo different initials have been entered for the teacher named Maria Cordoza.) Figure P1.9 The File Structure for Problems 9-10 204E BUILDING_CODE ROOM_CODE TEACHER_LNAME TEACHER_FNAME TEACHER_INITIAL DAYS_TIME KOM Williston Horace M/F 8:00-8:50 KOM 123 Cordoza Maria L MWF 8:00-8:50 LDB 504 Patroski Donald J TTh 1:00-2:15 KOM 34 Hawkins Anne w MWF 10:00-10:50 JKP 2258 Risell James TTH 9:00-10:15 LDB 301 Robertson Jeanette P TTh 9:00-10:15 KOM 204E Cordoza Maria MWF 9:00-9:50 LDB 504 Williston Horace TTH 1:00-2:15 KOM 34 Cordoza Maria L MWF 11:00-11:50 LDB 504 Patroski Donald J MWF 2:00-2:50 - Figure P1.9 The File Structure for Problems 9-10 BUILDING_CODE ROOM_CODE TEACHER_LNAME TEACHER_FNAME TEACHER_INITIAL DAYS_TIME KOM 204E Williston Horace G MWF 8:00-8:50 KOM 123 Cordoza Maria L MWF 8:00-8:50 LDB 504 Patroski Donald J TTh 1:00-2:15 KOM 34 Hawkins Anne w M/F 10:00-10:50 JKP 2256 Risell James TTh 9:00-10:15 LDB 301 Robertson Jeanette P TTH 9:00-10:15 | KOM 204E Cordoza Maria MWF 9:00-9:50 LDB 504 Williston Horace G TTh 1:00-2:15 | 34 Cordoza Maria L MWF 11:00-11:50 504 Patroski Donald J MWF 2:00-2:50 - LDE 10. Given the file structure shown in Figure P1.9, what problem(s) might you encounter if building KOM were deleted? 14. Create a Crow's Foot ERD to include the following business rules for the ProdCo company: a. Each sales representative writes many invoices. b. Each invoice is written by one sales representative. c. Each sales representative is assigned to one department. d. Each department has many sales representatives. e. Each customer can generate many invoices. f. Each invoice is generated by one customer. 15. Write the business rules that are reflected in the ERD shown in Figure P2.15. (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember that the ERD is always read from the 1 to the M side, regardless of the orientation of the ERD components.) Figure P2.15 The Crow's Foot ERD for Problem 15 PUBLISHER BOOK publishes submits writes CONTRACT AUTHOR signs