The ACME Company has a Vehicle Tracking system which requires a system to meet the following operations: ● Employees may use vehicles owned by ACME for officially sanctioned travel. The
vehicles may be used by employees to travel to other locations on company business. The vehicles used for such travel are located in the ACME Vehicle Centre (AVC).
● For all employees the information retained includes department code and name, employee id, name and internal phone ext.

● An employee may reserve a vehicle for use. Required for a reservation is the expected departure date and return date, vehicle type required, and destination. This employee will subsequently check out and the return the vehicle. These actual dates will also be recorded as well as the identification of the Centre employee who releases the vehicle and then subsequently, the Center employee who receives it on return. When a vehicle is checked out its vehicle identification number and odometer reading is recorded. When a vehicle is returned the odometer, reading is again recorded. The employee’s department will then be internally billed at a mileage rate based on the vehicle type. Each vehicle type (e. g., sedan, minivan, minibus, etc.) has a standard mileage rate.

● All routine vehicle maintenance is performed by AVC. Each time a vehicle requires
maintenance a maintenance log entry is completed and assigned an entry number. The log includes the vehicle 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 vehicle back into service. Only mechanics that have an inspection
authorization may release a vehicle.

● 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. AVC 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 AVC 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.

Using the following narrative about the “ACME Vehicle Tracking”, design and document a logical data model using Erwin (or draw. io).

You should also make and document anyreasonable 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, prime keys and foreign keys. Use verbs to clarify your relationships. Show only the attributes that are contained explicitly in the case.