【摘要】 关系型数据库的范式理论中的1NF是目前唯一无法严格定义的范式,而其他所有范式均以符合1NF为前提。国内教育领域和软件行业,对关系型数据库设计的范式理论中的第一范式的理解和运用普遍存在偏差,全面正确理解并满足1NF对设计高性能的数据库应用程序至关重要。首先给出对1NF多层面的理解并给出其有效性的一般论证,然后通过一个实例对符合1NF和不符合1NF两种设计进行各个方面的完整比较,进一步论证全面理解1NF,并使数据库设计真正符合1NF对完成更高性能的设计具有重要意义。更多还原

【Abstract】 1NF is the only one that cannot be strictly defined in normal form theories of the relational database though all other normal forms are based on 1NF.In domestic education field and the software industry,there are general deviations in comprehension and application of 1NF.It is extremely important to understand comprehensively and correctly the 1NF and to satisfy it in order to design the high performance database application.First,we present the comprehension of 1NF on multi-layer and the general proof of its effectiveness,then an instance is used to carry out the complete comparison for two designs consistent and inconsistent with 1NF from every aspects.It has the significance to further demonstrate and comprehensively understand 1NF and enable the database design really in compliance with 1NF for achieving the design with higher performance.更多还原