Sunday, January 9, 2011

what is integrity constraints in sql server.

the integity constraints are that changes made to the database by authorized users do not result in a loss of data consistency.

thus, the integrity constraints guards against the accidental damage to the database.

example of the integrity constraints are as follow.

(1) an account balance cannot be null.
(2) no two accounts can have the same account number
(3) every account number in the depositor relation must have the matching account number in the account relation.

No comments:

Post a Comment