Information-logical Model of Integrated Automating Tracking System for Food Production

Abstract

The article describes the existing methods of semantic modeling, namely, the most popular and widespread notations for entity-relationship model development and their main features are described. And a version of the semantic model of the subject area is presented. The visualization of the data structure is considered, which allows to represent entities clearly, their relationships and the relationship between them. An information-logical model is presented in the form of described interconnected sets of the production and technical system and their projections, a description of the relationships and dependencies between the sets is presented, the attributes of each set are defined, allowing the most detailed description of the set elements, at the same time the attributes are defined so as to avoid redundancy. Sets describing all aspects of the system functioning, in addition to the main part of the system related to food production, including products, production recipes, equipment, production standards and technological operations, also interactions with the system from the outside, such as interaction with suppliers and customers, as well as internal processes related to employee management are presented. When designing and creating a database, visualization and description are used to optimize the structure, i.e. identify and eliminate data redundancy, as well as to maintain normalization of the structure according to normal forms. The stages of model design are described, starting from identifying entities and defining their attributes, to defining the relationships of these entities and normalizing the resulting data. The purpose of this process is to prevent errors in creating structures not only during design, but also during the physical implementation of structures.