Automated evaluation of correctness and quality of database conceptual schemas
RIS ID
133620
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 Details
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.