Experimental Study on the Effectiveness of a Teaching Approach Using Barker or Bachman Notation for Conceptual Database Design

Aida Kamišalić1, Marjan Heričko1, Tatjana Welzer1 and Muhamed Turkanović1

  1. University of Maribor, Faculty of Electrical Engineering and Computer Science
    Koroška cesta 46, 2000 Maribor, Slovenia
    {aida.kamisalic, marjan.hericko, tatjana.welzer, muhamed.turkanovic}@um.si

Abstract

Relational databases are one of the pillars of information systems and as a consequence conceptual and logical design can be seen as the foundation of almost every application regardless of the platform. Nevertheless, little research has been done so far on the effectiveness of teaching approaches to database basic concepts and design. This paper introduces a multi-level experimental study developed to examine the effectiveness of learning database fundamentals, depending on the notation used for conceptual design. The main experiment was carried out at a higher education institution. We developed different experimental instruments to evaluate the effectiveness of a teaching approach using Barker or Bachman notation for conceptual database design. In contrast to Barker notation, Bachman notation incorporates elements of logical design (i.e. foreign keys) in the conceptual design level. Students’ achievements were examined with regard to influencing factors throughout the learning process. Introducing the Bachman notation and a manual transformation from a conceptual into a logical data model, could increase students’ understanding of conceptual, logical and relational data model concepts. We found that the notation used during the learning process has an impact on students’ achievements. Moreover, students achieved better results when solving tasks presented with a notation that incorporates elements of logical design into the conceptual level. Finally, we required the use of manual transformation from a conceptual into a logical data model and the results confirmed an increase in students’ understanding.

Key words

entity relationship models, modeling notations, conceptual design, logical design, foreign key, database design learning, Barker, Bachman

Digital Object Identifier (DOI)

https://doi.org/10.2298/CSIS180322008K

Publication information

Volume 15, Issue 2 (June 2018)
Year of Publication: 2018
ISSN: 2406-1018 (Online)
Publisher: ComSIS Consortium

Full text

DownloadAvailable in PDF
Portable Document Format

How to cite

Kamišalić, A., Heričko, M., Welzer, T., Turkanović, M.: Experimental Study on the Effectiveness of a Teaching Approach Using Barker or Bachman Notation for Conceptual Database Design. Computer Science and Information Systems, Vol. 15, No. 2. (2018), https://doi.org/10.2298/CSIS180322008K