Using Visio, Create ERD upto 3rd normal form for the given scenerio:

Please follow the instructions of Rubric:

A small company that rents canoes needs a database to track basic information about the rental and the canoes.The hourly rental fee is based on the size and material of the canoe, The firm wants to identify customers who cause problems by damaging, the canoe and track the costs. The managers have outlined the data as a paper form shown below which also shows some(not all) example data.

Grading Rubric:

1) The entities are appropriate

2) Entities are appropriately named

3) Attributes are present and appropriately named

4) All entities have correct primary and foreign keys

5) Each attribute has an appropriate datatype consistent with problem

6) Type and direction of relationship is correctly defined

7) Cardinalities are correct

Rental ID Customer Name Mary Black Email Phone Address City, State Postal Code Country Canoe Length Material Number 105 17 ft Plastic Aluminum, 14 ft 125 11 ft Fiber Composite Provo River Canoe Rentals Rent Date Credit Card Number Expiration Date Name on Card Mary A Black Deposit Amount ($10 per canoe Returned Fee/Hour Damage Damage Total Date 300 Lose seat Hole in 300.00 Hull 1 inch Shaky 2.00 portage 90.00 yoke, 5 in Hole in Hull Total