Constraints

Keeping invalid values out of the database is easier than attempting to fix the data later. Fixing the data is often called data cleaning. Foreign keys were an easy way to make sure references were valid. Constraints can do the same thing for individual field values.

CheckConstraint

For the sake of discussion, suppose we want to prevent authors who were born in the future. So the birth_year field of the BirthYear class should be constrained to be less than or equal to 2020. This constraint is added as ...