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 need of a log in dbms

Fundamentals of Database Management 1. Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? 2. With a necess

What do you mean through integrity constraints? Integrity Constraints -An integrity constraint is a condition specified on a database schema and restricts the data in which

Describe the algorithm for updating indices for a single level index when a record is    (i) Inserted  (ii)  deleted What will be the modification if there are multilevel in

Control as State within Program 1.  The term control exactly means to check effect of input within a program. For illustration, in Figure, after the ATM card is inserted (a

What are the Issues when Selecting a Database Issues when Selecting a Database Storage space requirement: A database requires about triple storage space of the actua

Consider a research paper submission process. The process starts when an author submits a draft research paper (the paper may have up to 3 authors) to the chair of the organizing c

Identify the need and use of data control through problem solving, illustration

In the ER diagram, one example of subclassing is depicted following the Services entity. The subclasses Item Based and Time Based are created. The entity Services gains the attribu

Produce a set of relations (equivalent to the Finkelstein entity list) in third normal form (3NF) from the following un-normalised relation. You must use the Finkelstein methodolog