Abstract
Shyshko A.A., Zavadskaya T. V, Kushnirenko Ye. N - Subsystem of administration distributed database of the trade organization This article suggests creating and realization database and application of auto shows. Modern technologies are offered as development tools. They are: phpMyadmin, XAMPP, MySQL. Also the interface of the subsystem was developed. Interface was developed by using programming languages: HTML, PHP. The subsystem contains all Donetsk auto shows and operates within the city.
Keywords
subsystem, database, index, application, interface,structuralscheme.
Introduction
Nowadays, buying various things is occurring by the Internet. All you want you can order through the Internet and this subsystem will help you. The objective of the project is creation subsystem of administration distributed database of the trade organization. Namely auto show where user can buy any car that he wants. You need to enter your personal information: Your name and surname, your passport number and series, you telephone number information of auto show: name of auto show, address of auto show, address of delivery, date of delivery and also information about the car: brand, model, color, type of transmission, engine capacity.
Problem definition
1 To create database for each information columns
2 To combine columns through the index relations
3 To project an interface of subsystem
4 To realize the interface
5 To combine database and interface into one
6 Test the subsystem for the errors and fix them
Realization
Using the DBMS phpMyAdmin create our database which contains tables: avto, avtosalons, id, personaldata. PhpMyAdmin is a free and open source administration tool for MySQL and MariaDB. As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services [1].
Figure 1 – creating of database
Each table contains columns which have information concerning the table. The table avto has five columns: «id», «name», «color», «value», «korobka».
Figure 2 – table «avto»
The table «avtosalons» has five columns too: «id», «name», «adress», «dostavka», «data».
Figure 3 – table «avtosalons»
The table «personaldata» has four columns: «id», «FIO», «Pasport», «number».
Figure 4 – table «personaldata»
The table «id» has four columns: «id_avto», «id_avtosalons», «id_personaldata»
Figure 5 – table «id»
In order to ensure more convenient operation of the subsystem, it‘s necessary to implement the interface. The essence of the interface in this project is the convenience of introducing and retrieving the necessary information.
Figure 6 –structural scheme of interface
To implement the interface, I used such programming languages as: HTML and PHP.
Hypertext Markup Language (HTML) is the standard markup language for creating web pages and web applications. With Cascading Style Sheets (CSS) and JavaScript, it forms a triad of cornerstone technologies for the World Wide Web. Web browsers receive HTML documents from a web server or from local storage and render the documents into multimedia web pages. HTML describes the structure of a web page semantically and originally included cues for the appearance of the document [2].
PHP is a server-side scripting language designed for web development but also used as a general-purpose programming language. It was originally created by Rasmus Lerdorf in 1994; the PHP reference implementation is now produced by The PHP Group. PHP originally stood for Personal Home Page, but it now stands for the recursive acronym PHP: Hypertext Preprocessor [3].
Figure 7 –high part of the interface
Figure 8 –low part of the interface
Conclusion
The subsystem of administration of the distributed database of the trade organization was developed. This subsystem allows the user to purchase a car without leaving home, which in the future will greatly simplify the purchase of everything that the buyer wants.
References
1.phpMyAdmin [Electronic resourse] . – Access mode: https://en.wikipedia.org...
2. HTML [Electronic resourse] . – Access mode:https://en.wikipedia.org...
3. PHP [Electronic resourse] . – Access mode https://en.wikipedia.org...