Integrity Rules and Constraints

Read this chapter and pay attention to the section on business rules and how they are obtained from users. Take note of the business rule examples and answer the exercises at the end of the chapter.

Integrity Rules and Constraints

Constraints are a very important feature in a relational model. In fact, the relational model supports the well-defined theory of constraints on attributes or tables. Constraints are useful because they allow a designer to specify the semantics of data in the database. Constraints are the rules that force DBMSs to check that data satisfies the semantics.

Source: Adrienne Watt & Nelson Eng, https://opentextbc.ca/dbdesign01/chapter/chapter-9-integrity-rules-and-constraints/
Creative Commons License This work is licensed under a Creative Commons Attribution 4.0 License.