Integrity Rules and Constraints
Completion requirements
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/
This work is licensed under a Creative Commons Attribution 4.0 License.