Virtual Educational Laboratory for Databases Discipline

  • Yalova KaterynaEmail author
  • Yashyna KseniiaEmail author
Conference paper
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 1080)


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.


Virtual learning tools Laboratory practicum E-learning Blending learning 


  1. 1.
    Yefymenko, Yu.: Computer laboratory practicum on digital technology. Digests Berdyansk State Pedagogical Univ. 6, 5–11 (2013)Google Scholar
  2. 2.
    Bobrivnyk, K., Gladka, N., Kiktev, M.: Designing virtual learning laboratory for students of technical and technological professions. Energy Autom. 3, 18–23 (2014)Google Scholar
  3. 3.
    Lapinsky, V., Voevodin, S.: Laboratory workshop environment on the base of NI LabView. Comput. Sch. Fam. 6, 29–33 (2015)Google Scholar
  4. 4.
    Shamshin, A.: Remote lab in physical practice. New Comput. Technol. 15, 185–188 (2017)Google Scholar
  5. 5.
    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)Google Scholar
  6. 6.
    Zianchuryna, I., Liuliuchenko, T.: Virtual laboratory practice on «Circuit theory» course. Opened Inf. Comput. Integr. Technol. 49, 228–233 (2011)Google Scholar
  7. 7.
    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)Google Scholar
  8. 8.
    Ovcharenko, V.: Organization laboratory practical work on medicinal chemistry on modern means of IT. Young Sci. 10(37), 269–272 (2016)Google Scholar
  9. 9.
    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)Google Scholar
  10. 10.
  11. 11.
    CS50 IDE. Accessed 25 Aug 2019
  12. 12.
    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)Google Scholar
  13. 13.
    Traxler, J.: Distance learning – predictions and possibilities. Educ. Sci. 8(35), 1–13 (2018)Google Scholar
  14. 14.
    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)Google Scholar
  15. 15.
    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)Google Scholar

Copyright information

© Springer Nature Switzerland AG 2020

Authors and Affiliations

  1. 1.Dniprovsk State Technical UniversityKamyanskeUkraine

Personalised recommendations