Skip to main content
placeholder image

Automated evaluation of correctness and quality of database conceptual schemas

Conference Paper


Abstract


  • A typical database design methodology based on the conceptual modelling is a standard component of many introductory database courses. Evaluation of correctness and quality of conceptual schemas created by the course participants is always a long and tedious task due the large number of solutions and complexity of the solutions. This work describes a new approach to automated evaluation of correctness and quality of database conceptual schemas. We propose a new notation based on simplified UML class diagrams as a way for unified representation of conceptual schemas and we describe a software tool that transforms the different notations into a common one. Many of simple syntactical mistakes can be detected and reported at a transformation stage. Then, we show how to compare the transformed conceptual schemas with a template solution provided by a course instructor and how to list the discrepancies found in thedesigns.

Publication Date


  • 2018

Citation


  • Getta, J. R. (2018). Automated evaluation of correctness and quality of database conceptual schemas. BDET 2018: Proceedings of the 2018 International Conference on Big Data Engineering and Technology (pp. 20-25). New York, United States: ACM.

Scopus Eid


  • 2-s2.0-85061548291

Ro Metadata Url


  • http://ro.uow.edu.au/eispapers1/2331

Start Page


  • 20

End Page


  • 25

Place Of Publication


  • New York, United States

Abstract


  • A typical database design methodology based on the conceptual modelling is a standard component of many introductory database courses. Evaluation of correctness and quality of conceptual schemas created by the course participants is always a long and tedious task due the large number of solutions and complexity of the solutions. This work describes a new approach to automated evaluation of correctness and quality of database conceptual schemas. We propose a new notation based on simplified UML class diagrams as a way for unified representation of conceptual schemas and we describe a software tool that transforms the different notations into a common one. Many of simple syntactical mistakes can be detected and reported at a transformation stage. Then, we show how to compare the transformed conceptual schemas with a template solution provided by a course instructor and how to list the discrepancies found in thedesigns.

Publication Date


  • 2018

Citation


  • Getta, J. R. (2018). Automated evaluation of correctness and quality of database conceptual schemas. BDET 2018: Proceedings of the 2018 International Conference on Big Data Engineering and Technology (pp. 20-25). New York, United States: ACM.

Scopus Eid


  • 2-s2.0-85061548291

Ro Metadata Url


  • http://ro.uow.edu.au/eispapers1/2331

Start Page


  • 20

End Page


  • 25

Place Of Publication


  • New York, United States