The management of Colonial Adventure Tours asks you to research improvements it might make to its database

Question:

The management of Colonial Adventure Tours asks you to research improvements it might make to its database processing. To help management, they would like you to complete the following exercises. You do not use the Colonial Adventure Tours database for any of these exercises.
1. Create a class diagram for the Colonial Adventure Tours database, as shown in Figures 1-15 through 1-19 in Chapter 1. If you need to make any assumptions when preparing the class diagram, document those assumptions.
2. Colonial Adventure Tours would like to use XML to share the Trip table with a local hiking club. If you have access to a DBMS such as Access 2013, export the Trip table as an XML document. If you do not have access to a DBMS, use Figure 9-9 as a guide and create an XML document for the first two records (with TripID 1 and 2) in the Trip table.

Figure 1-15