基于Visual FoxPro的数据完整性剖析

Data Integrity Analysis based on Visual FoxPro

主要对基于Visual FoxPro的关系型数据库中的数据完整性进行分析和应用。在关系数据库中,为保证数据的完整性,需要从关系的实体完整性、域完整性、参照完整性及触发器等几个方面进行约束和限制,即要设置主关键字、字段的有效性规则和关系表间的数据操作约束,从而保证数据的正确性和有效性,这也是关系型数据库特有的性能。

This article mainly to carries on the analysis and the application based on the Visual FoxPro relations database＇s data integrity.In the relational database,it needs to carry on the restraint and the limit from the relational entity integrity,the territory integrity,the reference integrity and the trigger so on for the guarantee data＇s integrity,namely it must establish the main key words,the field valid rule and the relational table data manipulation restraint,Thus the data＇s accuracy and the validity is guaranteed,It＇s also the relations database unique performance.