Proponent/Claimant

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.

Name of Research Journal

IEEE Xplore

Volume and Issue No.

ISBN:978-1-7281-7434-1

Date/Year of Publication

2020

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.