EnORS: An Enhanced Object Relationship Schema

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.