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
Abstract:
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.
Keywords:information technologies, databases, information flows, automated control system.