Discuss the different types of update operations in relation to the integrity constraints which must be satisfied in a relational database model.

The following are the different types of update operations in relation to the integrity constraints which must be satisfied in a relational database model.

  1. Insert- This implies addition of a new tuple in the existing relation. This operation can violate any of the four integrity constraints.

  2. Delete- This operation is used to remove an existing tuple from the relation. This operation can violate Referential Integrity Constraints, if the removed tuple is reference by foreign key from other tuples in the database.

  3. Modify- This operation is used to make changes in the existing values of the records in a data table. Generally, this operation does not lead to any violation problems, if the modification is done except on Primary key and on Foreign keys.

Hence, we can conclude that after applying these update operations, integrity constraints are specified on the relational database schema.

  • 0
What are you looking for?