数据库设计12条准则.docxVIP

 HYPERLINK /xrt95050/article/details/6012537 \o 数据库设计12条准则 数据库设计12条准则 Rule 1: The Information Rule All data should be presented to the user in table form. Last weeks newsletter already discussed the basics of this rule. 1，信息准则 关系数据库中的所有信息都应在逻辑层上用表中的值显式的表示。 Rule 2: Guaranteed Access Rule All data should be accessible without ambiguity. This can be accomplished through a combination of the table name, primary key, and column name. 2，保证访问准则 依于表名，主键和列名，保证能以逻辑方式访问数据库中的每个数据项。 Rule 3: Systematic Treatment of Null Values A field should be allowed to remain empty. This involves the support of a nul