Abstract
This paper deals with the development of virtual laboratory for Databases discipline, such laboratory can be used by Information Technology students as an auxiliary tool for self-education and acquiring professional skills in Ukrainian universities. The functional and software requirements for the laboratory practicum are given briefly in the paper. The functional and object models for the process of utilizing educational tools are presented in graphical and mathematical forms. The functional model represents the logic of the business process, data domain participants, and data exchange scheme. Business Process Modeling Notation has been used for representing the functional model in graphical form. The object model shows structural features of the data domain describing the entities, their attributes, and their interconnections. Entity Relation Diagram has been used for representing the object model in graphical form. The paper gives a description of the structure of relational database, as well as the features of graphical web-interface which implement the required functionality. The web-interface has been developed accounting for understandability, simplicity, and lowered sensitivity to user’s mistakes. At the database and application level, the access rights are divided between user roles. In contrast to the existing ones, the virtual practicum presented herein gives a student the ability to master writing various SQL-queries. The given models of the data domain are universal and can be used for development of e-learning systems for various courses. The distinctive features of the proposed virtual laboratory are given here, as well as improvements that can be achieved when used in educational process.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Yefymenko, Yu.: Computer laboratory practicum on digital technology. Digests Berdyansk State Pedagogical Univ. 6, 5–11 (2013)
Bobrivnyk, K., Gladka, N., Kiktev, M.: Designing virtual learning laboratory for students of technical and technological professions. Energy Autom. 3, 18–23 (2014)
Lapinsky, V., Voevodin, S.: Laboratory workshop environment on the base of NI LabView. Comput. Sch. Fam. 6, 29–33 (2015)
Shamshin, A.: Remote lab in physical practice. New Comput. Technol. 15, 185–188 (2017)
Malykhina, T.: Virtual laboratory workshop on the basis of GEANT4 in the Linux environment to explore the processes of radiation interaction with matter. In: Second International Conference on Foss Lviv, Lviv, Ukraine, pp. 81–84 (2012)
Zianchuryna, I., Liuliuchenko, T.: Virtual laboratory practice on «Circuit theory» course. Opened Inf. Comput. Integr. Technol. 49, 228–233 (2011)
Kolodiy, R.: Development of a virtual laboratory workshop for remote sensing of digital transmission system in the MOODLE. Bull. Lviv Polytech. Natl Univ. 775, 63–68 (2013)
Ovcharenko, V.: Organization laboratory practical work on medicinal chemistry on modern means of IT. Young Sci. 10(37), 269–272 (2016)
Chornyi, O., Rodkin, D., Yevstifieiev, V., Perekrest, A., Velichko, T.: Virtual laboratory complexes for an educational process and scientific researches. Trans. Kremenchuk Mykhailo Ostrohradskyi Natl. Univ. 3(50), 28–42 (2008)
Theory and practice. https://theoryandpractice.ru/posts/17365-8-onlayn-platform-s-kursami-po-programmirovaniyu. Accessed 20 Aug 2019
CS50 IDE. https://cs50.readthedocs.io/ide/online/. Accessed 25 Aug 2019
Zharkykh, Yu., Lysochenko, S., Sus, B., Shkavro, A.: Problems of organization of laboratory practicum in the process of e-learning. Sci. Notes Pedagogy 1, 72–78 (2011)
Traxler, J.: Distance learning – predictions and possibilities. Educ. Sci. 8(35), 1–13 (2018)
Porumb, C., Orza, B., Mihon, D., Rad, A.: Virtual laboratory and classware concepts in internship programmes. In: 17th International Conference on IT Based Higher Education and Training, Olhao, Portugal, pp. 211–220 (2018)
Yalova, K., Zavgorodnii, V.: Challenges and prospects in development of e-learning system for IT students. Eng. Educ. Life-Long Learn. 1(26), 25–43 (2016)
Author information
Authors and Affiliations
Corresponding authors
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2020 Springer Nature Switzerland AG
About this paper
Cite this paper
Kateryna, Y., Kseniia, Y. (2020). Virtual Educational Laboratory for Databases Discipline. In: Shakhovska, N., Medykovskyy, M.O. (eds) Advances in Intelligent Systems and Computing IV. CSIT 2019. Advances in Intelligent Systems and Computing, vol 1080. Springer, Cham. https://doi.org/10.1007/978-3-030-33695-0_42
Download citation
DOI: https://doi.org/10.1007/978-3-030-33695-0_42
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-33694-3
Online ISBN: 978-3-030-33695-0
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)