Revista Facultad de Ingeniería Universidad de Antioquia
versão impressa ISSN 0120-6230
GARCIA, Carlos; RODRIGUEZ, Abel; CABRERA, Norma e GONZALEZ, Luisa. Detection and correction of inconsistencies of cyclical references in database logical schemas. Rev.fac.ing.univ. Antioquia [online]. 2010, n.55, pp. 165-173. ISSN 0120-6230.
The transformations of conceptual schemes into logical schemes carried out by database design tools may result in logical schemes that present some kind of inconsistence and therefore the physical schemes will have implementation problems. This work presents an algorithm that allows detecting and correcting these inconsistencies in the logical schema. This algorithm can be implemented in a database design tool.
Palavras-chave : entity-relationship model; conceptual schema; logical schema; database inconsistencies; referential integrity constraints.