Creation technology Database “Car service. Access database Car service Download Access databases of similar subjects

Creation technology Database "Autoservice"

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

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

? people,
? materials,
? computers,
? machine tools,
? building.

The developed and created Database "Autoservice" is a set of interconnected components and displays various directions 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»- which includes the necessary information about the order for the 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 technical parts of a car, namely, parts that need to be repaired in the near future. This table includes items:

? Engine repair.
? Gearbox repair.
? Running gear repair.
? Fuel system repair.

Figure 15. Repair order for technical parts

Table " Diagnostics"Associated with" By order»And distributes cars for diagnostics of certain parts of the car, ie. engine, gearbox, chassis and fuel system.

V " Diagnostics»Information about cars that need diagnostics of one or another part is stored.

? Engine diagnostics.
? Diagnostics of the checkpoint.
? Running gear diagnostics.
? Diagnostics of the fuel system.

The main system works on basis "Cascade models " and refers on standard GOST 21624 -76

GOST 18507 -73

The work of the system comes from collecting information about the order, then diagnostics takes place, which determines the need to repair the machine. Each stage (except the initial one) cannot begin until another is completed, unless the car does not need repairs.

The IT service subsystem was created to provide a repair warranty, claim warranty claims, and purchase spare parts for repairs.

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

Figure 16. IT service

IT service - divides the entire service into 3 parts:

? claim under warranty,
? registration of a guarantee,
? spare parts order.

Data 1 and 2 - contain information about customers.

Receiving 1 - the table contains data on the time of circulation and the price of the services provided.

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

The expansion represents an increase in car repair services. The system now has body and interior repairs, which are also handled by the service station.

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

Figure 17. Extension

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

Body repair:

? Replacement of parts.
? Putty.
? Painting.
? Varnishing.
? Polishing.

Interior repair:

? Replacement of components.
? Repair of components.

Links with the table " Price»To fix prices for services.

Functional:

? outfit orders,
? work,
? services,
? brigades,
? rate-hours.

Database resources:

? people,
? equipment,
? materials,
? computers,
? machine tools,
? building.

The waterfall 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 as follows:

? acceptance of a repair order,
? Car diagnostics,
? car repair,
? car release from service station.

Figure 18. Database model

Analysis phase

Here, an application for car repair at a service station is carried out. The customer fills out a document where the customer specifies 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 option of the customer, the machine is sent for repair.

Implementation and implementation phase

At this stage, repairs take place, parts of the car, which, according to the results of diagnostics, need to be repaired or replaced. Also, without any checks, at this stage, repairs can be made to the exterior of the car and the interior.

Maintenance phase

At this stage, a warranty for the repair is written out and the funds that were spent on diagnostics and repair of the car are calculated, after which the car is returned to the owner.

System properties

Integrability- the system is integrable, since 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 a contract) and insurance companies that insure the car service itself, as well as the company where the purchase of spare parts takes place.

Divisibility- the system consists of many subsystems that perform certain functions and have the ability to work in an autonomous mode.

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 violated.

Structurality- distribution by levels and hierarchies of system elements, i.e. the system will not be able to continue working if you skip one of the stages (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 of ET and RP indicators provided for by GOST 20334-81, for automotive products - all-wheel drive and part-time drive vehicles (trucks, cars and buses), trailers and semitrailers (hereinafter referred to as products).

GOST 18507 -73 - this standard applies to buses and cars (hereinafter referred to as automobiles) and establishes methods for their control tests after overhaul made by auto repair enterprises.

The standard does not apply to passenger cars that have been overhauled on the orders of individual owners.

Technical assignments

1. Make a common base of all services at the service station for a specific car.

Figure 19. General base of all services at the workshop

2. Data on the required tools and materials.

Figure 20. Data on tools and materials

3. Links with third party systems.

Figure 21. Third-party systems

Figure 22. Autocenters

Figure 23. Insurers

Figure 24. Field Insurers

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 the step-by-step technology of creating a Database. An example of the "Autoservice" database is given. This base has been tested at the service station. The system has been tested. In the course of the work, corrections were made and the final version of the "Autoservice" database was presented in the work.

A database is, first of all, a storage 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 attributes. A database can be considered not only tables indexing files with knowledge of different formats, but also these files themselves, because they are not typed repositories of knowledge in such a database. Databases can be used as an auxiliary tool that allows you to implement some useful function.

Share your work on social media

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

Ministry of Education and Science of the 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 VT

Coursework by discipline

"Databases and DBMS"
on the topic:

"Database design

"Car service station" "

Completed by a 3rd year student of FMF

Dmitry Makarov

Supervisor:

Bogdanova N Atalya Vladimirovna

Ryazan 2015

Introduction

In connection with the increase in the amount of information and the need to transform it, there is a growing need to automate existing data processing processes. These processes include analyzing, organizing, displaying and editing information.

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

The projected database "Car service station" allows you to systematize a quick search for the necessary information in a given subject area.

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

The purpose of this course workis the design of the database "Car service station".

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

· Study of the peculiarities of the subject area "Car service station";

· Development of a database schema;

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

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

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

Course work consists of an introduction, two chapters, conclusion, bibliography.

CHAPTER 1. Database Design

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

Manufacturer
Model
Year of issue
Gas equipment
Manufacturer country
State car number
Full name of the owner
Owner's passport number
Owner's address
Owner's phone
Full name of the Employee
Job code
Work description
Date of completion of work
Duration of work

Let's select 4 entities: "Auto", "Owners", "Workers", "Works".

Essence "Auto" has the following attributes:

Manufacturer

Model

State room

Manufacturer country

Gas equipment

Year of issue

Auto "Can have duplicate values, then we add an attribute of the individual movie number, which should not have duplicate values.

Entity "Owners" has the following attributes:

Full name of the owner

Owner's address

Owner's phone

Owner's passport number

Since all the original attributes of the "Directors" entity can have duplicate values, we will add an attribute with an individual director number, which should not have duplicate values.

Entity "Workers" has the following attributes:

Full name of the employee

Since all the original attributes of the entity " Workers »Can have duplicate values, then add the attribute of the individual employee number, which should not have duplicate values.

The essence of "Work" has the following attributes:

Work description

Work completion date

Duration of work

Since all the original attributes of the entity " Work »Can have duplicate values, then we add the attribute code of work, which should not have duplicate values.

Let's accept the agreements.

Agreement 1:

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

Agreement 2:

Each car must belong to the owner, therefore, the belonging class for the "Auto" entity is required. Each owner must own at least one car, therefore, the ownership class for the Owners entity is required.

Figure 1.1 ER - diagram of the relationship of entities Auto and Owners

Thus, we have a binary one-to-many relationship with a mandatory class of belonging 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 the relationship the simply connected entity "Owners" is the passport number.

Agreement 3:

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

Agreement 4:

Work is being done on the car. Work is being done on cars.

Figure 1.2 ER -a connection diagram of the Auto and Work entities

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

Agreement 5:

Any employee can perform any work, therefore, the degree of connection for the "Work" entity is N ... In turn, any work can be performed by any worker, therefore, the degree of connection for the "Workers" entity is N.

Agreement 6:

Workers perform work. Work is performed by employees.

Figure 1.3 ER - diagram of the relationship of the entities Workers and Jobs

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

Communication table (work code, individual employee number)

Functional dependence of the entity "Auto"

Fig.1.4 Functional dependence of the entity "Auto"

State number  Manufacturer

State number  Model

State number  Year of issue

State number  Manufacturer country

State number  Gas

State number  Passport number

State number - determinant, state number is a possible key, which means the relation "Auto" is in the 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 the "Owners" relation is in the BCNF.

Functional dependence of the entity "Works"

Fig.1.6 Functional dependence of the "Works" entity

Job Code  Description

Job Code  Completion Date

Job code  Duration

Job code  State room

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

Functional dependence of the "Workers" 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 the relation “Workers” is in the 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)

AVTO "

Fig. 1.8 Table constructor “ AVTO ”.

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" (Job code, job description, date of completion, state number).

The relation in the relational database corresponds to the table “ RABOTU ”.

Figure 1.12 Table constructor“RABOTU”.

Fig. 1.13 Table of the entity "Jobs"

Communication table (Job code, employee ID number).

The relation in the relational database corresponds to the table"DLYSVYZI"

Fig. 1.14 Table constructor “ DLYSVYZI ”.

Figure 1.15 Table with ligature

"Workers" (Name, employee identification number).

The relation in the relational database corresponds to the table “ RABOTNIKI ”.

Figure 1.16 Table constructor"RABOTNIKI".

Fig. 1.17 Table of the entity "Workers"

Data schema

Fig 1.18 Data schema

CHAPTER 2. Description of OBD and control system

2.1 Requests

Lexus car models

SELECT MODEL FROM AVTO

WHERE PROIZV = "Lexus";

Car manufacturers and all models

SELECT PROIZV, MODEL

FROM AVTO;

Manufacturer, model and state. number of a car belonging to Valery Valentinovich Kuzin

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

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

WHERE VLADELCY. FIO = "Kuzin Valery Valentinovich";

Manufacturer, model, year of manufacture and state number of a car produced before 2005 sorted by release date

SELECT PROIZV, MODEL, GOSNOMER, GODVIPUSKA

FROM AVTO

WHERE GODVIPUSKA< 2005 order by GODVIPUSKA;

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

SELECT RABOTU.DATAV, RABOTU.OPISANIE

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

WHERE RABOTNIKI. FIO = "Smenov Eduard Viktorovich";

List of auto brands, state. numbers and works that were carried out on them

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

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

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

SELECT PROIZV, MODEL

FROM AVTO

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

Display all information about the 3 longest jobs

SELECT TOP 3 *

FROM RABOTU

ORDER BY PRODOLG DESC;

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;

All information about all employees

SELECT *

FROM RABOTNIKI;

Full name, phone number and address of car owners from Ryazan

SELECT FIO, TELEFON, ADRES

FROM VLADELCY

WHERE ADRES LIKE "* Ryazan *";

List of countries producing cars

SELECT DISTINCT STRANA

FROM AVTO;

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;

The number of hours spent working on certain days

TRANSFORM SUM (PRODOLG)

SELECT KODRABOTU

FROM RABOTU

GROUP BY KODRABOTU

PIVOT DATAV;

Description and duration of the shortest work

SELECT OPISANIE, PRODOLG

FROM RABOTU

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

Withdraw all car manufacturers

SELECT PROIZV

FROM AVTO;

Manufacturer and year of production of a car with gas equipment

SELECT PROIZV, GODVIPUSKA

FROM AVTO

WHERE GAZ;

Add information about a new employee in a car service.

INSERT INTO RABOTNIKI

VALUES ("Jason Statham", 7);

Before adding:

Fig. 2.18 Table “ RABOTNIKI ”Before adding a new entry

Inquiry:

After adding:

Fig. 2.20 Table “ RABOTNIKI ”After adding a new entry

Change the address of Loginov Yegor Yurievich

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

WHERE PASPORTNOMER = "34 88 336882";

Before the change:

Fig. 2.21 Table “ VLADELCY ”Before changing the record

Inquiry:

After the change:

Fig. 2.24 Table “ VLADELCY ”After changing the record

Delete a record about a car with license plate e244bv 23.

DELETE *

FROM AVTO

WHERE GOSNOMER = "e 244 cc 23";

Before deletion:

Fig. 2.25 Table “ AVTO ”Before deleting the entry

Inquiry:

After deletion:

Fig. 2.28 Table “ AVTO ”After deleting the entry

2.2. Forms

General form of the database "Car service station"

The form contains buttons for opening subordinate forms (Auto, Owners, Jobs, Employees), buttons for executing requests, as well as a button for closing the main form.

In the "Shape" mode

Fig. 2.29 General form of the database "Car service station"

In the "Constructor" mode

Fig. 2.30 General form of the database "Car service station" in the constructor mode

Form "Auto"

Fig.2.31 Form "Auto"

In the "Constructor" mode

Fig.2.32 Form "Actors" in design mode

Queries for combo boxes

"Owners" form

Figure 2.36 "Owners" form

In the "Constructor" mode

Fig. 2.37 "Owners" form in design mode

Form "Jobs"

Fig. 2.38 Form "Work"

In the "Constructor" mode

Fig. 2.39 Form "Jobs" in design mode

Queries for combo boxes

Communication form "Work-Workers"

Fig. 2.41 Form of communication "Work-Workers"

In the "Constructor" mode

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

Queries 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.

The main stages of development:

Determining the Purpose of Creating a Database
Determining the required fields in the database
Determining the tables that the database should contain.
Define the tables to which the fields belong.
Defining primary keys.
Determination of relationships between tables.
Improvement of the database structure.
Entering data and creating other database objects (such as forms and queries).

The database ensures efficient work, creates ease of use. To obtain information about cars, owners, workers 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 work of this database, since it is made as convenient and understandable as possible.

List of used literature

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

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

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

4. Khomonenko A.D., Tsygankov V.M., Maltsev M.G. Database. Textbook for universities / ed. prof. HELL. Khomonenko // SPb.: CORONAprint, 2000 .-- 416 p.

5. Khomonenko A., Gridin V. V. Microsoft Access. Fast start. - M., 2008 .-- 304s.

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

Auto

N: 1

Owners

Auto

1: N

Work

Workers

N: N

Work

State room

Manufacturer

Model

Year of issue

Manufacturer country

Gas

Passport ID

Full name

Address

Telephone

Code

work

Description

date

fulfillment

Duration

State

room

An identification number

Full name

Other similar works that may interest you. Wshm>
18542.		Passenger car service station	786.59 KB
	The decisive factor for the development of infrastructure is the car park and the tendency of its growth. These are absolutely irreparable losses for us for the future of the country. To solve this problem, special attention should be paid to vehicles belonging to individuals, since the owner is responsible for the technical condition of the vehicle. In second place are the former state-owned service stations in the third place, newly created independent private service stations in the fourth, motor transport enterprises performing technical ...
13718.		Organization of technical maintenance of Mitsubishi cars in the conditions of LLC "Transtekhservice"	363.83 KB
	The aim of the thesis is to organize the maintenance of Mitsubishi cars in the conditions of Transtekhservice LLC. To achieve this goal, the following tasks have been identified: Mitsubishi has won and maintains a reputation as a manufacturer of high quality cars; expansion of the Mitsubishi car model range; consider the technical characteristics of Mitsubishi cars by model range; Mitsubishi TO card: a brief description of the regulations; sequence of execution ...
4523.		Organization of a roadside service station for routine car repairs	369.01 KB
	The features and advantages of road transport, which predetermine a fairly high rate of development, are associated with the mobility and flexibility of delivery of goods and passengers "door-to-door", "just in time" and adherence, if necessary, to the schedule.
17752.		Organization of a motor section at the "KRYMDIZELSERVICE" car service station	649.78 KB
	In the further development and intensification of the work of motor transport, the key problem has become a more complete use of the production potential of enterprises and the identification of reserves for increasing production efficiency. Typically, these carriers do not have their own base for proper maintenance and repair of vehicles. This is due to the fact that the owners of cars either do not have or have to a limited extent the material resources and labor skills to maintain and repair their car. Rapid pace of development ...
4622.		Design of a section for diagnostics of corporate service of passenger cars YSU	2.74 MB
	Khanty-Mansiysk Autonomous Okrug - Yugra is one of the most dynamically developing regions of the Russian Federation. Our district is the main oil and gas region in Russia and one of the largest oil producing regions in the world. In Russia, Khanty-Mansi Autonomous Okrug-Yugra is leading in a number of key economic indicators:
4606.		Design of the aggregate section of corporate service for YSU cars	1.86 MB
	Check the condition of the cab of the platform of the rear-view mirrors of the sun visors of the license plate plumage mechanisms of the door mechanisms of the locks of the sides of the hood platform of the trunk lid of the towing support unit Check the operation of the windshield wiper and washers of the windshield and headlights; the operation of the heating and heating system 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 engine cooling, including ...
20665.		Design and implementation of a pharmacy database	2.55 MB
	Novokuznetsk assignment for term paper It is necessary to design a database that includes information presented in the form of a group of attributes: Pharmacy Drug name; annotation; storage; receipt date; coming; balance at the end of the month; company manufacturer; supplier, etc. The task is as follows: Create a database. Organize persistent relationships between tables to ensure the integrity of your database.
20182.		Database design college full-time	2.59 MB
	Database design for the day department of the college Completed by: student gr. In the course work, the task is set - to develop a database project for the accumulation of the necessary information in the organization to create a fill in the database. The database should be designed taking into account the implementation of requests of various types for obtaining information. When designing the database, consideration should be given to the possibility of issuing a paper report.
20025.		Designing the database of the insurance company OJSC "Sogaz-Med"	448.12 KB
	Insurance companies are financial intermediaries that specialize in providing insurance services. Their activity consists in the formation on the basis of contracts with legal entities and individuals (through the sale of insurance policies) of special funds, from which payments are made to the policyholders of funds in due amounts in the event of certain events (insured events).
10007.		Designing the database "Catalog of car spare parts"	182.36 KB
	Initially, for the accumulation and storage of information on a computer, local arrays (or files) were used, while for each of the functional tasks to be solved, its own files of initial and result information were created. This led to significant duplication of data, complicated their updating, and made it difficult to solve interrelated problematic tasks.

Send your good work in the knowledge base is simple. Use the form below

Students, graduate students, young scientists who use the knowledge base in their studies and work will be very grateful to you.

Posted on http://www.allbest.ru/

FIRST HIGHER TECHNICAL INSTITUTION IN RUSSIA

MINISTRY OF EDUCATION AND SCIENCE OF THE RUSSIAN FEDERATION

Federal State Budgetary Educational Institution of Higher Professional Education

"NATIONAL MINERAL UNIVERSITY" MINING "

Course work

"Database - car service"

Discipline: Applied Programming

Completed by: Stepanova K.A.

Checked by: Matyukhin S.A.

Saint Petersburg 2013

Introduction

1. Description of the subject area

2. Description of the database structure

3. Tables

4. Terms of reference

5. Description of the program

6. Components

7. Scheme for the user

8. Interface

Conclusion

Bibliography

Application

Introduction

In our age, the age of digital technologies, computers play a vital role. Now in every organization, be it government agencies or private firms, everything is computerized, and this is due to the very high computing power. Calculation of even the most complex processes and tasks is performed in the shortest possible time, and the time factor often plays a critical role in most tasks. The computing power and the amount of computer memory in recent years have become incredibly high, and their prices have dropped significantly, this has contributed to the massive computerization of absolutely all branches of human activity. Now it is difficult to imagine life without a smart machine that simplifies and accelerates a huge number of tasks. The usefulness of a computer is reduced to nothing in the absence of specialized software, without which the "iron assistant" becomes useless. In this work, we will talk about the creation of such an important, and in most organizations and the main program, the name of which is a database. In this particular case, the car service database.

1. Description of the subject area

The goal of the task is to obtain a software product that allows you to store information about service customers, defects in their cars, ensuring the efficiency and reliability of data processing.

The car service database is intended for car service operators and provides access to information about the car brand, date of visit, malfunction, car vin number, as well as information about customers: phone number, etc.

The effectiveness of the program lies in reducing the time for processing, searching for the necessary information.

The need to automate this task is due to the fact that the selection of the necessary data for reports and accounting of the work of engineers is usually done manually or using Excel tools, spending a significant amount of time on this. The program also provides search, filtering and data sorting capabilities.

No special knowledge is required to work with the program in the field of programming.

2. Description of the database structure

Table relationships:

The custumers table is linked to the masters table using 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 vin_number field

3. Tables

Table 1: Customers (Lead Table)

Table 2: Masters (Slave)

Table 3: Masters (Slave)

software car service base editing

4. Technical task

Basis for development:

The instructor's assignment for conducting practical exercises and completing coursework.

Development purpose:

The program is designed to automate the work of car service operators.

Requirements for the program:

Should automate the work of the operator of the car service

The information must be permanently stored on the hard disk of the computer

· The database must be viewed with the ability to delete the specified information from it.

Reliability requirements:

· The program should handle erroneous actions of the user and inform him about it.

· The program should provide control of input information.

5. Program description

private void Form1_Load (object sender, EventArgs e) () // loading the main components

private void b_add_Click (object sender, EventArgs e) () // add a new record

private void b_replace_Click (object sender, EventArgs e) () // edit record

private void b_cancel1_Click (object sender, EventArgs e) () // cancel action

private void b_save_Click (object sender, EventArgs e) () // save changes

private void b_record1_Click (object sender, EventArgs e) () // write data

private void b_delete_Click (object sender, EventArgs e) () // delete data

private void b_exit_Click (object sender, EventArgs e) () // exit the program

6. Components

7. Scheme foruser

Table 1 Clients and Table 2 Wizards have a one-to-many relationship in the vin_number field.

Customers Table 1 and Cost Table 3 are related in a one-to-one relationship by the vin_number field.

8. Interface

Adding a new entry

Editing an old entry

Delete entry

Sort by date of visit

Signed tables

The main table of the Autoservice program includes:

1. Customer car list

2. The date of the request of the owner of the car

3. Malfunction

4. Customer's phone

5. Vin number

6. The list of clients is managed by the buttons (Add / Replace / Remove)

7. Display and record of salon clients

8. Sorting

10. Choice of craftsmen

11. Name of tables

12. Exit the program

Conclusion

The result of the work was the creation of software that serves the workplace of the operator of the car service.

In the course of completing the course work, skills were acquired in the field of building and programming databases in the C # programming language.

Bibliography

1. Matyukhin S.A "Programming in C # object-oriented approach" - educational methodological complex 2013

2. A. Hejlsberg, M. Torgersen, S. Viltamut, P. Gold C # programming language. Classics of Computers Science. 4th Edition = C # Programming Language (Covering C # 4.0), 4th Ed. - SPb .: "Peter", 2012. - 784 p. - ISBN 978-5-459-00283-6

3. E. Stillman, J. Green Learning C #. 2nd edition = Head First C #, 2ed. - SPb .: "Peter", 2012. - 704 p. - ISBN 978-5-4461-0105-4

4. Andrew Troelsen The C # 5.0 Programming Language and the .NET 4.5 Framework, 6th edition = Pro C # 5.0 and the .NET 4.5 Framework, 6th edition. - M .: "Williams", 2013. - 1312 p. - ISBN 978-5-8459-1814-7

5. Joseph Albahari, Ben Albahari C # 5.0. Directory. Full language description = C # 5.0 in a Nutshell: The Definitive Reference. - M .: "Williams", 2013. - 1008 p. - ISBN 978-5-8459-1819-2

6. Herbert Schildt. C # 4.0: The Complete Reference = C # 4.0 The Complete Reference. - M .: "Williams", 2010. - S. 1056. - ISBN 978-5-8459-1684-6

Application. Codeprograms

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

public partial class Form1: Form

InitializeComponent ();

groupBox1.Visible = false;

groupBox2.Visible = false;

private void customersBindingNavigatorSaveItem_Click_1 (object sender, EventArgs e)

this.Validate ();

this.customersBindingSource.EndEdit ();

this.tableAdapterManager.UpdateAll (this.db_autoDataSet);

private void Form1_Load (object sender, EventArgs e)

// TODO: This line of code loads data into the "db_autoDataSet.masters" table. You can move, or remove it, as needed.

this.mastersTableAdapter.Fill (this.db_autoDataSet.masters);

// TODO: This line of code loads data into the "db_autoDataSet.calculation" table. You can move, or remove it, as needed.

this.calculationTableAdapter.Fill (this.db_autoDataSet.calculation);

// TODO: This line of code loads data into the "db_autoDataSet.customers" table. You can move, or remove it, as needed.

this.customersTableAdapter.Fill (this.db_autoDataSet.customers);

private void b_exit_Click (object sender, EventArgs e)

private void button5_Click_1 (object sender, EventArgs e)

private void b_add_Click (object sender, EventArgs e)

groupBox1.Visible = true;

b_replace.Visible = false;

b_delete.Visible = false;

b_exit.Visible = false;

b_add.Visible = false;

b_exit2.Visible = false;

b_save.Visible = false;

textBox1.Text = "";

textBox2.Text = "";

textBox3.Text = "";

textBox4.Text = "";

textBox5.Text = "";

private void b_replace_Click (object sender, EventArgs e)

textBox10.Text = customers DataGridView.CurrentRow.Cells.Value.ToString ();

textBox9.Text = customers DataGridView.CurrentRow.Cells.Value.ToString ();

textBox8.Text = customers DataGridView.CurrentRow.Cells.Value.ToString ();

textBox7.Text = customers DataGridView.CurrentRow.Cells.Value.ToString ();

textBox6.Text = customers DataGridView.CurrentRow.Cells.Value.ToString ();

textBox6.ReadOnly = true;

groupBox2.Visible = true;

b_add.Visible = false;

b_delete.Visible = false;

b_exit.Visible = false;

b_exit2.Visible = false;

b_replace.Visible = false;

b_save.Visible = false;

private void b_cancel1_Click (object sender, EventArgs e)

b_add.Visible = true;

b_delete.Visible = true;

b_exit.Visible = true;

b_exit2.Visible = true;

b_replace.Visible = true;

b_save.Visible = true;

groupBox1.Visible = false;

private void b_cancel2_Click (object sender, EventArgs e)

b_add.Visible = true;

b_delete.Visible = true;

b_exit.Visible = true;

b_exit2.Visible = true;

b_replace.Visible = true;

b_save.Visible = true;

groupBox2.Visible = false;

private void b_save_Click (object sender, EventArgs e)

customersBindingNavigatorSaveItem_Click_1 (sender, e);

private void b_record1_Click (object sender, EventArgs e)

DataTable table = db_autoDataSet.Tables;

DataRow row = table.NewRow ();

row = textBox1.Text;

row = Convert.ToDateTime (textBox2.Text);

row = textBox3.Text;

row = textBox4.Text;

row = textBox5.Text;

table.Rows.Add (row);

groupBox1.Hide ();

b_replace.Visible = true;

b_delete.Visible = true;

b_exit.Visible = true;

b_add.Visible = true;

b_exit2.Visible = true;

b_save.Visible = true;

private void b_record2_Click (object sender, EventArgs e)

DataTable table = db_autoDataSet.Tables; // 12 bound dynamic. tab. table with the first file from the database

vinRab = Convert.ToInt64 (customersDataGridView.CurrentRow.Cells.Value.ToString ()); // 13 got the vin of the current record

DataRow row = table.Rows.Find (vinRab); // 14 combined dynamic. row row with the record of the vin file c shifrRab and put the DataSet into the "edit" state, in which it allows changing the field values

row = textBox10.Text; // 15 wrote in the second field of the row row given from the window

row = Convert.ToDateTime (textBox9.Text); // 15 were written in the third field of row row

row = textBox8.Text; // 15 was written to the fourth field of the row row row = textBox7.Text;

row = textBox6.Text;

table.AcceptChanges (); // 15 the AcceptChanges command allows you to accept changed field values

groupBox2.Hide (); // 16

b_replace.Visible = true;

b_delete.Visible = true;

b_exit.Visible = true;

b_add.Visible = true;

b_exit2.Visible = true;

b_save.Visible = true;

private void b_delete_Click (object sender, EventArgs e)

// delete the line under the cursor

// first build a warning to avoid making an erroneous deletion

string s1, s2, s3, s4, s5, message;

DialogResult result; // 18

int ind = customersDataGridView.CurrentRow.Index;

s1 = customersDataGridView.CurrentRow.Cells.Value.ToString ();

s2 = customersDataGridView.CurrentRow.Cells.Value.ToString ();

s3 = customersDataGridView.CurrentRow.Cells.Value.ToString ();

s4 = customersDataGridView.CurrentRow.Cells.Value.ToString ();

s5 = customersDataGridView.CurrentRow.Cells.Value.ToString ();

message = "Car brand =" + s1 + "\ nDate of visit =" + s2 + "\ n Malfunction =" + s3 + "\ n Customer phone =" + s4 + "\ n vin number" + s5;

// the variable result can be either DialogResult.Yes or DialogResult.No

result = MessageBox.Show (message, "Are you sure you want to delete the next entry?",

MessageBoxButtons.YesNo, MessageBoxIcon.Question);

if (result == DialogResult.Yes) // The line is deleted

(// 20 The current table from customersDataGridView of DataGrid type is written to the buffer table

CurrencyManager CurMng = (CurrencyManager) customersDataGridView.BindingContext;

if (CurMng.Count> 0) // if the table is not empty

CurMng.RemoveAt (CurMng.Position); // deleting the marked position

// here result == DialogResult.No and deletion is rejected

// exit the procedure

Posted on Allbest.ru

Creation technology Database “Car service. Access database Car service Download Access databases of similar subjects

Creation technology Database "Autoservice"

Introduction

CHAPTER 1. Database Design

CHAPTER 2. Description of OBD and control system

2.1 Requests

2.2. Forms

Conclusion

List of used literature

Send your good work in the knowledge base is simple. Use the form below

Completed by: Stepanova K.A.

Checked by: Matyukhin S.A.

Similar documents