| 基于矩阵关系模式到2NF、3NF(保FD)的分解 |
| |
| 引用本文： | 刘永山.基于矩阵关系模式到2NF、3NF(保FD)的分解[J].燕山大学学报,2000,24(3):232-234. |
| |
| 作者姓名： | 刘永山 |
| |
| 作者单位： | 燕山大学信息科学与工程学院,秦皇岛,066004 |
| |
| 摘 要： | 利用矩阵工具，研究了到２ＮＦ、３ＮＦ（保持函数依赖）的模式分解。给出了判定２ＮＦ、３ＮＦ的若干定理，并提出矩阵行相容、矩阵包含等定义。给出了基于矩阵到２ＮＦ、３ＮＦ（保ＦＤ）的模式分解算法。
|
| 关 键 词： | 矩阵 2NF 3NF 模式分解 关系数据库 |
| 修稿时间： | 1999-11-09 |
Decompositions of Relational Schema to 2NF or 3NF (Preservation of FD's) Based on Matrix |
| |
| Liu Yongshan.Decompositions of Relational Schema to 2NF or 3NF (Preservation of FD''''s) Based on Matrix[J].Journal of Yanshan University,2000,24(3):232-234. |
| |
| Authors: | Liu Yongshan |
| |
| Institution: | Liu Yongshan
(The College of Information Science and Engineering, Yanshan University, Qinhuangdao 066004) |
| |
| Abstract: | The decompositions of relational schema to 2NF or 3NF with preservation of FD's are Studied based on matrix, some theorems of juaging 2NF or 3NF are given, and some new definitions such as the compatibility of row, matrix containing and matrix merging are Presented. The algorithms for decompositions of relational schema to 2NF or 3NF based on matrix are given. |
| |
| Keywords: | matrix 2NF 3NF decomposition |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
