Database Avtosalon.mdb

In the process of analyzing the requirements for the information system of a car dealership, the need to develop tables with the following information fields was determined:
– “Clients” – client code; FULL NAME; telephone; e-mail;
– “Payment method” – payment method code; the name of the payment method;
– “Car brand” – code of the car brand; car model;
– “Fuel supply system” – fuel supply system code; fuel supply system;
– “Agreement” – code; the date; employee code; car code; Client code; payment method code; execution status;
– “Positions” – position code; Job title;
- "Test drive" - ​​code; the date; time; car code; execution status; note;
– “Suppliers” – supplier code; Supplier name; Contact Information; note;
– “Engine type” – engine type code; engine´s type;
– “Employees” – employee code; FULL NAME; position code; Date of Birth; employment date; the salary; telephone; e-mail;
– “Cars” – vehicle code; brand; supplier code; Colour; length; width; height; number of seats; maximum speed; engine type code; engine displacement; fuel supply system code; fuel consumption; price; in stock.