A novel ER model to relational model transformation algorithm for semantically clear high quality database design

TL;DR

This paper introduces a new transformation algorithm from ER models to relational models, aiming to improve database design quality by addressing existing transformation limitations and validating the resulting database.

Contribution

It proposes a novel ER-to-relational transformation algorithm based on a modified ER notation for clearer, high-quality database design.

Findings

The algorithm effectively transforms ER models into relational models.

Application to a real-world example demonstrates practical utility.

Validation methods ensure the accuracy of the resulting database.

Abstract

Conceptual modelling using the entity relationship (ER) model has been widely used for database design for a long period of time. However, studies indicate that creating a satisfactory relational model representation from an ER model is uncertain due to the insufficiencies both in the transformation methods used and in the relational model itself. In an effort to solve the issue the original ER notation has been modified, and accordingly, a new transformation algorithm has been developed. This paper presents the proposed transformation algorithm. Using a real world example it shows how the algorithm can be applied in practice. The paper also discusses how to validate the resulted database and reclaim the information that it represents.