Task for the database in access 2003 "Car Rental"
Description of the subject area
You are the head of a commercial service in a car rental company. Your task is to monitor the financial performance of the rental office. In your fleet includes a number of cars of different brands, values and types. Each car has its own rental price. Customers are turning to the rental point. All clients undergo mandatory registration, in which they collect standard information (name, surname, patronymic, address, telephone number). Each client can contact the rental office several times. All customer requests are recorded, with each transaction remembering the issue date and the expected date of return.
Cars (Vehicle code, Brand, Price, Rental price, Type).
Clients (Customer code, Last name, First name, Middle name, Address, Telephone).
Issued vehicles (Vehicle code, Customer code, Issue date, Return date).
The development of the formulation of the problem
Now the situation has changed. A simple analysis showed that the cost of renting a car should depend not only on the car itself, but also on the period of its hire, as well as on the year of manufacture. Also need to introduce a system of penalties for the return of the car in an inappropriate form and a system of discounts for regular customers. Add changes to the table structure that take into account these facts, and modify existing queries. Add new queries.
You are the head of the commercial service in the firm engaged in renting cars. Your task is to monitor the financial performance of the rental office.
In your fleet includes a number of cars of different brands, values and types. Each car has its own price. The cost of car rental depends not only on the car itself, but on the year of production. The database contains data on cars: State number, Mark, Model, Year of manufacture, Vehicle price, Daily rental price.
Customers are turning to the rental point. All clients undergo obligatory registration, in which standard information is collected about them (Surname, Name, Patronymic, Address, Telephone). Each client can turn to the rental office several times.
In the vehicle fleet a system of discounts (Name of discount, Percent of rental amount) for regular customers and a system of penalties (Naimenovanie fine, Amount of penalty) for the return of the car in an unsuccessful form.
All customer requests are recorded in the database, with each issue of the vehicle memorized: Date of issue, Number of days, Expected return date, Rental amount [Rental amount = Rental fee per day * Number of days], Discount amount, Amount of penalty, Final amount of money. In one issue, one car, one customer, one discount and maybe several types of fines are involved.
Subject areas for independent work
Stages of individual self-employment:
1. Create a table structure by means of MS Access;
2. Create a data schema;
3. Develop screen forms for entering and viewing information;
4. Fill in the tables (10-15 records);
5. Develop and execute various types of queries to the database:
• for sample;
• using logical operations in the selection condition;
• with the parameter;
• cross request;
• for updating;
• to add;
• to delete;
• with calculated fields (if this is possible for your predefined area).
6. Develop various types of reports for printing data;
7. Organize work through a button form or headband. The database should look like a complete software product.
18. Car Rental
Description of the subject area
You are the head of a commercial service in a car rental company. Your task is to monitor the financial performance of the rental office. The fleet includes ...