Using Mierosoft Visio or Lueid Chart, draw a CONGEPTUAL E$-$R diagram using Crow's Foot Notation to track the information in the car rental contract below. $($Refer to Chapter $5$ of the tert, clase lectures, and Carvas E$-$R diagramming videos for a review of conceptual E$-$R diagramming.$)$

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

LUXURY RENTAL CAR CONTRACT

Rental information:

Pickup Date: $4/1/2023$ Retum Date: $4/6/2023$ Cost:$$5,500$ Location: RDU

Customer information:

First Name: Joseph last Name: Jackson Cust#:A$007$ Emali:joejacksoneyahoo.com Address: $100$ Mainst City: Jacksonville ST:NC ZIP: $28547$ Phone: $252-333-4444$

Vehide Information:

YIN: WPOAD$2$A$9$XKS$140582$ Make: Porsche Model: $911$ Turbos Year: $2022$

Class: uxury Mileage: $11,412$

Maintenance information:

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

Procedure: Oil change

Mleage during service: $11,390$

Manu facturer Information:

Name: Porsche

Country. Germany

Sales Rep: Franz Beckenbauer

Phone: $497119110$

BUSINES RULES:

A caris manufactured by exactly one manu facturer.

A man ufacturer provides zero, one or many cars to the ren tal company.

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

A custo mer 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 retum date and the tota cost of the renta.

COPY your CONCEPTUAL drawing here.

Using Microsoft Visio or busidChart, COPY AND THEN TRANSFORM YOUR COPY into a database diagram using Crow's Foot Notation.

IMPORATANT NOTE: To receive full credit for Part $2$ & $3,$ you need two diagrams: $1)$ the conceptual E$-$R diagram in Part $2$ and $2)$ the modified diagram that has been transformed into a database diagram. $($Refer to Chapter $6$ of the text and class lectures for an explanation of the differences between conceptual E$-$R diagramming and a logical database diagram.$)$