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
What is the archtetype/instance pattern? The archetype/instance pattern happens when one entity tracks occurrences of another entity. A common example is the relationship among

Define Partial Key and Primary Key A partial key, also known as discriminator, is the set of attributes which can uniquely identify weak entities that are related to similar o

What are the three data anomalies that are likely to occur as a result of data redundancy?  Can data redundancy be completely eliminated in database approach?  Why or why not? A

What is system catalog or catalog relation? How is better known as? A RDBMS maintains a explanation of all the data that it contains, information about every relation and index

What are the kinds of Strings?  -A binary string in MySQL is one that MySQL treats as case sensitive in comparisons. -A non binary string in MySQL is one that MySQL does'nt

Describe Dynamic Model. The dynamic model specifies allowable sequences of changes to the objects from an object model. It contains event trace diagrams describing scenarios. A

Question: (a) What are the challenges in the development of Large Scale Distributed Real Systems? (b) What is backward engineering and forward engineering in a design packa

Explain algorithm of ER To Relational Mapping ? ER-to-Relational Mapping Algorithm: 1) Step 1: Mapping of regular entity types: For each strong entity type E, form a relatio

Log based recovery: Let us first describe the term transaction log in the context of DBMS. A transaction log is a record in DBMS that remains track of all the transactions of a dat

What is the difference between the function module and a normal ABAP/4 subroutine? In contrast to normal subroutines function modules have uniquely exact interface.  Declaring da