47.1k views
3 votes
Can the constraint checks be executed efficiently when updates are applied to the database?

User Cfranklin
by
4.7k points

1 Answer

5 votes

Answer:

In the database system, the constraint are basically used for enforced the referential integrity in the system more efficiently.

It maintain the data logically in the system and it basically prevent the incomplete information and data from residing the database system. Constraints are mainly represent the data columns in the table in which the rules are get enforced in the system.

There are mainly two types of constraints in the database system that are as follows:

  • Key Constraints
  • Foreign key constraints

User Torrey
by
4.9k points