A Method for Synthesizing Normal Form Database Schemes Under Functional and Inclusion Dependencies

Bibliographic Information

Other Title
  • 関数従属性と包含従属性の相互作用をも対象とした場合の正規形データベーススキーム作成手法

Search this article

Description

There are many synthesizing methods for normal form database schemes from the universe of attributes and the set of functional dependencies (FD) on it. But existence assumption of universal relation is too restrictive to allow the model represent the real world sufficiently. Therefore we adopt a method capturing real world with database scheme consist of relational schemes, FD sets on them and inclusion dependencies(IND)sets between them. This paper proposes a derivation method to determine FD-covering on each relation scheme under not only FD's proper derivation axioms but also pullback rule that is one of representative derivation axiom of interaction between FD and IND sets. This method transform database schemes initially given to normal form database schemes. The characters of proposed methods are that it represent database scheme initially given with the model similar to Hypergraph and derivation of FD and that normalization of database scheme is executed by transformations on this model.

Journal

  • IPSJ SIG Notes

    IPSJ SIG Notes 93 (98), 9-18, 1993-11-09

    Information Processing Society of Japan (IPSJ)

Details 詳細情報について

  • CRID
    1571698602152732672
  • NII Article ID
    110002934096
  • NII Book ID
    AN10114171
  • Text Lang
    ja
  • Data Source
    • CiNii Articles

Report a problem

Back to top