Creating a database for the clothing and footwear store in MySQL DBMS

The article discusses the creation of a database for the clothing and footwear store. The paper presents an example of creating tables and queries in MySQL 5.1 DBMS. MySQL is the most suitable database management system for web application. The process of creating a database in MySQL is the work with the command line. To speed up the process of creating a database in MySQL has allowed the use of a special graphical shell HeidiSQL Portable. Thus, a database for the “Clothing and Footwear” store was developed, namely, queries were created using the HeidiSQL GUI and tables in the MySQL DBMS. The use of HeidiSQL made it easy to manage databases, simplified the process of developing SQL scripts and their further use in developing the site.