Mapping Considerations in the Design of Schemas for the Relational Model

TLDR: A new design methodology is proposed that constructs the conceptual schema in such a way that overlappings among external schemas are reflected, and if transitivity is produced, then no such function is possible and a new technique is introduced to handle this special case.

Abstract: The typical design process for the relational database model develops the conceptual schema and each of the external schemas separately and independently from each other. This paper proposes a new design methodology that constructs the conceptual schema in such a way that overlappings among external schemas are reflected. If the overlappings of external schemas do not produce transitivity at the conceptual level, then with our design method, the relations in the external schemas can be realized as a join over independent components. Thus, a one-to-one function can be defined for the mapping between tuples in the external schemas to tuples in the conceptual schema. If transitivity is produced, then we show that no such function is possible and a new technique is introduced to handle this special case.