Preview

Informatics and education

Advanced search

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

https://doi.org/10.32517/0234-0453-2021-36-9-55-62

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.

About the Authors

M. V. Smirnov
MIREA — Russian Technological University
Russian Federation

 Mikhail V. Smirnov, Candidate of Sciences (Economics), Associate Professor at the Department “Subject-oriented information systems”, Institute for Cybersecurity and Digital Technologies

Moscow 



V. M. Polenok
MIREA — Russian Technological University
Russian Federation

 Vyacheslav M. Polenok, a master’s student at the Department of Practical and Applied Informatics, Institute of Information Technologies


Moscow 



References

1. Gavrilov A. V. The use of modern case-tools of structural design in teaching students on the bachelor program “Applied informatics”. Open education. 2015;(4):22–27. DOI: 10.21686/1818-4243-2015-4(111-22-27

2. Gavrilov A. V. Analysis of functionality free CASE-tools databases design. Open education. 2016;20(4):39–43. DOI:10.21686/1818-4243-2016-4-39-43

3. Titovskaya N. V., Titovsky S. N. TEchnique of teaching design and development of databases to future information technology experts. The bulletin of the Krasnoyarsk State Pedagogical University named after V. P. Astafev. 2019;(4):75–87. DOI: 10.25146/1995-0861-2019-50-4-164

4. Zuoyou Yin. Database design on rotating classroom teaching resources system based on DB2. Proc. 2nd Int. Conf. on Materials Science, Machinery and Energy Engineering (MSMEE 2017). Atlantis Press; 2017:1584–1588. DOI: 10.2991/msmee-17.2017.285

5. Katz Adi. Improved teaching of database schema modeling by visualizing changes in levels of abstraction. Journal of Information Systems Education. 2020;31(4):294–311. Available at: http://jise.org/Volume31/n4/JISEv31n4p294.html

6. Roy-Hubara N., Sturm A. Design methods for the new database era: a systematic literature review. Software and System Modeling. 2020;19:297–312. DOI: 10.1007/s10270-019-00739-8

7. Yubei Lin. Student-centered teaching design and practice of database course. Advances in Social Science, Education and Humanities Research. 2020;450:149–153. DOI: 10.2991/assehr. k.200727.033

8. Li Yang, Li Cao. The effect of MySQL Workbench in teaching entity-relationship diagram (ERD) to relational schema mapping. International Journal of Modern Education and Computer Science (IJMECS). 2016;8(7):1–12. DOI: 10.5815/ijmecs.2016.07.01

9. Date C. J. Introduction to database systems. Мoscow, Williams; 2006. 1328 p.

10. Connolly T., Begg C. E. Database systems: A practical approach to design, implementation, and management. Мoscow, Williams; 2003. 1436 p.

11. MySQL Workbench. Available at: https://www.mysql.com/products/workbench/

12. Introducing Valentina Studio best free database management software. Available at: https://valentina-db.com/en/valentina-studio-overview

13. dbForge Studio for SQL Server. Available at: https://www.devart.com/ru/dbforge/sql/studio/

14. PonyORM — Python ORM with beautiful query syntax. Available at: https://ponyorm.org/

15. HTML Standard. Available at: https://html.spec.whatwg.org

16. JSON. Available at: http://json.org/json-ru.html

17. McLaughlin B. Head Rush Ajax. St. Petersburg, Piter; 2007. 443 p.

18. Mcfarland D. JavaScript & jQuery: The Missing Manual. Мoscow, Dialektika; 2015. 880 p.

19. DB Logic Assistant. Available at: http://msuniversity.ru/dba/20. MSUniversity. Available at: http://msuniversity.ru


Review

For citations:


Smirnov M.V., Polenok V.M. Experience in developing a web application for relational databases modeling with a forward engineering function for training students of technical specialties. Informatics and education. 2021;(9):55-62. (In Russ.) https://doi.org/10.32517/0234-0453-2021-36-9-55-62

Views: 447


Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 License.


ISSN 0234-0453 (Print)
ISSN 2658-7769 (Online)