Database Management case study using Visio for the Colonial Adventure Tours data requirements.

Hello,

Here are the instructions for this assignment:

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

1. Using Visio, create an Entity-relationship diagram that documentsall of the entities, relationships and attributes; include both primaryand foreign keys. Use the Crow’s Foot Notation Template.
2. Consider if data requirements were expanded to include support totrack if a customer referred another customer(s). What change would beneeded to the entity-relationship diagram?

Copy and paste your entity-relationship diagram into a document. Bothrequirements (#1 & 2) can be submitted as a single document. Pleasemake sure that your work is submitted as a document and not in the file format of a diagramming tool that was used to create your ER diagram.

Your instructor will assess your performance and assign your grade.