CREATE AN ERD, you can hand draw it if you want, THANKS IN ADVANCED!

Using the following narrative about a car tracking system by PG Inc., design and document a logical data model using Erwin (or draw.io). 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, prime keys and foreign keys. Use verbs to clarify your relationships. Show only the attributes that are contained explicitly in the case.

 

The PG Company has a car tracking system which requires a system to meet the following operations:

• Employees may use cars owned by PG 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 PG Car Centre (PCC).
• 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 the return the car. These actual dates will also be recorded as well as the identification of the Centre employee who releases the car and then subsequently, the Center 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 employee’s department will then be internally billed at a mileage rate based on the car type. Each car type (e.g. SUV, Truck, Sedan, etc.) has a standard mileage rate.
• All routine car maintenance is performed by PCC. 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. PCC 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 a PCC 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.