The following are the update operations in a relation base model. The three basic types of updates are as given below:
1. insert:
This operation is performed to add a new tuple in a relation, eg. an attempt to add another record of an account with data values corresponding to Code, Name and its Type to Accounts relation shall be made by performing insert operation. The insert operation is capable of violating any of the four constraints.
2. Delete:
This operation is carried out to remove a tuple from a relation. A particular data record from a table can be removed by performing such a operation. The delete operation can violate only referential integrity, if tuple being removed is referred by foreign key from other tuples in the database.
3. Modify:
The operation aims at causing a change in the values of some attribute in existing tuples. This is useful in modifying existing values of an accounting record in a data table. Usually, this operation does not cause problems provided the modification is directed on neither primary key or foreign key.
Whenever applied, these operations must enforce integrity constraints specified on relational database schema. Retrieval operation on Relational Data Model does not cause violation of any integrity constraints
