Domain integrity is the validity of entries for a given column. You can enforce domain integrity by restricting the type (through data types), the format (through CHECK constraints and rules), or the range of possible values (through FOREIGN KEY constraints, CHECK constraints, DEFAULT definitions, NOT NULL definitions, and rules).
Example, if we have an emp_rating column which is intended to have values ranging from 1 to 10,the database should not allow the value except from 0-10.
No comments:
Post a Comment