Update operations in dbms - insert operation, Database Management System

Update Operations and Dealing with Constraint Violations

There are three basic operations to be executes on relations:

  • Insertion
  • Deletion
  • Update

The INSERT Operation:

The insert operation permits us to insert a new tuple in a relation. When we try to insert a new record, then any of the following four types of constraints can be violated:

 

  • Key constraint: If the value of the key attribute in new tuple t is the similar as in the existing tuple in relation R.
  • Domain constraint: If the value given to an attribute lies outside the domain of that attribute.
  • Referential Integrity constraint: If the value of the foreign key in t refers to a tuple that doesn't show in the referenced relation.

 • Entity Integrity constraint: If the primary key attribute value of new tuple t is given as null.

Posted Date: 3/6/2013 5:34:18 AM | Location : United States







Related Discussions:- Update operations in dbms - insert operation, Assignment Help, Ask Question on Update operations in dbms - insert operation, Get Answer, Expert's Help, Update operations in dbms - insert operation Discussions

Write discussion on Update operations in dbms - insert operation
Your posts are moderated
Related Questions

How do you find the final model after iterative analysis? Why is iterative analysis of any of the problem needed? The final model serves as the base for system architectur

What is OOM? Object oriented modeling is an approach by which modeling of systems is done by visualizing the system based on real world concepts. Object oriented modeling does

explain in detail about time stamp orderting/

Chapter 1 - Profile for the Organization You have to select an organization of your choice and assume that you work for that organization. Now you must prepare a brief profile of t

File Organisation In Dbms Introduction Databases are used to store information. Usually, the principal operations we have to perform on database are those relating to:

Illustrate about the advanced object design Advanced object design is a complex task. The objects discovered through analysis serve as a skeleton of design. The operations reco

Strict 2PL :Though, this basic 2PL suffers from the trouble that it can result into loss of isolation / atomic property of transaction as theoretically speaking once a lock is rele

I need solution of the question posted at http://www.expertsmind.com/questions/sql-query-for-testing-triggers-and-stored-procedures-30140149.aspx

What is relationship? Give examples A relationship is an association between several entities. Example: A depositor relationship associates a customer with every account tha