CameraIcon
CameraIcon
SearchIcon
MyQuestionIcon
MyQuestionIcon
1
You visited us 1 times! Enjoying our articles? Unlock Full Access!
Question

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

Open in App
Solution

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.


flag
Suggest Corrections
thumbs-up
1
Join BYJU'S Learning Program
similar_icon
Related Videos
thumbnail
lock
Database Structuring
ACCOUNTANCY
Watch in App
Join BYJU'S Learning Program
CrossIcon