Using Microsoft Visio or Lucid Chart, draw a CONCEPTUAL E$-$R diagram using Crow's Foot Notation to track the information in the car rental contract below. $($Refer to Chapter $5$ of the text, class lectures, $|$and Canvas E$-$R diagramming videos for a review of conceptual E$-$R diagramming.$)$

You will be graded on your diagram of the entities, attributes and re lationships for the car rental report and business rules below.

WXURY RENTAL CAR CONTRACT

Rental Information:

Pickup Date: $\frac{4}{1}\frac{?}{2023}$ Return Date: $\frac{4}{6}\frac{?}{2023}$ Cost: $$5,500$ Location: RDU

Customer Information:

First Name: Joseph Last Name: Jackson Cust#: A$007$ Email:

joejackson@yahoo.com

Address: $100$ Main St City: Jacksonville ST: NC ZIP: $28547$ Phone: $252-333-4444$

Vehicle Information:

VIN: WPCAD$2$A$9$XKS$140582$ Make: Porsche Model: $911$ Turbo S Year. $2022$

Class: Luxury Mileage: $11,412$

Maintenance Information:

Date of service: $\frac{3}{20}\frac{?}{2023}$

Procedure: Oil change

Mileage during service: $11,390$

Manufacturer Information:

Name: Porsche

Country: Germany

Sales Rep: Franz Beckenbauer

Phone: $497119110$

BUSINESS RULES:

A car is manufactured by exactly one manufacturer.

A manufacturer provides zero, one or many cars to the rental company.

A car may not have been rented yet or it may have been rented to many customers.

A customer must rent a car at least once to be in the database and may have rented cars many times. Besides knowing who is renting which car, a rental transaction also tracks the rental date, the return date and the total cost of the rental.

COPy your CON CEPTU AL drawing here.