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.

is a process that focuses on improving an individual's behavior and performance to resolve work issues or handle specific aspects of the job and may be short term. Coaching Mentoring Teaching Sponsoring Networking Question 38 1.25 In the culture, employees are encouraged to set difficult goals and strive to achieve them. Employee performance is closely monitored and often directly rewarded or punished. O clanQUESTION 15 the imperative style. The hardware implementation of almost all computers is imperative Nearly all computer hardware is designed to execute machine code, which is native to the computer and is written in Assignment statements, in imperative paradigm, perform an operation on information located in memory and store the results in memory for later use High-level imperative languages, in addition, permit the evaluation of complex expressions, which may consist of a combination of arithmetic operations and function evaluations, and the assignment of the resulting value to memory The earliest imperative languages were the machine languages of the onginal computers Many imperative programming languages (such as Fortran, BASIC, and C) are abstractions of Imperative Computer equivalent of Latin O Assembly Language Java O Beethoven Composition O Fortran QUESTION 16 The Abacus, works doing addition and subtraction arithmetic_The binary abacus is used to explain how computers manipulate numbers. The abacus shows how numbers, letters and signs can be stored in a binary system on a computer, or via ASCII. The device consists of a senes of beads on parallel wires arranged in three separate rows Select all true statements O the abacus is the first known calculator O by learning how to calculate with abacus, one can improve one's mental calculation which becomes faster and more accurate in doing large number calculations the abacus influenced the modern computer core memory the first abacus used beads and stonesQUESTION 17 A secondary offering of equity can cause which of the following it makes existing shareholders happy it dilutes EPS it increases EPS it has no effect on EPS QUESTION 18 The communication management aspect of a consulting engagement includes frequent client updates. True False QUESTION 19 The two primary sources of outside financing for an early stage company are equity and QUESTION 20 Check all of the potential exit strategies for a business Sell to a strategic buyer IPO Sell to a financial buyer O Liquidation QUESTION 21 The type of research that involves using existing information QUESTION 22 The point where the volume of sales revenue and expenses are equal is called the point Click Save and Submit to save and submit. Click Save All Answers to save all answers.QUESTION 20 HW 4 Question 20: Find the probability that none of the three cards are spades. QUESTION 21 HW 4 Question 21: Find the probability that at least one of the three cards is a spade