About this paper

Appears in:
Pages: 921-926
Publication year: 2018
ISBN: 978-84-09-05948-5
ISSN: 2340-1095
doi: 10.21125/iceri.2018.1218

Conference name: 11th annual International Conference of Education, Research and Innovation
Dates: 12-14 November, 2018
Location: Seville, Spain

SELECTION OF OPEN SOURCE DATABASE DESIGN TOOLS FOR USE IN COMPUTER SCIENCE TEACHING

E. Milosz, M. Juszczyk

Lublin University of Technology (POLAND)
One of the specialist courses in the process of educating Computer Science (CS) students is the Database. This is a very important course, because a significant number of graduates of the CS studies will develop and maintain database applications. There are many tools that support the design, implementation, documentation and management of databases. Due to their availability, they are quite often used in higher education. There are many tools on the market, either commercial or open source. The open source tools are preferred by both lecturers and students.

The article presents the process of selecting the most convenient open source tools for database design to support the didactic process of CS students. In the selection process, the following research hypothesis was made:
In the didactic process, the most useful tool for supporting database design is the open source tool MySQL Workbench.
In the selection process, two research methods were used: a scientific experiment and a multi-criteria comparative analysis.

The object of the research was five different open source tools: MySQL Workbench, Valentina Studio, dbForge Studio for MySQL, SQLyog Community and Heidi SQL. The scientific experiment was conducted by five CS students, who have made the database model in using the selected five tools and assessed the process of its implementation. As a research tool, an exemplary database model was prepared containing twelve interrelated tables and a questionnaire for the process of model implementation. The comparative analysis was based on selected objective criteria (file size, functionality of the tool) and subjective criteria (experiment data: ease of installation, usability of the interface, convenience of use, implementation time). The gained data was used in the multicriteria analysis, which allowed the defined criteria to be reduced to the summary one and verify the research hypothesis. The results of the research may be useful to students and lecturers in the higher education didactics process.
@InProceedings{MILOSZ2018SEL,
author = {Milosz, E. and Juszczyk, M.},
title = {SELECTION OF OPEN SOURCE DATABASE DESIGN TOOLS FOR USE IN COMPUTER SCIENCE TEACHING},
series = {11th annual International Conference of Education, Research and Innovation},
booktitle = {ICERI2018 Proceedings},
isbn = {978-84-09-05948-5},
issn = {2340-1095},
doi = {10.21125/iceri.2018.1218},
url = {http://dx.doi.org/10.21125/iceri.2018.1218},
publisher = {IATED},
location = {Seville, Spain},
month = {12-14 November, 2018},
year = {2018},
pages = {921-926}}
TY - CONF
AU - E. Milosz AU - M. Juszczyk
TI - SELECTION OF OPEN SOURCE DATABASE DESIGN TOOLS FOR USE IN COMPUTER SCIENCE TEACHING
SN - 978-84-09-05948-5/2340-1095
DO - 10.21125/iceri.2018.1218
PY - 2018
Y1 - 12-14 November, 2018
CI - Seville, Spain
JO - 11th annual International Conference of Education, Research and Innovation
JA - ICERI2018 Proceedings
SP - 921
EP - 926
ER -
E. Milosz, M. Juszczyk (2018) SELECTION OF OPEN SOURCE DATABASE DESIGN TOOLS FOR USE IN COMPUTER SCIENCE TEACHING, ICERI2018 Proceedings, pp. 921-926.
User:
Pass: