Proponent(s)

Ritchell S. Villafuerte

Abstract

The data model is a primary factor in creating databases. Moreover, it also shows the connection between different data features involved in the information system. A system that has a robust database structure leads to a strong information system. Hence, a poor database structure may result in a half-baked approach. However, creating a good data model is confusing and complicated. This study focuses on creating a more improved database structure that is simple and less complex. This is done by integrating the object-relational schema (ORS) proposed by Sinha and the enhanced relational model (ERM) introduced by Villari. Formulating a new structure results in an Enhanced Object Relationship Scheme (EnORS). The improved diagram illustrates not only the entity objects involved in a database but also the data objects that are interrelated within the information system. This new approach was implemented in creating an enhanced object-relational schema database structure in the Health Center Information System. It shows a more simplified process in creating an efficient database. However, this study only limits to generate the improved object-relational schema. More extensive research can be conducted to test its reliability as compared with other existing methodologies.

Publication Date

2020

Name of Research Journal

IEEE Xplore

Volume and Issue No.

ISBN:978-1-7281-7434-1

Citation

Villafuerte, R. S., Brosas, D. G., Obediencia, D. C., & Paragas, J. R. (2020, October). EnORS: An Enhanced Object Relationship Schema. In 2020 Third International Conference on Vocational Education and Electrical Engineering (ICVEE) (pp. 1-5). IEEE.