You are tasked with developing an ER diagram for a car rental company. Consider the

following details: $($draw an ER diagram$)$

Entities and Attributes:

Vehicle

ID

Type

Brand

Color

Year

Plates Number: one car can have one or more plate numbers

Customer

ID

Phone Number

Email: one customer can have multiple emails

Age

Rental History: Rental Date, Price, Accident Occurrence

Rental Branch

Branch ID

City

Capacity

Insurance

Insurance ID

Start Date

End Date

Coverages

Vehicle Review Report

Report ID

Accident Counts

Relationships:

A customer can rent zero or more vehicles, and one vehicle can be rented by

multiple customers.

A customer can buy zero or more insurances while renting a vehicle, and a vehicle

can be covered by multiple insurances while being rented.

A customer can rent one or more vehicle. For each rental, a customer can buy zero

or more insurances.

A vehicle can belong to only one rental branch, while a rental branch can have

many vehicles.

A vehicle can have zero or more review reports, while a review report can only

belong to one vehicle.