Defect of Relational Data Normalization Theory 5NF

Abstract

Abstract: In this paper the nature of the join dependency is analyzed. and its causing conditions and processing method are presented. It showsthat the join dependency often appears in the relationship of entity-conjoin.However.the relationship cannot be replaced by a set of 5NF.The method presented in this paper must be used .otherwise the information will be lost .

摘要： 剖析了连接依赖的本质，并提出其产生的条件和处理的方法。指出连接依赖出现在联系关系中，且并不少见，但不能以一组5NF去替代原关系，否则会丢失信息，必须采用该文提出的方法去处理。

关键词: 数据库, 连接依赖, 范式, 关系

CLC Number:

TP311

Chen Youjun. Defect of Relational Data Normalization Theory 5NF[J]. , 1998, 24(11): 3-6.

陈友君. 关系数据规范理论第五范式的缺陷[J]. , 1998, 24(11): 3-6.

[1]	WANG Ting, LIU Mingming. Improved PBFT Consensus Algorithm Based on Node Bidding and Reputation Mechanism [J]. Computer Engineering, 2026, 52(11): 308-318.
[2]	ZHANG Ru, SUN Weifeng, ZHANG Peng, ZHANG Chao, DAI Yongshou. Plug-in-based Electromagnetic Signal Analysis Software Architecture Design Method [J]. Computer Engineering, 2026, 52(11): 435-443.
[3]	DING Lin, YANG Yang, GUO Caili, GUO Jianzhang, LI Zheng. A Text-to-SQL Method Based on Fine-Tuning Large Language Models with Table Creation Information [J]. Computer Engineering, 2026, 52(11): 402-411.
[4]	LI Xue, WANG Yawen, ZHANG Qianjin. Automatic Naming of Source Code Based on Information Retrieval [J]. Computer Engineering, 2024, 50(6): 304-310.
[5]	LI Yakang, CHEN Gang. Automated Selection for Physical Models of Small-Angle Neutron Scattering [J]. Computer Engineering, 2024, 50(6): 56-64.
[6]	XUAN Yizhao, ZHAO Hongwu, JIN Yu. A Dual-Chain-Based Consensus Mechanism for Blockchain [J]. Computer Engineering, 2024, 50(5): 139-148.
[7]	JIANG Huizhen, SUN Yanchun, HUANG Gang. GitHub Hierarchical Learning and Retrieval Service Based on Knowledge Graphs [J]. Computer Engineering, 2024, 50(5): 16-25.
[8]	WANG Ziheng, JIANG Zhongding. Enhanced Desktop Display System Supporting Multi-Modal Interaction [J]. Computer Engineering, 2022, 48(7): 177-188.
[9]	XU Fu, HAO Liang, CHEN Feixiang, LI Dongmei, CUI Xiaohui. Program Comparison Analysis Method for Open Source Code Reuse [J]. Computer Engineering, 2020, 46(1): 222-228,242.
[10]	ZHANG Wanying, CAO Xiaomei, CHEN Wei. Solution for Environment Interaction Problem in Whitebox Fuzz Testing [J]. Computer Engineering, 2020, 46(1): 216-221.
[11]	ZHANG Shutao, TAN Haibo, CHEN Liangfeng, Lü Bo. An Efficient Load Balance Strategy for Distributed Crawler System [J]. Computer Engineering, 2019, 45(11): 62-67.
[12]	YANG Zhenglong, GAO Jianhua. User-oriented Performance Analysis of Search Engine Based on Metamorphic Test [J]. Computer Engineering, 2019, 45(10): 52-56,63.
[13]	WANG Chenxu, WANG Xiaochen, YU Dunhui, WU Shan. Software Crowdsourcing Task Decomposition Algorithm Based on Dynamic Decoupling [J]. Computer Engineering, 2019, 45(8): 120-124,134.
[14]	WANG Chenxu, YU Dunhui, ZHANG Wanshan, ZHANG Xingsheng. Module Allocation Algorithm for Software Crowdsourcing Based on Core Degree Sorting [J]. Computer Engineering, 2019, 45(7): 66-70.
[15]	NI Hong, LIU Xin. Multi-Core optimization technology of unstructured grid based on Sunway TaihuLight [J]. Computer Engineering, 2019, 45(6): 45-51.

Please choose a citation manager

Content to export