[Solved]Tamuc Automotive Group Company Tamuc Automotive Group Car Dealership Sells Used Cars Honda Q37240630

TAMUC Automotive Group

The Company

TAMUC Automotive Group is a car dealership that sells used carssuch as Honda, GM, Ford. Recently, the company want to builddatabase system to keep track with its inventory and salesperformance

. Business Requirements

The new database system consists of three separate systems -inventory, customer management, and sales.

Inventory

TAMUC Automotive Group wants to check the current inventorylevel of each used car. Each vehicle has a VIN number that storedin the system to keep track with the vehicle. Each vehicletypically will be shipped from other manufacturers when the numberof vehicle in inventory drops to a certain number. Generalinformation of each car such as make, model, and mileage are storedin the system.

Customer Management

When a customer wants to see the vehicle, the salesperson willgive him a key to test the car. For each car test when the customerhas problems or questions, the salesperson wants to write down in alog. This log is very important for TAMUC Group because theyhaven’t been recorded anywhere in the computerized system before.The salesperson wants to keep track with the progress of allcustomers that they interact with. Particularly, they want to knowtheir customer’s general information, their buying process (i.e.,negotiation price, number of time visits etc.), and whether thecustomer purchases a car

Sales

Finally, the most important part of the system is keeping trackof sales and payments on those sales. TAMUC want to know thecustomer who purchased the car, the VIN number of the car, and thesalesperson who sold the car.

For each transaction, information about the sale such as downpayment, credit score, trade-in values are also entered in thesystem. If the customer wants to trade in an older car, the systemshould allow to record vehicle information including the year,make, model, mileage, and general condition.

As a group, your team will need to provide ERD, codes to createtables and sample records, sample SQL queries, and sample Tableauto show case your business analytic solutions. Each team willrequire to provide a written report, and a presentation in the endof the semester. Please check syllabus schedule for moredetail.

Expert Answer

---

Answer to TAMUC Automotive Group The Company TAMUC Automotive Group is a car dealership that sells used cars such as Honda, GM, Fo… . . .