Experience in developing a web application for relational databases modeling with a forward engineering function for training students of technical specialties

Abstract

The article actualizes the need to develop software for modeling relational databases for use in the process of teaching students of technical specialties in disciplines related to databases.The problem is considered from the point of view of assessing modern software used in the process of teaching students database design skills. Based on the shortcomings identified during the software review, a number of requirements for the actual software were determined. Formed key requirements are mobility, accessibility, versatility and openness of the development platform.The article describes the process of solving key problems that arose during the implementation of a project to develop a web application for modeling relational databases in accordance with the generated requirements. The practical implementation of the following functions is sequentially considered: creation of a logical relational data model, creation of a physical data model, direct engineering into relational database software. The main technological solutions used in the development of a web application to ensure the qualities specified in the condition are described.The result of the work is the successful testing of the development results in the process of creating a real web application, both within the framework of laboratory and practical work in the disciplines “Design and administration of databases” and “Data management”, and at the stage of writing graduate works for technical directions of training.