Podpora výučby konceptuálneho modelovania dát

Abstract

Conceptual data modeling is an important part of database system design. During its teaching, students learn to create UML class diagrams and transform them into relational schemas, which requires regular practice. However, they usually have access to only a limited number of assignments and often lack the opportunity to independently verify the correctness of their solutions. The aim of this thesis was to design and implement a web application supporting the teaching of UML modeling and the transformation of conceptual models into relational models. The result is the UMLearn application, which allows teachers to create exercises and define reference UML diagrams for them. It provides students with a UML class diagram editor and a relational model editor, where they solve assignments and receive automated feedback that helps them identify errors and gradually reach the correct solution.

Konceptua ́lnı ́ modelova ́nı ́ dat pr ̌edstavuje du ̊lez ̌itou souc ̌a 'st na ́vrhu databa ́zovy ́ch syste ́mu ̊. V ra ́mci jeho vy ́uky se studenti uc ̌ı ́ vytva ́r ̌et UML class diagramy a transformovat je do relac ̌nı ́ch sche ́mat, pr ̌ic ̌emz ̌ osvojenı ́ te ̌chto dovednostı ́ vyz ̌aduje pravidelne ́ procvic ̌ova ́nı ́. V praxi vs ̌ak majı ́ studenti k dispozici jen omezeny ́ poc ̌et zada ́nı ́ a c ̌asto jim chybı ́ moz ̌nost samostatne ̌ si ove ̌r ̌it spra ́vnost sve ́ho r ̌es ̌enı ́. Cı ́lem pra ́ce bylo navrhnout a implementovat webovou aplikaci podporujı ́cı ́ vy ́uku UML modelova ́nı ́ a pr ̌evodu konceptua ́lnı ́ch modelu ̊ do relac ̌nı ́ho modelu. Vy 'sledkem je aplikace UMLearn, ktera ́ umoz ̌n ̌uje vyuc ̌ujı ́cı ́m vytva ́r ̌et cvic ̌enı ́ a definovat k nim referenc ̌nı ́ UML diagramy. Studentu ̊m poskytuje editor UML class diagramu ̊ a editor relac ̌nı ́ho modelu, ve ktery ́ch r ̌es ̌ı ́ zada ́nı ́ a zı 'ska ́vajı ́ automatickou zpe ̌tnou vazbu. Ta jim poma ́ha ́ identifikovat chyby a postupne ̌ dospe ̌t ke spra ́vne ́mu r ̌es ̌enı ́.