Using the following narrative about an electric car tracking system by ABC Inc., design and document a logical data model using Erwin (or draw.io) and draw the entity relationship diagram (ERD). You should also make and document any reasonable assumptions where you feel the case is vague or ambiguous or missing any data necessary to meet the requirements. However, you cannot ignore or overrule the requirements that are explicitly stated. Show all cardinality, primary keys and foreign keys. Use verbs to clarify the relationships. Show only the attributes that are contained explicitly in the case.

The ABC Inc. has a car tracking system which requires a system to meet the following operations and requirements:

• Employees may use cars owned by ABC for officially sanctioned travel. The cars may be used by employees to travel to other locations on company business. The cars used for such travel are located in the ABC Car System (ABCCS).
• For all employees the information retained includes department code and name, employee id, name and internal phone ext.
• An employee may reserve a car for use. Required for a reservation is the expected departure date and return date, car type required, and destination. This employee will subsequently check out and return the car. These actual dates will also be recorded as well as the identification of the employee who releases the car and then subsequently, the employee who receives it on return. When a car is checked out its car identification number and odometer reading is recorded. When a car is returned, the odometer reading is again recorded. The employees department will then be internally billed at a mileage rate based on the car type. Each car type (e.g., Truck, Sedan, etc.) has a standard mileage rate.
• All routine car maintenance is performed by ABCCS. Each time a car requires maintenance, a maintenance log entry is completed and assigned an entry number. The log includes the car identification, a brief description of each type of maintenance activity required as there may be several and the log entry date. Subsequently the actual date the maintenance was completed is added as well as the name and identification of the mechanic releasing the car back into service. Only mechanics that have an inspection authorization may release a car.
• Each maintenance activity associated with a maintenance log may require multiple parts. The type and quantity of parts used will be recorded as well as the identification of the mechanic performing that particular maintenance activity. ABCCS maintains a parts inventory for parts such as oil, oil filters, air filters and belts of various types. Each part kept in inventory will have an ABCCS part number and a description. The parts inventory is checked daily to monitor parts usage and to reorder parts that reach the minimum quantity on hand level.