Deletion operation - update operations, Database Management System

By using the delete operation some consisting records can be deleted from a relation. To delete some definite records from the database a condition is also specified based on which records can be taken for deletion.

Constraints that can be violated during deletion

Only one type of constraint can be violated during deletion, it is referential integrity constraint. It can happen when you want to delete a record in the table where it is referenced by the foreign key of another table.  Please read the example given below very carefully.

Posted Date: 3/6/2013 5:38:26 AM | Location : United States







Related Discussions:- Deletion operation - update operations, Assignment Help, Ask Question on Deletion operation - update operations, Get Answer, Expert's Help, Deletion operation - update operations Discussions

Write discussion on Deletion operation - update operations
Your posts are moderated
Related Questions
State about the Activity Diagram Activity diagrams show flow from one activity to other. It is an ongoing non atomic execution within a state machine. Activity finally results

Consider the ER schema below for the MoneyMaking supermarket chain problem. Translate the given ER schema into SQL CREATE TABLE statement.

What are the several kinds of the update operations on relations? Also explain the constraints on these update operation. Give instance in support of your answer. There are th

What are the basic objects of the data dictionary? Tables Domains Data elements Structures Foreign Keys

The figure below depicts the conceptual diagram of a banking system. (a) Describe one example relevant to the system in figure, for each of the 4 types of enterprise appl

write-set(T): Each data items that are written by a transaction T

What is Interaction Diagram An interaction diagram shows an interaction, comprises of a set of objects and their relationships including the messages that may be dispatched be

Farmer Bob, Farmer Jane and Farmer Jose run a cow farming co-op. For every cow they keep the cow’s name, age (or date of birth), breed and numbered plastic ear tag. The each of t

What are metrics for choosing the best algorithm? Matrices for choosing the best algorithms are as below: Computational complexity Ease of understand ability and im

Explain mechanism of nested queries? SQL gives a mechanism for nesting subqueries. A subquery is a select from where expression that is nested within one more query. A common u