高级检索

    空值环境下的完全函数依赖和部分依赖

    Full and Part Functional Dependencies Under the Null Values Environment

    • 摘要: 本文给出了空值环境下的完全函数依赖的弱保持、强保持及部分函数依赖。提出并证明了不完全关系模式若不满足空值环境下的完全函数依赖的弱保持,则它的任意一个完备一定不是非空值环境下的完全函数依赖;若满足空值环境下的完全函数依赖强保持,则它的任意一个完备,一定是非空值环境下的完全函数依赖。本文还给出了判别不完全关系满足空值环境下的完全函数依赖强、弱保持的算法。为空值环境下的模式分解奠定了基础。

       

      Abstract: The weak and strong holds of Full Functional Dependencies and Part Functional Dependencies under the null values environment are proposed in this paper. It is proved that for relational schema with null values, if it does not satisfy the weak hold of Full Functional Dependencies under the null values environment, then its any complete is not Full Functional Dependencies under the null values environment: if it satisfies the strong hold of Full Functional Dependencies under the null values environment then its any complete must be Full Functional Dependencie, under the null values environment Also given is a, algorithm which judges that a relation with null value, satisfies the strong and weak holds of Full Functional Dependencies. This paper lays clown the foundation for schema decomposition under the null values environment.

       

    /

    返回文章
    返回