Detection and correction of inconsistencies of cyclical references in database logical schemas

Abstract

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.

Keywords

• entity-relationship model
• conceptual schema
• logical schema
• database inconsistencies
• referential integrity constraints