DEVELOPMENT OF THE DATABASE FOR THE BREAD AND BAKERY MANUFACTURE
The article discusses the development of the bread and bakery products manufacture database. The database is created on MS SQL Server. This database should contain information about the products produced by this enterprise, the ingredients from which the products are made, about what product in what quantity is produced, how the sale of products is organized, how purchases are made and how the implementation of all these processes is organized. The plant's management may need the following information: how many products are left in the warehouse, taking into account production costs; what is the total cost of the products spent in the product; what is the total profit for the month. It is also necessary to provide for the possibility of issuing a document of a report on the balance of products in stock, sales report on months and a procurement report by month. To ensure the smooth operation of the plant, every day it is necessary to take into account which ingredients in what volume were used in the production. The quantities of ingredients used should be deducted from the quantities of ingredients in stock. These changes must be made to the database on a daily basis. If the balance of products in the warehouse is not sufficient for the production of products during the period specified by the management, then they must be purchased. Also, the profit from the production and sale of products should be determined monthly. Stored procedures are developed on the server to solve the above problems. For the convenience of users, the interface for working with the database of the bakery manufacture was developed using VBA Excel tools.