Task for the database access "Autosalon"
There is some firm that sells cars. The car acts as a commodity and as a product has certain characteristics. In addition, for each car there are technical data. The firm has its customers - car buyers, information about which stores for a certain time.
The firm´s activities can be described by the data grouped as follows:
- product (product code, country of manufacture, car make, model, color, availability in stock (yes, no, when will be), price);
- technical data (product code, body type, number of doors, number of seats, engine type, engine location, engine capacity);
- Clients (customer´s name, passport data (series, number), home address, telephone);
- purchase (product code, customer code, date, delivery (yes, no), type of payment (transfer or cash: credit or immediately)).
It is necessary to provide input, editing and viewing of data in a user-friendly form.
It is also planned to solve the following tasks:
- give information about the presence of cars of a certain brand and model;
- give out technical data of the given model;
- give information on all models sold by some brand, the value of which is entered as a parameter;
- Calculate the amount of sales of models of each brand and the total amount of sales;
- give out full or partial information about the clients of the firm;
- Issue lists of customers and cars by type of payment;
Possible setting and solving other problems.