date base management

Using the Colonial Adventure Tours data requirements (see figures 1-16 thru 1-19):

Using Visio, create an Entity-relationship diagram that documents all of the entities, relationships and attributes; include both primary and foreign keys. Use the Crow's Foot Notation Template. Consider if data requirements were expanded to include support to track if a customer referred another customer(s). What change would be needed to the entity-relationship diagram? include your entity-relationship diagram