A database is, first of all, a repository of data objects, i.e. a set of possible concepts or events described by the database, with the ability to search for these objects by features. A database can be considered not only tables that index files with knowledge of different formats, but also these files themselves, because they are untyped knowledge repositories in such a database. Databases can be used as an auxiliary tool that allows you to implement some useful function.

Share work on social networks

If this work does not suit you, there is a list of similar works at the bottom of the page. You can also use the search button

Ministry of Education and Science Russian Federation

federal state budgetary educational institution

higher professional education

Ryazan State University named after S.A. Yesenin

Faculty of Physics and Mathematics

Specialty Mathematical support and administration
information systems

Department of Informatics and Computer Science

Coursework by discipline

"Databases and DBMS"
on the topic of:

"Database Design

“Car Service Station”

Completed by a 3rd year student of FMF

Makarov Dmitry

Scientific adviser:

Bogdanova N atalya Vladimirovna

Ryazan 2015

Introduction

Due to the increase in the volume of information and the need to transform it, there is a growing need to automate existing data processing processes. Such processes include analysis, systematization, display and editing of information.

Modern technologies development application programs make building databases fast and high quality. A qualified user using Microsoft Access today can create in one evening on personal computer something that on early computers required months of work. In addition, now it has become much easier to find errors, eliminate them and change the project directly during the database creation process.

A database is, first of all, a repository of data objects, i.e. a set of possible concepts or events described by the database, with the ability to search for these objects by features. A database can be considered not only tables that index files with knowledge of different formats, but also these files themselves, because they are untyped knowledge repositories in such a database. Databases can be used as an auxiliary tool that allows you to implement some useful function.

The projected database "Car Service Station" allows you to systematize a quick search for the necessary information in this subject area.

The database should store information about cars: manufacturer, model, state. number, year of manufacture, country of origin, owner's passport number, gas equipment; information about the owners: full name, address, telephone number, as well as passport number; information about employees: Full name of the Employee, identification number of the employee; information about the work: work code, description, date of completion, duration, state. room.

aim this course workis the design of the database "Car Service Station".

The most important tasks that we face in the process of doing the work are as follows:

·Studying the features of the subject area "Car service station";

· DB schema development;

· Implementation of the developed scheme in a specific DBMS (MS Access);

· Creation of forms for data entry, reports, queries.

The creation of any database begins with the choice of the database structure. In our case, it is more convenient to use five tables with data. Next, we will make several requests for selection by various parameters, as well as reports for them. For the convenience of working with data, we will create several forms and transition buttons between them.

The course work consists of an introduction, two chapters, a conclusion, a list of references.

CHAPTER 1 Database Design

In the database " Car service station" should have the following attributes:

• Manufacturer
• Model
• Year of issue
• Gas equipment
• Manufacturer country
• State. car number
• Name of the owner
• Owner's passport number
• Owner's address
• Owner phone
• Name of the Employee
• Work code
• Work description
• Date of completion of the work
• Working time

Let's single out 4 entities: "Auto", "Owners", "Employees", "Works".

Entity "Auto" has the following attributes:

Manufacturer

Model

State. room

Manufacturer country

Gas equipment

Year of issue

Auto ” can have duplicate values, then we add the attribute individual movie number, which should not have duplicate values.

Entity "Owners" has the following attributes:

Name of the owner

Owner's address

Owner phone

Owner's passport number

Since all initial attributes of the “Directors” entity can have duplicate values, we will add the attribute individual director number, which should not have duplicate values.

Essence "Employees" has the following attributes:

Full name of the employee

Since all the initial attributes of the entity " Employees » can have duplicate values, then we add the attribute individual employee number, which should not have duplicate values.

Essence of "Work" has the following attributes:

Work description

Date of completion of the work

Working time

Since all the initial attributes of the entity " Works » can have duplicate values, then we will add the job code attribute, which should not have duplicate values.

Accept agreements.

Agreement 1:

Each owner can have several cars, therefore the degree of connection for the "Auto" entity is equal to N . In turn, any car belongs to one owner, therefore, the degree of connection for the “Owners” entity is 1.

Agreement 2:

Each car necessarily belongs to the owner, therefore, the membership class for the "Auto" entity is mandatory. Each owner necessarily owns at least one car, therefore, the ownership class for the "Owners" entity is mandatory.

Fig.1.1 ER -diagram of the connection between the entities Auto and Owners

Thus, we have a one-to-many binary relationship with a mandatory membership class for both entities, for its implementation it is necessary to create two relationships (one for each entity), and in the relation for the multi-connected entity "Auto" it is necessary to add a primary key to establish a relationship singly connected entity "Owners" passport number.

Agreement 3:

Only one job can be performed on one car, therefore, the degree of connection for the “Auto” entity is 1. In turn, each work can be performed on several cars, therefore, the degree of connection for the “Works” entity is N.

Agreement 4:

The car is being worked on. Work is being done on cars.

Fig.1.2 ER -diagram of connection between Auto and Work entities

Thus, we have a one-to-many binary relationship with a mandatory membership class for both entities, for its implementation it is necessary to create two relationships (one for each entity), and in relation to the multi-connected entity "Works" it is necessary to add a primary key to establish the relationship singly connected entity "Auto" state. room.

Agreement 5:

Any worker can perform any work, therefore, the degree of connection for the “Works” entity is equal to N . In turn, any work can be performed by any employee, therefore, the degree of connection for the “Employees” entity is equal to N.

Agreement 6:

The workers are doing the work. Work is done by employees.

Fig.1.3 ER -diagram of the relationship between the entities Workers and Works

Thus, there is a many-to-many binary relationship, for its implementation it is necessary to create three relationships: one for each entity with the corresponding attributes and primary keys, and 3 for the relationship; as attributes - the primary keys of both entities; primary key is composite.

Communication table (job code, individual worker number)

Functional dependency of the "Auto" entity

Fig.1.4 Functional dependency of the "Auto" entity

State. number  Manufacturer

State. No.  Model

State. number  Year of manufacture

State. number  Manufacturer country

State. number  Gas

State. number  Passport number

State. number - determinant, state. number is a possible key, so the relation "Auto" is in BCNF.

Functional dependency of the "Owners" entity

Fig. 1.5 Functional dependence of the "Owners" entity

Passport number  Full name

Passport number  Address

Passport number  Phone

The passport number is a determinant, the passport number is a possible key, which means that the “Owners” relation is in the BCNF.

Functional dependency of the “Work” entity

Fig. 1.6 Functional dependency of the “Work” entity

Job code  Description

Job code  Due date

Work code  Duration

Work code  State. room

Job code - determinant; The work code is a possible key, which means that the Work relation is in BCNF.

Functional dependency of the “Employees” entity

Fig. 1.7 Functional dependence of the "Owners" entity

An identification number Full name

Identification number is a determinant, Identification number is a possible key, which means that the “Employees” relation is in BCNF.

Consider the implementation of the database by means MS ACCESS.

"Auto" (manufacturer, model, state number, year of manufacture, gas equipment, country of origin, owner's passport number)

AUTO”

Fig.1.8 Table constructor “ AUTO".

Fig.1.9 Table of the entity "Auto"

"Owners" (name, address, phone number, passport number).

The relation in the relational database corresponds to the table “ vladelcy”

Fig.1.10 Table constructor “ VLADELCY".

Fig. 1.11 Table of the "Owners" entity

"Works" (Work code, description of work, date of completion, state number).

The relation in the relational database corresponds to the table “ WORKTU".

Fig.1.12 Table constructor"RABOTU" .

Fig. 1.13 Table of the entity "Works"

Link table (Job code, worker identification number).

A relation in a relational database corresponds to a table"DLYSVYZI"

Fig.1.14 Table constructor “ DLYSVYZI.

Fig.1.15 Table c ties

"Workers" (full name, employee identification number).

The relation in the relational database corresponds to the table “ WORKERS".

Fig.1.16 Table constructor"RABOTNIKI" .

Fig.1.17 Table of the “Employees” entity

Data Schema

Fig.1.18 Data schema

CHAPTER 2. Description of the database and control system

2.1 Requests

1. Lexus car models

SELECT MODEL FROM AUTO

WHERE PROIZV="Lexus";

1. Car manufacturers and all models

SELECT PROIZV, MODEL

FROM AUTO ;

1. Manufacturer, model and state. number of cars owned by Kuzin Valery Valentinovich

SELECT AVTO.PROIZV, AVTO.MODEL, AVTO.GOSNOMER

FROM VLADELCY INNER JOIN AVTO ON VLADELCY.PASPORTNOMER = AVTO.PASPORTNOMER

WHERE VLADELS . FIO =" Kuzin Valery Valentinovich";

1. Manufacturer, model, year of manufacture and state number of a car manufactured before 2005 sorted by date of issue

SELECT PROIZV, MODEL, GOSNOMER, GODVIPUSKA

FROM AUTO

WHERE GODVIPUSKA< 2005 order by GODVIPUSKA;

1. Date of completion and description of the work performed by Smenov Eduard Viktorovich.

SELECT RABOTU.DATAV, RABOTU.OPISANIE

FROM RABOTU INNER JOIN (RABOTNIKI INNER JOIN DLYSVYZI ON RABOTNIKI.IDR = DLYSVYZI.IDR) ON RABOTU.KODRABOTU = DLYSVYZI.KODRABOTU

WHERE WORKERS. FIO ="Smenov Eduard Viktorovich";

1. List of car brands, state. numbers and the work that was done on them

SELECT AVTO.PROIZV, AVTO.GOSNOMER, RABOTU.OPISANIE

FROM AVTO INNER JOIN RABOTU ON AVTO.GOSNOMER = RABOTU. GOSNOMERAVTO;

1. Manufacturers, year of manufacture and models of the newest cars (by year of manufacture)

SELECT PROIZV, MODEL

FROM AUTO

WHERE GODVIPUSKA =(SELECT MAX(GODVIPUSKA) AS MAXGV FROM AVTO);

1. Display all information about the 3 longest running jobs

SELECT TOP 3 *

FROM WORK

ORDER BY PRODOLG DESC;

1. Names of owners, manufacturers and state. car numbers belonging to them

SELECT VLADELCY.FIO, AVTO.PROIZV, AVTO.GOSNOMER

FROM VLADELCY INNER JOIN AVTO ON VLADELCY.PASPORTNOMER = AVTO.PASPORTNOMER;

1. All information about all employees

SELECT*

FROM WORKERS;

1. Name, phone number and address of car owners from Ryazan

SELECT FIO, TELEFON,ADRES

FROM VLADELS

WHERE ADRES LIKE "*Ryazan*";

1. List of car manufacturing countries

SELECT DISTINCT STRANA

FROM AUTO;

1. Name of the owner who has the largest number of cars, and this number

SELECT Temp.FIO, Temp.MaxAVTO

FROM . AS Temp INNER JOIN . AS Temp0 ON Temp.MaxAVTO=Temp0.Maxim;

1. The number of hours spent on work on certain days

TRANSFORM SUM(PRODOLG)

SELECT KODRABOTU

FROM WORK

GROUP BY KODRABOTU

PIVOT DATAV;

1. Description and duration of the shortest-term job

SELECT DESCRIPTION, PRODOLG

FROM WORK

WHERE PRODOLG =(SELECT MIN(PRODOLG) FROM RABOTU);

1. Display all car manufacturers

SELECT PROIZV

FROM AUTO ;

1. Manufacturer and year of manufacture of cars with gas equipment

SELECT PROIZV, GODVIPUSKA

FROM AUTO

WHERE GAZ;

1. Add information about a new employee in a car service.

INSERT INTO WORKERS

VALUES ("Jason Statham", 7);

Before adding:

Fig.2.18 Table “ WORKERS ” before adding new record

Inquiry:

After adding:

Fig.2.20 Table “ WORKERS ” after adding a new entry

1. Change the address of Loginov Egor Yurievich

UPDATE VLADELCY SET ADRES = "Ryazan, Moscow highway, 15"

WHERE PASPORTNOMER ="34 88 336882";

Before change:

Fig.2.21 Table “ VLADELCY ” before changing the entry

Inquiry:

After change:

Fig.2.24 Table “ VLADELCY ” after changing the entry

1. Delete the entry about the car with license plate number e244vv 23.

DELETE*

FROM AUTO

WHERE GOSNOMER = “e 244 cc 23”;

Before removal:

Fig.2.25 Table “ AUTO ” before deleting the entry

Inquiry:

After removal:

Fig.2.28 Table “ AUTO ” after deleting an entry

2.2. Forms

General form database "Car service station"

The form contains buttons for opening subforms (Auto, Owners, Jobs, Employees), buttons for executing requests, and a button for closing the main form.

In "Form" mode

Fig. 2.29 The general form of the database "Car service station"

In design mode

Fig. 2.30 The general form of the database "Car service station" in the design mode

"Auto" form

Fig.2.31 "Auto" form

In design mode

Fig.2.32 "Actors" form in design mode

Prompts for combo boxes

Prompts for combo boxes

Prompts for combo boxes

Form "Owners"

Fig.2.36 "Owners" form

In design mode

Fig.2.37 "Owners" form in design mode

Form "Work"

Fig.2.38 "Jobs" form

In design mode

Fig.2.39 Form "Works" in design mode

Prompts for combo boxes

Contact form "Work-Employees"

Fig. 2.41 Communication form "Work-Employees"

In design mode

Fig.2.42 Form of communication "Work-Employees" in the design mode

Prompts for combo boxes

Conclusion

In this project, a relational database "Car Service Station" was created, which contains five tables with data: a table for cars, a table for owners, a table for jobs, a table for workers, and a table for linking jobs and workers.

Main stages of development:

1. Determining the purpose of creating a database
2. Determining the required fields in the database
3. Specifying the tables that the database should contain.
4. Determining which tables the fields belong to.
5. Definition of primary keys.
6. Defining relationships between tables.
7. Improvement of the database structure.
8. Entering data and creating other database objects (such as forms and queries).

The database provides efficient work, creates ease of use. To obtain information about cars, owners, employees and jobs, the user performs a minimum of actions, which reduces the time of working with the database.

Even a novice programmer can figure out the operation of this database, since it is made as convenient and understandable as possible.

List of used literature

1. Bekarevich Yu., Pushkina N. Microsoft Access for 21 lessons. - M.: Olma-Press, 2006. - 544 p.

2. Laurie Ulrich Fuller, Ken Cook, John Kaufeld. Microsoft office Access 2007 for dummies. - M.: Williams, 2007. - 384 p.

3. Mikheeva V., Kharitonova I. Microsoft Access 2003. - M.: Nova, 2005. - 1072 p.

4. Homonenko A.D., Tsygankov V.M., Maltsev M.G. Database. Textbook for universities / ed. prof. HELL. Homonenko // St. Petersburg: KORONAprint, 2000. - 416 p.

5. Homonenko A., Gridin V. V. Microsoft Access. Fast start. - M., 2008. - 304 p.

6. Korneev V.V. and other databases. Intellectual processing of information M.: Knowledge, 2000. - 352 p.

Auto

N : 1

Owners

Auto

1:N

Works

Employees

N : N

Works

State. room

Manufacturer

Model

Year of issue

Manufacturer country

Gas

Passport ID

Passport ID

Full name

The address

Telephone

The code

work

Description

date

fulfillment

Duration

State.

room

An identification number

Full name

Other related works that may interest you.vshm>
18542.		Car service station	786.59KB
	The determining factor for the development of infrastructure is the car park and its growth trend. These are absolutely irreparable losses for us for the future of the country. To solve this problem, special attention should be paid to cars owned by individuals, since the owner is responsible for the technical condition of the vehicle. In second place are the former state service stations, in the third place are newly created independent private service stations, in the fourth place are motor transport enterprises providing services for technical...
13718.		Organization of maintenance of Mitsubishi vehicles in the conditions of Transtechservice LLC	363.83KB
	aim thesis is the organization of technical maintenance of Mitsubishi vehicles in the conditions of Transtekhservis LLC. To achieve this goal, the following tasks are defined: Mitsubishi has gained and maintains a reputation as a car manufacturer High Quality; Expansion of the model range of the Mitsubishi car; consider specifications mitsubishi cars model range; Mitsubishi service card: short description regulations; execution sequence...
4523.		Organization of a roadside service station for current car repairs	369.01KB
	The features and advantages of road transport, which predetermine a fairly high pace of development, are associated with the mobility and flexibility of the delivery of goods and passengers "door to door", "just in time" and compliance with the schedule if necessary.
17752.		Organization of the motor section at the car service station "KRYMDIZELSERVICE"	649.78KB
	V further development and intensification of the work of motor transport, the key problem has become more full use production potential of enterprises and identifying reserves to improve production efficiency. As a rule, these carriers do not have their own base for proper maintenance and repair of vehicles. This is due to the fact that car owners either do not have or have to a limited extent material means and labor skills to maintain and repair their car. The fast pace of development...
4622.		Designing a diagnostic site for branded maintenance of passenger cars of YUGU	2.74MB
	Khanty-Mansi Autonomous Okrug - Yugra is one of the most dynamically developing regions of the Russian Federation. Our district is the main oil and gas region of Russia and one of the largest oil producing regions in the world. In Russia, Khanty-Mansi Autonomous Okrug-Yugra is the leader in a number of key economic indicators:
4606.		Design of the aggregate site for branded maintenance of cars of YUGU	1.86MB
	Check the condition of the platform cab, rear-view mirrors, sun visors, license plate plumage, door mechanisms, locks, sides of the platform, hood, trunk lid of the towing support-assisted device Check the operation of the windshield wiper and washers windshield and headlight operation of the heating system and heated windows in the cold season of the ventilation system. Engine including lubrication cooling systems Check by inspection the tightness of the lubrication systems of the power supply and cooling of the engine, including ...
20665.		Design and implementation of a pharmacy database	2.55MB
	Novokuznetsk assignment for term paper It is necessary to design a database that includes information presented as a group of attributes: Pharmacy Drug name; annotation; storage; receipt date; coming; balance at the end of the month; company manufacturer; vendor, etc. The task is to: Create a database. Organize permanent links between tables to ensure the integrity of your database.
20182.		College Daytime Database Design	2.59MB
	Designing a database for a full-time college Completed by: student gr. In the course work, the task is to develop a database project for the accumulation of the necessary information in the organization to create a database to fill. The database must be designed with queries in mind various types on receiving information. When designing a database, the possibility of issuing a paper report should be taken into account.
20025.		Designing a database for the insurance company JSC "Sogaz-Med"	448.12KB
	Insurance companies are financial intermediaries that specialize in providing insurance services. Their activity consists in the formation, on the basis of agreements with legal and individuals(through the sale of insurance policies) special funds from which payments are made to policyholders Money in the stipulated amounts in the event of the occurrence of certain events (insured events).
10007.		Designing the database "Catalog of car parts"	182.36KB
	Initially, local arrays (or files) were used to accumulate and store information on a computer, while for each of the solved functional tasks created own files source and result information. This led to significant duplication of data, complicated their updating, and made it difficult to solve interrelated problematic tasks.

Automation of the technology for generating documents on graduation from the university within the framework of the automated control system of MIIT

Database "Car Service"

Table relationships: The custumers table is linked to the masters table with a 1:N relationship on the vin_number field The custumers table is linked to the calculation table with a 1:1 relationship on the field...

Database "Students"

The program begins with connecting the libraries necessary for certain functions to work. #include - to work with files, structures and functions. #include - for the strcmp() function. #include - for the screen cleaning function. ...

Traffic police database

A table is in first normal form if and only if none of its rows contains more than one value in any of its fields and none of its key fields are empty. The relation is in second normal form...

Database on the accounting of metal products on the platform SQL Server

Design process automated system is to build a model written in graphical notation. At the same time, the general principles structural design: top-down design, hierarchical model building...

Organization of the implementation of the information system LLC "MensFormat"

Designing a data processing unit in the structural basis of the K1804BC2 series

The control unit (CU) is a combinational circuit with seven inputs. It converts external control signals and an internal signal from the FPN into a set of control signals for microcircuit blocks ...

Development of automated information systems for recording calculations for killing oil wells

MySQL database manager is used to create a database. Since we live in Russia, it was decided to choose cp_1251 encoding. In order to be able to use foreign keys, the InnoDB engine will be used ...

Development of the information and reference system "Personnel Department of the Sharkovshchinsky Regional Public Organization"

The Department of Education, Sports and Tourism of the Sharkovshchina District Executive Committee is located in the urban village of Sharkovshchina, st. Komsomolskaya, 15. Department of Education...

Development software product"Plant personnel department"

Structural scheme- a diagram reflecting the composition and interaction in managing the parts of the product being developed. In object decomposition, these parts are objects (figure 6.1). Figure 6...

Development of a system for accounting and personnel movement at the enterprise

Before starting to use the program, it is necessary to carry out the data initialization process, which can be divided into several stages: 1. Filling in information about the organization...

Development of a system for recording student tuition fees

The DBMS Microsoft SQL Server 2005 Express Edition will be used to create the database. We perform the following actions: The implementation of this stage will produce when help from Microsoft Visual Studio 2005. When you click on the Tools button in the menu bar, a list of commands will drop down...

Creation of a site on the example of the registry office of the Elovsky district

There are several basic site structures: - linear - web pages are arranged in a certain order. The transition from one web page to another is strictly defined. Such a structure is justified, for example, when teaching...

Electronic class magazine

In the database designed according to the technical specifications, there were 3 tables: Questionnaire, Progress, Subject ...

Database Access Car service is designed to automate the work of a car repair company. The tables in the database are filled with data, simple and cross queries, as well as adding, updating and deleting queries are performed. Forms for working with data and reports that can be printed are also made.
Access Database Car Dealer contains 6 tables, 9 queries, 7 forms + main button form, 5 reports. This base Access data is optimally suited for further optimization and refinement for your own needs.

ATTENTION! There is an explanatory note (21 pages)

Database Access Car Service allows you to add and edit information about ongoing repairs, car service customers, spare parts, storage warehouses and repaired cars. Also, the Auto Service database provides requests for the withdrawal of a certain type of spare parts, the calculation of the total cost of repairs, including the cost of work and the cost of spare parts, the total amount for each client, etc. Update request, delete request, add request, create table, cross request are implemented.

Target practical tasks– acquisition of skills in the analysis of the subject area, database design, its physical implementation in the Access DBMS.
The result of the work is presented in the form of an Access database, which should contain:
the structure of the designed tables,
data schema with relationships between tables,
examples of forms providing a user interface,
queries (in Design mode and in SQL language),
reports (in report mode and in Design mode),
main button form.

Cars Table - Access Database

Craftsman Table - Access Database Car Service

Job Cost Query - Access Database Car Service

Cross Query - Access Database Car Service

Customer Form - Access Database Car Service

Warehouses Form - Access Database Car Service

Amount with Part and Labor Report - Access Database Car Service

Main Button Form - Access Database Car Service

Main Button Form - Access Database Car Service

Ready-made database The Access Autoservice database is available for download at the link below.

. Ready database Access "Car service"

Download database (DB) MS Access; DB Access Car service; car sales access; access database; db access; subd access; access databases; access example; access programming; ready database; creating a database; DBMS database; access coursework; database example; access program; access description; access abstract; access requests; access examples; download database access; access objects; db in access; download subd access; ms access database; subd access abstract; subd ms access; access benefits; database; download database on access; Database; relational database; database management systems; course database; download database; access database download; access database download; car repair; auto repair; car salon; car repair service

It is necessary to create a database access "Auto service"

Rice. 1 The main button form of the finished database "Car Service"

Form "Owners" with subform "Cars"

Rice. 2 Form "Cars"

Form "Employees"

Rice. 4 Form "Service"

Rice. 5 Requests page

Query "Grouping by jobs and employees"

Request "By the name of the mechanic"

Request "Search by license plate number"

Rice. 6 Reports

Report "Grouping by jobs and employees"

Fig.7 Report "Search by license plate"

Rice. 8 Report "By the name of the mechanic"

Rice. 9 The data schema of the finished database "Car Service" displays the relationships of the tables: Owners, Cars, Service, Job category, Employees.

The structure of the table "Cars": state. number, brand, owner.

The structure of the "Owners" table: owner number, full name, cellular telephone, driver's license number.

The structure of the "Service" table: service number, car, work category, order readiness date, employee.

The structure of the "Employees" table: employee number, cell phone, address, full name.

or here:

Download the database report with screen forms for free

Approximate price 763 rubles.

The exact price depends on the payment method.

Access database payment methods: WebMoney, Payment terminals, Russian Post, QIWI, Beeline, MTC, Megaphone, Debit or Credit Card, WeChat Pay, Alipay (China), UnionPay, Yandex.Money, Gift certificate and others.

Download Access databases of similar subjects:

1. database access Car service 2
2. Formation of invoices for payment in a car service
3. Accounting for cars in a transport company.
4. ATP (motor transport company).
5. ATP 2007 (motor transport company)
6. Auto repair shops
7. "Accounting for the operation of vehicles"
8. "Accounting for traffic accidents"
9. Registration of car offenders in the traffic police.
10. "Accounting for traffic violations"
11. "Replacement of auto parts at the service station"
12. Urban transport
13. "Sale of air tickets"
14. "Bus station"
15. "Car rental"
16. Car rental 2
17. driving school
18. Spare parts company
19. car showroom
20. Accounting for depreciation of vehicles by MOT and groups of vehicles
21. Taxi
22. Passenger car enterprise
23. Minibus timetable
24. Accounting for road transport by car brands

Keywords: database download; database program; database; coursework database; download access database; access; ready access database; databases in access; access database example; create a database in access; examples of access databases; creating a database in access; base access; requests in access; access reports; access tables; macros in access; access coursework; examples of database access; access forms; Database microsoft access; buy a database; database creation; database examples; download database; course work by DBMS; database examples; finished term paper database. Course base"Autoservice" data was created in access 2010 and converted to access 2003, so it will open in access 2003, 2007, 2010.

It is necessary to create a database access "Auto service". The main button form of the finished database "Car service". The "Owners" form with the "Cars" subform. Form "Cars". Form "Category of work". Form "Employees". Service form. Requests page. Query "Grouping by jobs and employees". Request "By the name of the mechanic." Request "Search by license plate number". Report “Grouping by jobs and employees”. Report "By the name of the mechanic." Report "By the name of the mechanic." The data schema of the finished database "Car Service" displays the relationships of the tables: Owners, Cars, Service, Job category, Employees. The structure of the table "Cars": state. number, brand, owner. The structure of the "Owners" table: owner number, full name, cell phone, driver's license number. The structure of the table "Category of work": code of work, name of work, description, cost of work. The structure of the "Service" table: service number, car, work category, order readiness date, employee. The structure of the "Employees" table: employee number, cell phone, address, full name. The structure of the "Grouping by jobs and employees" query in design mode. The structure of the query "By the name of the mechanic" in design mode. The structure of the "Search by license plate" query in design mode. Macros in design mode.

Creation technology Database "Car service"

To create a database, the goals and objectives of the Autoservice database were set:

• ? ensure customer satisfaction with both the service and the firm;
• ? provide best service near
• ? warranty repair of sold new and used cars;
• ? commercial preventive maintenance (adjustments, etc.);
• ? commercial rehabilitation service (repair);
• ? repair of used components and assemblies for the stock of remanufactured spare parts.

• ? people,
• ? materials,
• ? computers,
• ? machines,
• ? building.

The developed and created Database "Car Service" is a collection of interrelated components and displays various areas of car repair.

Figure 14. Database "Car service"

The system is divided into two subsystems and one extension:

• ? Repair of the technical part of the car.
• ? Expansion - car interior repair.

The main system "Repair of the technical part of the car" consists of four tables (see Fig. 15):

« Order» - including necessary information about the order for repair and diagnostics of the car, that is:

• ? Automobile.
• ? Owner.
• ? The reason for contacting the service station.

« Repair"- a table describing the process of repairing the technical parts of the car, namely the parts that need to be repaired in the near future. This table includes items:

• ? Engine repair.
• ? Checkpoint repair.
• ? Chassis repair.
• ? Fuel system repair.

Figure 15. Order for the repair of technical parts

Table " Diagnostics', associated with ' order» and allocates cars for diagnostics of certain parts of the car, i.e. engine, gearbox, chassis and fuel system.

V " Diagnostics» store information about cars that need diagnostics of a particular part.

• ? Engine diagnostics.
• ? Checkpoint diagnostics.
• ? Chassis diagnostics.
• ? Fuel system diagnostics.

Main system working on the basis “Cascading models” and refers on the standard GOST 21624 -76

GOST 18507 -73

The operation of the system comes from the collection of information about the order, then diagnostics take place, which determines the need for repair of the machine. Each stage (except the initial one) cannot begin until the next one is completed, except if the car does not need repairs.

The IT-service subsystem was created in order to provide a guarantee of repair, handling a warranty claim and purchasing spare parts for repairs.

• 1) filing a claim,
• 2) issuing a guarantee,
• 3) ordering spare parts, and includes 11 tables, one of which is common to the IT service. (see fig. 16).

Figure 16. IT service

IT service - divides the entire service into 3 parts:

• ? warranty claims,
• ? issuing a guarantee,
• ? spare parts order.

Data 1 and 2 - contain information about customers.

Receipt 1 - the table contains data on the time of treatment and the price of services rendered.

Reason for contact - a table that contains information about the reason for contacting the service station under warranty. It has a connection with the tables: agreement of SRT 1 and Outcome 1, where data on the agreement of SRT with the claim and the possibility of solving the problem, respectively, are noted.

The extension represents a kind of increase in car repair services. Now the system has body repair and interior repair, which are also handled by the service station.

The extension subsystem consists of two tables and influences two tables from the main system. (see fig. 17)

Figure 17. Extension

The tables "body repair and interior repair" include information on the types of services.

Body repair:

• ? Parts replacement.
• ? Putty.
• ? Painting.
• ? Lacquering.
• ? Polishing.

Interior repair:

• ? Replacement of components.
• ? Component repair.

From these tables follow the links with the table " Price» to fix prices for services.

Functional:

• ? outfit orders,
• ? work,
• ? services,
• ? brigade,
• ? norm-hours.

Database resources:

• ? people,
• ? equipment,
• ? materials,
• ? computers,
• ? machines,
• ? building.

The cascade model, shown in Figure 18, provides for the sequential execution of all stages of the project in a strictly fixed order. The transition to the next stage means the complete completion of the work at the previous stage.

This is represented in the database like this:

• ? taking orders for repairs
• ? Car diagnostics,
• ? car repair,
• ? release of the car from the service station.

Figure 18. Database model

Analysis phase

Here is the application for car repair at the service station. The customer fills out a document where the customer indicates the service that he needs.

Design phase

At this stage, the car is sent for diagnostics, which determines the cause of the car breakdown. In the future, at the choice of the customer, the machine is sent for repair.

Implementation and implementation phase

In this phase, repairs are carried out on the parts of the car that, according to the result of the diagnostics, need to be repaired or replaced. Also, without any checks, at this stage, the exterior of the car and the interior can be repaired.

Maintenance phase

At this stage, a warranty is issued for repairs and a calculation of the funds that were spent on the diagnosis and repair of the car, after which the car is returned to the owner.

System properties

Integrability- the system is integrable, as it has the ability to interact with various banks (payment for services through these banks), with a tax company (sale of spare parts outside the region). Also, the system is connected with various car dealerships (under the contract) and insurance companies that insure the car service itself, as well as the company where spare parts are purchased.

Divisibility- the system consists of many subsystems that perform certain functions and have the ability to work offline.

Integrity- despite the fact that the system is divisible, when fully operational, it will not work if the functionality of one of its subsystems is disrupted.

Structurality- distribution by levels and hierarchies of system elements, i.e. the system will not be able to continue working if one of the stages is skipped (without a guarantee, the customer will not be able to file a claim with the service station).

Standards

GOST 21624 -76 - this standard establishes requirements for products to ensure a given level of operational manufacturability (ET) and maintainability (RP), as well as the values ​​\u200b\u200bof the ET and RP indicators provided for by GOST 20334-81, for automotive products - all-wheel drive and partially drive vehicles (trucks, cars and buses), trailers and semi-trailers (hereinafter - products).

GOST 18507 -73 - this standard applies to buses and cars (hereinafter referred to as cars) and establishes methods for their control tests after major repairs carried out by car repair enterprises.

The standard does not apply to cars, the overhaul of which was made on the orders of individual owners.

Terms of Reference

1. Make a common database of all services at the service station for a particular car.

Figure 19. General base of all services at service stations

2. Data on the necessary tools and materials.

Figure 20. Data on tools and materials

3. Links with third party systems.

Figure 21. Third party systems

Figure 22. Auto centers

Figure 23. Insurers

Figure 24. Insurers field

4. Comments on the quality of service.

Figure 25. Comments

Figure 26. Visitor reviews

Figure 27. Reviews

In the course of the work, a database was created in the MS Access database management system. The work shows a step-by-step technology for creating a database. An example of the database "Car service" is given. This base was tested at the service station. The system has been tested. In the course of the work, adjustments were made and the final version of the Autoservice database was presented in the work.