Modifications to Smith’s method for deriving normalised relations from a functional dependency diagram
Smith’s method is a formal technique for deriving a set of normalised relations from a functional dependency diagram (FDD). Smith’s original rules for deriving these relations are incomplete, as they do not fully address the issue of determining the foreign key links between relations. In addition, one of the rules for deriving foreign keys can produce incorrect results, while the other rule is difficult to automate. In this paper are described solutions these issues.
Publisher: University of Otago
Series number: 99/23
Keywords: normalisation; functional dependencies; relational model; data model translation
Research Type: Discussion Paper