This is what I have to work with. Essentially I need to redesign the UML diagram and make it better and more optimized. Any direction or suggestions on how I can do that is greatly appreciated!

You are tasked with building a database system for a brick-and-mortar auto dealership. The software maintains and updates inventory, sales, financing, customer relationships, and employees/HR.

A salesperson would obtain contact information for each customer who intends on purchasing a car. In addition to browsing the cars in the lot, a salesperson (on the customer's behalf) may search the computer for any car in the inventory by various features: engine type, equipments, colors, etc.

Upon each purchase, a salesperson will write up a sales contract that includes information on the vehicle being purchased, purchase price, trade-in vehicle if any, financing details, etc. When a customer chooses to take a loan to finance the purchase, he or she will be asked to provide additional information, such as, SSN, income, etc. as required by your Java review program.

Added requirement: After conversation with some students, it appears that a minor requirement is missing for the business model to be logical. That is, the dealership has a service department for auto maintenance and repairs, but there's no way for the customer to obtain such service. To remedy this deficiency and to minimize redesigning, let's assume that this portion of business is done manually for the time being and will be automated in the next version of the software (beyond the scope of this class).

Your software also provides basic support for human resource management. There are 3 departments: sales, service and support. Each department has its own employees and managers. Everyone is on salary, except each salesperson earns a commission at his/her own assigned rate. The software needs to maintain past assignments for each manager. Lastly, we need to know the credentials/certification of each technician.

Each employee receives health & dental benefits for him/herself. Benefits are available to the spouse and children for a monthly premium: $200/month for spouse only & $350/mo for spouse and children. (Note: Some employees may choose to forgo dependent benefits.) All employees also receive 5 days of non-accruable paid vacation, after being employed for 1 year. (The software does not handle employee scheduling.)

The UML class model shown is a crude design from your customer which serves as a starting point. It needs a great deal of refinement to produce a proper design. That is, your final design should be drastically different from this UML model.

In this phase, your tasks are to fully understand the needs of your customer (me). Then, based on these requirements, develop a proper database design: UML model and relational schema diagram, including the data dictionary. You would need to document your design rationale and fully explain your resulting UML design and schema. That is, you'd want to justify why this is the better/best design for your software.

Looking ahead: in the next phase, you will be fully realizing your design using MySQL technology. Do this phase well would make your life simpler in the next phase

Class: Customer lastname middlename SSN address city zip (9 digit) email addr phone monthly pavment date_last_payment Class: Customer lastname middlename SSN address city zip (9 digit) email addr phone monthly pavment date_last_payment