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

Ask an Expert

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

Write your message here..

Related Questions

In e-r diagram how generalization is represented, In E-R diagram how genera... In E-R diagram how generalization is represented? in E-R diagram generalization is represented by Triangle shape.

Explain the concepts of relational data model, Explain the concepts of rela... Explain the concepts of relational data model? Relational Data Model - The relational model was first introduced through Prof. E.F. Codd of the IBM Research in the year 1970

Importance of file organisation in database, Importance Of File Organisatio... Importance Of File Organisation In Database To execute a database efficiently, there are various design tradeoffs needed. One of the most vital ones is the file Organisation. F

Multiple access path, Why is need for the multiple access paths? Why is need for the multiple access paths?

What is a shadow copy scheme, What is a shadow copy scheme? It is simpl... What is a shadow copy scheme? It is simple, but efficient, scheme known as the shadow copy schemes. It is based on making copies of the database called shadow copies that singl

Commercial database architecture, At its most essential level the DBMS arch... At its most essential level the DBMS architecture can be divide into two parts: the back end and the front end. The back end is responsible for managing the physical database an

Define hash files organization, Define Hash files organization a. Hashi... Define Hash files organization a. Hashing includes computing the address of a data item by calculating a function on the search key value.   b. A hash function h is a functi

Explain traditional programming languages, How persistent programming langu... How persistent programming languages differ from traditional programming languages? Database languages vary from traditional programming languages in that they directly manipul

What is the concurrency identification, Concurrency Identification Whi... Concurrency Identification While designing analysis, model we map real world model into our analytical model. Real life objects are simultaneous in nature, but all the design

Can a stored procedure call itself, Can a stored procedure call itself or r... Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible? Yes. Because Transact-SQL supports recursion, you can write kept proced