modifying a database design and understanding diagrams

Please submit a Word document with your responses to the Extend Your Knowledge exercises on page 11-36.

1. Using the shorthand representation illustrated in this module, indicate the changes you would need to make to the CMF Vets database design shown in Figure 11–8 in order to support the following requirements: a. A given appointment may be assigned to more than one veterinarian. b. However, only one treatment is given by one veterinarian at a time.

2. Using the shorthand representation illustrated in this module, indicate the changes you would need to make to the Car First Insurers data design shown in Figure 11–10 to support the following requirements: a. Car First Insurers is expanding its business to insure recreational vehicles (RVs). b. In this expansion, the class of RV must be recorded along with any indication of ownership, loan, or rental.

3. Use the Access Relationships Report for the Financial Services database shown in Figure 11–35 to answer the following: a. Identify the foreign keys in the Client table. b. What is the purpose of the Services table? c. What are the primary keys of the Services table?

4. Financial Services has decided to add two tax advisors to the database. One tax advisor can

service many clients and clients may use different tax advisors during the year, depending on their needs. What changes would you need to make to the database design for Financial Services?