Informational database model for accounting of the teachers workload of an educational organization

Abstract

Informational database model for accounting of the teachers workload of an educational organization

Kuzmin N.M., Demina A.A., Ivanchenko G.S., Butenko M.A., Khohlova S.S., Ten A.V.

Incoming article date: 30.10.2021

This paper presents an information model of a relational database developed by the authors, designed to take into account the teachers workload of an educational organization. The identification of the subject area entities, their decomposition and the relationships identification between them are carried out. The constructed database model was brought to the Boyes - Codd normal form. Based on the designed database schema, its physical implementation and filling with test data was carried out. The results of test queries showed the developed model adequacy and the its practical applicationp ossibility. It is currently in trial operation at the Department of Information Systems and Computer Modeling, Volgograd State University. With minimal changes, the developed database schema can be applied to account for the teachers workload in various educational organizations.

Keywords: database, information modeling, "entity-relationship" diagram, decomposition, information system, educational organization