关系数据库的数据完整性（Data integrity of relational databases）.docVIP

关系数据库的数据完整性（Data integrity of relational databases） Integrity constraints in 1 SQL SQL takes various integrity constraints as part of the database schema definition. It not only effectively prevents the accidental damage to the database, improves the efficiency of integrity detection, but also reduces the burden of programmers. SQL sets up and detects three different integrity constraints and implements them in different ways. The following are introduced. 3.1.1 entity integrity and master code Entity integrity specifies that no property of a master code is null, because entities and links are distinguishable in a conceptual model, and they are uniquely marked by code. If the attribute value of the master code can be null, it means that there is an entity that does not uniquely identify the code in the conceptual model. This is clearly inconsistent. So, how do you ensure entity integrity? In SQL, entity integrity is achieved by primary code. Once a property or property group is defined as the master code, each property of the master code cannot be null, and the two tuples of the same main code value cannot be present in the relationship. The definition of the primary code is implemented in the Create Table statement using the Primary Key keyword. There are two ways: A) add the keyword Primary Key after the property definition; B) add an additional clause defining the main code after the property table definition: Primary Key ( main code property ) Explain： 2 if the master code consists of only one attribute, the above two methods can be defined. If it is composed of two or more attributes, the above second methods can only be defined by the above two methods. 2 for the candidate code description method, you can use Unique to illustrate the value of this property can not be repeated. The use of Unique is similar to that of Primary Key. 2 there is only one master key definition in a table, but there are multiple Unique descriptions. In 2, SQL does not force the maste