Development of an information system for accounting for the reception and payment of orders for visitors to cafes and restaurants using the SQL Server DBMS and the C# programming language, in the context of the knowledge economy and the development of intelligent habitats

The article is devoted to the development of an information system for accounting for the reception and payment of orders for visitors to cafes and restaurants using the SQL Server DBMS and the C# programming language, in the context of the development of intelligent habitats. A description of a new technology for receiving and paying for orders of a modern cafe or restaurant using IDEF0 is presented. The information support of the system was modeled, an ER-diagram was built with an entity level and an attribute level. The logical scheme of the database has been built. The development of the physical structure of the database has been completed and the development of the client part of the IS has been described, the scheme of EIS functioning has been considered. The technology of working with IS and the user manual are given. The designed software will make it possible to implement such functions as accounting for dishes; menu accounting; order accounting; employee accounting; accounting of discount cards of clients; automatic calculation of the cost of the order; menu printing; order printing; check printing; generating reports; export reports to MS Excel.