Modifying a Database Design and understanding Diagrams Inntrywnows: Answer the following questions in the format specified by your instructor. I. Using the shorthand representation in the changes that you would need to make to the Camashaly Design database shown II-H on page AC 688 in order to support the design following requirement A client does not necessarily work with one business analyst but can work with several business analysts. 2. Using the shorthand representation indicate the changes that you would need to make to the Scryps Distributor database design shown in Figure 10 on page AC 694 in order to support, following requirement: The price for a part does not change but is the same for all customers. 3. Use the Access Relationship report for the Regional Books database shown in Figure 11-35 to answer the following: a. Identify the foreign keys in the Book table. b. What is the purpose of the Book Order table? c. What is the primary key of the Book order table? d. Identify the foreign keys in the Book Order table? elationships for Regional Books ursday, April 12, 2012 or Number Las Name Book Code Customer Number Date Book Type Units on Hand Customer Number ast Name First Name Phone Number Publisher Name Order Date Figure 11-35