The selection of cloud services for ER-diagrams construction in IT specialists databases teaching
Keywords:selection, cloud services, ER-diagrams, databases, future specialists in information technology, future IT specialists
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.
Cinergix Pty Ltd, 2020. Creately. Available from: https://creately.com/.
Dbdesigner.net, 2020. Online database schema design and modeling tool. Available from: https://www.dbdesigner.net.
Dhabe, P.S., Patwardhan, M.S., Deshpande, A.A., Dhore, M.L., Barbadekar, B.V. and Abhyankar, H.K., 2010. Articulated entity relationship (AER) diagram for complete automation of relational database normalization. International journal of database management systems, 2(2), pp.84–100. Available from: http://journaldatabase.info/articles/articulated_entity_relationship_aer.html. DOI: https://doi.org/10.5121/ijdms.2010.2206
DModelAid, 2020. Database design made easy online. Available from: https://www.dmodelaid.com.
Drawio, 2020. Diagrams.net. Available from: https://app.diagrams.net/.
Erwin, 2020. Erwin data modeler. Available from: https://erwin.com/products/erwin-data-modeler/.
GenMyModel, 2020. The leading online modeling platform. Available from: https://www.genmymodel.com/.
Hayes, A.L., Das, M., Odom, P. and Natarajan, S., 2017. User friendly automatic construction of background knowledge: Mode construction from ER diagrams. Proceedings of the knowledge capture conference. New York, NY, USA: Association for Computing Machinery, K-CAP 2017. Available from: https://doi.org/10.1145/3148011.3148027. DOI: https://doi.org/10.1145/3148011.3148027
Jing, X., Yong-ge, L., Feng, G. and Ji-peng, W., 2011. Research of oracle bone inscriptions ontology construction based on relational database. Procedia environmental sciences, 11, pp.447–451. Available from: https://doi.org/10.1016/j.proenv.2011.12.071. DOI: https://doi.org/10.1016/j.proenv.2011.12.071
Kiv, A., Shyshkina, M., Semerikov, S., Striuk, A., Striuk, M. and Shalatska, H., 2020. CTE 2019 - When cloud technologies ruled the education. Ceur workshop proceedings, 2643, pp.1–59. Available from: http://ceur-ws.org/Vol-2643/paper00.pdf. DOI: https://doi.org/10.55056/cte.306
Kiv, A., Soloviev, V. and Semerikov, S., 2019. CTE 2018 – How cloud technologies continues to transform education. Ceur workshop proceedings, 2433, pp.1–19. Available from: http://ceur-ws.org/Vol-2433/paper00.pdf. DOI: https://doi.org/10.55056/cte.352
Korotun, O., Vakaliuk, T. and Soloviev, V., 2020. Model of using cloud-based environment in training databases of future it specialists. Ceur workshop proceedings, 2643, pp.281–292. Available from: http://ceur-ws.org/Vol-2643/paper16.pdf. DOI: https://doi.org/10.55056/cte.360
Lucid Software Inc, 2020. Lucidchart. Available from: https://www.lucidchart.com/.
Lytvynova, S., 2017. Cloud-oriented learning environment of secondary school. Ceur workshop proceedings, 2168, pp.7–12. Available from: http://ceur-ws.org/Vol-2168/paper2.pdf. DOI: https://doi.org/10.55056/cte.129
Markova, O., Semerikov, S., Striuk, A., Shalatska, H., Nechypurenko, P. and Tron, V., 2019. Implementation of cloud service models in training of future information technology specialists. Ceur workshop proceedings, 2433, pp.499–515. Available from: http://ceur-ws.org/Vol-2433/paper34.pdf. DOI: https://doi.org/10.55056/cte.409
Proskura, S. and Lytvynova, S., 2020. The approaches to web-based education of computer science bachelors in higher education institutions. Ceur workshop proceedings, 2643, pp.609–625. Available from: http://ceur-ws.org/Vol-2643/paper36.pdf. DOI: https://doi.org/10.55056/cte.416
Quest Software Inc, 2020. Toad data modeler. Available from: http://www.toadworld.com/products/toad-data-modeler.
Quick DBD, 2020. Quick database diagrams. Available from: https://app.quickdatabasediagrams.com.
Schmieder, P., Plimmer, B. and Dobbie, G., 2009. Sketching ER diagrams. Tenth australasian user interface conference (auic2009), conferences in research and practice in information technology (crpit). vol. 93. Available from: https://www.researchgate.net/publication/234796288_Sketching_ER_diagrams.
Shyshkina, M. and Marienko, M., 2020. The use of the cloud services to support the math teachers training. Ceur workshop proceedings, 2643, pp.690–704. Available from: http://ceur-ws.org/Vol-2643/paper41.pdf. DOI: https://doi.org/10.55056/cte.419
Shyshkina, M.P. and Popel, M.V., 2013. Cloud based learning environment of educational institutions: The current state and research prospects. Information technologies and learning tools, 37(5), pp.66–80. Available from: https://doi.org/10.33407/itlt.v37i5.903. DOI: https://doi.org/10.33407/itlt.v37i5.903
Spirin, O.M. and Vakaliuk, T.A., 2017. Criteria of open web-operated technologies of teaching the fundamentals of programs of future teachers of informatics. Information technologies and learning tools, 60(4), pp.275–287. Available from: https://doi.org/10.33407/itlt.v60i4.1815. DOI: https://doi.org/10.33407/itlt.v60i4.1815
SQL DBM, 2020. Develop database online. Available from: https://sqldbm.com.
Symonenko, S., Osadchyi, V., Sysoieva, S., Osadcha, K. and Azaryan, A., 2020. Cloud technologies for enhancing communication of it-professionals. Ceur workshop proceedings, 2643, pp.225–236. Available from: http://ceur-ws.org/Vol-2643/paper12.pdf. DOI: https://doi.org/10.55056/cte.355
Vakaliuk, T., Antoniuk, D., Morozov, A., Medvedieva, M. and Medvediev, M., 2020. Green it as a tool for design cloud-oriented sustainable learning environment of a higher education institution. E3s web of conferences, 166, p.10013. Available from: https://doi.org/10.1051/e3sconf/202016610013. DOI: https://doi.org/10.1051/e3sconf/202016610013
Vakaliuk, T.A., Korotun, O.V. and Antoniuk, D.S., 2019. Selection of the cloud-oriented database learning tools for future it professionals. Information technologies and learning tools, 71(3), pp.154–168. Available from: https://doi.org/10.33407/itlt.v71i3.2880. DOI: https://doi.org/10.33407/itlt.v71i3.2880
Valentina, 2020. The best free DB management tool. Available from: https://www.valentina-db.com/en/valentina-studio-overview.
Valko, N., Kushnir, N. and Osadchyi, V., 2020. Cloud technologies for stem education. Ceur workshop proceedings, 2643, pp.435–447. Available from: http://ceur-ws.org/Vol-2643/paper25.pdf. DOI: https://doi.org/10.55056/cte.384
Vertabelo, 2020. Web based data modeler for professionals. Available from: https://www.vertabelo.com/.
Yeh, D., Li, Y. and Chu, W., 2008. Extracting entity-relationship diagram from a tablebased legacy database. Journal of systems and software, 81(5), pp.764–771. Available from: https://doi.org/https://doi.org/10.1016/j.jss.2007.07.005. DOI: https://doi.org/10.1016/j.jss.2007.07.005
How to Cite
This work is licensed under a Creative Commons Attribution 4.0 International License.