Car retail

Try me

Problem definition

You need to design a database for Daniel Larusso´s car dealership. Larusso´s company is divided into departments. Larusso would like to store the Departments’ name, and identifier. Larusso also wants to store the following information about his employees: First name and last name, phone number, salary, and hiring date. You also want to know in which department they work and which is their manager. Each employee has an identifier. Larusso also wants to store the following information about the company´s customers: First name and last name, phone number, email, and preferred contact method. For each car the dealership sells, you are instructed to store the model, the status of the car (either if the car is ready to be delivered, in the workshop (working), or the company is waiting for the arrival of the car. You also need to keep track of which customer bought it, and which employee made the sell.