Schema transformation - a quality perspective

In this paper we give new definitions of functional dependency, a key, a key attribute, and a non-key attribute at conceptual level and provide rules to implement these at conceptual level. We also propose two quality metrics, completeness index and normalization index, to measure the quality of the conceptual model that results after applying the proposed rules. We apply these rules on a hypothetical case and measure the quality of the transformed schema. It is observed that by applying our definitions and rules the quality of transformed schema fractionally improves completeness index up to 50% and normalization index up to 81%.