Dynamic Referential Integrity Model for Relational Databases

A Relational Database Model (BDR) is a database organization and management model consisting of storing data in tables made up of rows and columns. The relationship and integrity of the data between the different entities can be achieved by implementing the concept of Referential Integrity, which consists of the fact that the foreign key of a table must always refer to a valid row of the table to which reference is made. A BDR model will always have a number of at least two tables that are interrelated with each other through a primary key and a foreign key. A problem that often occurs in the design and implementation of a BDR is the necessary incorporation of new tables that are essential due to changes in user requirements, in turn implying that these new data entities implement referential integrity to ensure the values of specific attributes of other tables, for example; a predefined catalog of information. In this case, the modification to the Database (BD) and to the applications of interface with the end user would necessarily require those persons who fulfill the functions of design and administration of the databases, including the modification in the code of the user interfaces and the system backend. As a result of a research process, a Dynamic Referential Integrity Model is proposed, consisting of a solution that allows the inclusion of new data entities (catalogs) from which the concept of referential integrity can be applied dynamically, at the Database level, for new attributes.