A small used car lot would like to develop a database to track their vehicle inventory. You have been asked to create an E$-$R Diagram to begin

the database modelling process. The Entities required should include, but are not limited to:

Vehicles $($this entity holds information about a specific vehicle, such as its VIN number, mileage, date of manufacture$)$

Manufacturers $($data examples: Ford, GM$,$ Acura, Honda, etc$)$

Models $($data examples: Accord, Camry, Focus, etc$)$

Options $($this entity holds information about optional features such as air conditioning, moon roof, heated seats, alloy wheels$)$

Some key relationships are as follows:

One Manufacturer can manufacture zero, one or many Models

One Model can have zero, one or many Vehicles

One Vehicle can have zero, one or many Vehicle Optons

Complete an E$-$R Diagram for this model making sure you clearly identify each entity and the relationships between each entity including cardinality.

Your final diagram should resolve any associative entities you identify $($i$.$e$.$ the final diagram shall not contain any many$-$to$-$many relationships$).$