官术网_书友最值得收藏!

Constraint

The relational model defines many constraints in order to control data integrity, redundancy, and validity:

  • Redundancy: Duplicate tuples are not allowed in the relation.
  • Validity: Domain constraints control data validity.
  • Integrity: The relations within a single database are linked to each other. An action on a relation such as updating or deleting a tuple might leave the other relations in an invalid state.

We could classify the constraints in a relational database roughly into two categories:

  • Inherited constraints from the relational model: Domain integrity, entity integrity, and referential integrity constraints.
  • Semantic constraint, business rules, and application specific constraints: These constraints cannot be expressed explicitly by the relational model. However, with the introduction of procedural SQL languages such as PL/pgsql for PostgreSQL, relational databases can also be used to model these constraints.
主站蜘蛛池模板: 临桂县| 芷江| 南川市| 工布江达县| 肇源县| 郓城县| 津南区| 万荣县| 五台县| 随州市| 霍林郭勒市| 房山区| 田阳县| 辽宁省| 扶风县| 长春市| 金沙县| 遵化市| 石门县| 调兵山市| 连州市| 本溪市| 扬州市| 临武县| 潮安县| 江门市| 淳化县| 通江县| 临潭县| 兰州市| 嘉峪关市| 错那县| 莫力| 元阳县| 都兰县| 芒康县| 昌吉市| 合水县| 宝兴县| 江陵县| 金门县|