DSpace Home
→
Електронні публікації
→
Фізико-математичний факультет
→
Кафедра інформатики та прикладної математики
→
View Item

The selection of cloud services for ER-diagrams construction in IT specialists databases teaching

Vakaliuk, Tetiana A.; Korotun, Olha V.; Семеріков, Сергій Олексійович; Вакалюк, Тетяна Анатоліївна

URI: http://ceur-ws.org/Vol-2879/paper21.pdf
http://elibrary.kdpu.edu.ua/xmlui/handle/123456789/4371
https://doi.org/10.31812/123456789/4371

Date: 2021-06-10

Abstract:

One of the main aspects of studying databases in higher education institutions by future IT specialists is database design and software product development. This, in turn, is the most important problem of the developer’s interaction with the customer. To facilitate the process of database design, ER-diagrams are used, which are based on the concepts of “Entity” and “Relationship”. An ER diagram allows you to present a database in the form of visual graphical objects that define a specific subject area. The article considers the available cloud services for the construction of ER-diagrams for learning databases of future IT specialists and their selection the method expert evaluation. For this purpose, the criteria and indicators for the selection of cloud services for the construction of ER-diagrams of databases by future information technology specialists have been determined. As a result, it was found that the cloud services Dbdesigner.net and Lucidchart are the most convenient to learn. It is determined that for a teacher of a higher education institution the use of cloud services is an opportunity to use licensed software in education without additional costs.

Description:

[1] D. Yeh, Y. Li, W. Chu, Extracting entity-relationship diagram from a table-based legacy database, Journal of Systems and Software 81 (2008) 764–771. doi:https://doi.org/ 10.1016/j.jss.2007.07.005. [2] P. Schmieder, B. Plimmer, G. Dobbie, Sketching ER diagrams, in: Tenth Australasian User Interface Conference (AUIC2009), Conferences in Research and Practice in Information Technology (CRPIT), volume 93, 2009. URL: https://www.researchgate.net/publication/ 234796288_Sketching_ER_diagrams.[3] P. S. Dhabe, M. S. Patwardhan, A. A. Deshpande, M. L. Dhore, B. V. Barbadekar, H. K. Abhyankar, Articulated entity relationship (AER) diagram for complete automation of relational database normalization, International Journal of Database Management Systems 2 (2010) 84–100. URL: http://journaldatabase.info/articles/articulated_entity_relationship_ aer.html. [4] X. Jing, L. Yong-ge, G. Feng, W. Ji-peng, Research of oracle bone inscriptions ontology construction based on relational database, Procedia Environmental Sciences 11 (2011) 447–451. doi:10.1016/j.proenv.2011.12.071. [5] A. L. Hayes, M. Das, P. Odom, S. Natarajan, User friendly automatic construction of background knowledge: Mode construction from ER diagrams, in: Proceedings of the Knowledge Capture Conference, K-CAP 2017, Association for Computing Machinery, New York, NY, USA, 2017. URL: https://doi.org/10.1145/3148011.3148027. doi:10.1145/ 3148011.3148027. [6] A. Kiv, M. Shyshkina, S. Semerikov, A. Striuk, M. Striuk, H. Shalatska, CTE 2019 - When cloud technologies ruled the education, CEUR Workshop Proceedings 2643 (2020) 1–59. URL: http://ceur-ws.org/Vol-2643/paper00.pdf. [7] A. Kiv, V. Soloviev, S. Semerikov, CTE 2018 – How cloud technologies continues to transform education, CEUR Workshop Proceedings 2433 (2019) 1–19. URL: http://ceur-ws. org/Vol-2433/paper00.pdf. [8] M. Shyshkina, M. Marienko, The use of the cloud services to support the math teachers training, CEUR Workshop Proceedings 2643 (2020) 690–704. URL: http://ceur-ws.org/ Vol-2643/paper41.pdf. [9] O. Markova, S. Semerikov, A. Striuk, H. Shalatska, P. Nechypurenko, V. Tron, Implementation of cloud service models in training of future information technology specialists, CEUR Workshop Proceedings 2433 (2019) 499–515. URL: http://ceur-ws.org/Vol-2433/paper34. pdf. [10] O. Korotun, T. Vakaliuk, V. Soloviev, Model of using cloud-based environment in training databases of future it specialists, CEUR Workshop Proceedings 2643 (2020) 281–292. URL: http://ceur-ws.org/Vol-2643/paper16.pdf. [11] S. Lytvynova, Cloud-oriented learning environment of secondary school, CEUR Workshop Proceedings 2168 (2017) 7–12. URL: http://ceur-ws.org/Vol-2168/paper2.pdf. [12] T. Vakaliuk, D. Antoniuk, A. Morozov, M. Medvedieva, M. Medvediev, Green it as a tool for design cloud-oriented sustainable learning environment of a higher education institution, E3S Web of Conferences 166 (2020) 10013. doi:10.1051/e3sconf/202016610013. [13] S. Symonenko, V. Osadchyi, S. Sysoieva, K. Osadcha, A. Azaryan, Cloud technologies for enhancing communication of it-professionals, CEUR Workshop Proceedings 2643 (2020) 225–236. URL: http://ceur-ws.org/Vol-2643/paper12.pdf. [14] N. Valko, N. Kushnir, V. Osadchyi, Cloud technologies for stem education, CEUR Workshop Proceedings 2643 (2020) 435–447. URL: http://ceur-ws.org/Vol-2643/paper25.pdf. [15] S. Proskura, S. Lytvynova, The approaches to web-based education of computer science bachelors in higher education institutions, CEUR Workshop Proceedings 2643 (2020) 609–625. URL: http://ceur-ws.org/Vol-2643/paper36.pdf. [16] O. M. Spirin, T. A. Vakaliuk, Criteria of open web-operated technologies of teaching the fundamentals of programs of future teachers of informatics, Information Technologies and Learning Tools 60 (2017) 275–287. URL: https://journal.iitta.gov.ua/index.php/itlt/article/ view/1815. doi:10.33407/itlt.v60i4.1815. [17] T. A. Vakaliuk, O. V. Korotun, D. S. Antoniuk, Selection of the cloud-oriented database learning tools for future it professionals, Information Technologies and Learning Tools 71 (2019) 154–168. URL: https://journal.iitta.gov.ua/index.php/itlt/article/view/2880. doi:10. 33407/itlt.v71i3.2880. [18] M. P. Shyshkina, M. V. Popel, Cloud based learning environment of educational institutions: The current state and research prospects, Information Technologies and Learning Tools 37 (2013) 66–80. URL: https://journal.iitta.gov.ua/index.php/itlt/article/view/903. doi:10. 33407/itlt.v37i5.903. [19] Erwin, Erwin data modeler, 2020. URL: https://erwin.com/products/erwin-data-modeler/. [20] SQL DBM, Develop database online, 2020. URL: https://sqldbm.com. [21] Quest Software Inc, Toad data modeler, 2020. URL: http://www.toadworld.com/products/ toad-data-modeler. [22] GenMyModel, The leading online modeling platform, 2020. URL: https://www.genmymodel. com/. [23] Valentina, The best free DB management tool, 2020. URL: https://www.valentina-db.com/ en/valentina-studio-overview. [24] Lucid Software Inc, Lucidchart, 2020. URL: https://www.lucidchart.com/. [25] Cinergix Pty Ltd, Creately, 2020. URL: https://creately.com/. [26] Dbdesigner.net, Online database schema design and modeling tool, 2020. URL: https: //www.dbdesigner.net. [27] Quick DBD, Quick database diagrams, 2020. URL: https://app.quickdatabasediagrams.com. [28] Vertabelo, Web based data modeler for professionals, 2020. URL: https://www.vertabelo. com/. [29] DModelAid, Database design made easy online, 2020. URL: https://www.dmodelaid.com. [30] Drawio, Diagrams.net, 2020. URL: https://app.diagrams.net/.

Show full item record