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

What are called journaling file systems, What are called journaling file sy... What are called journaling file systems? File systems that support log disks are known as journaling file systems.

Oracle fusion middleware, Oracle Fusion Middleware: Key Skills: Consul... Oracle Fusion Middleware: Key Skills: Consulting,Architect, Oracle Fusion Middleware,ECM, UCM, Stellent,Identity Management, SOA Suites, BPEL, ESB,OAM,OIM,J2ee, Java, Livelink

Explain the paths in the association network, Explain the paths in the asso... Explain the paths in the association network We can analyze use of paths in the association network as given below: Calculate each operation Find associations whic

Design a large scale system, Question: (a) Why is it important to know... Question: (a) Why is it important to know the architecture rather than to start requirement capture when designing a large scale system? (b) Who are the different people in

Using sql create a view rs for the relations r and s, Using SQL create a vi... Using SQL create a view RS for the relations R and S. The view consists of the columns A and D renamed as X and Y in that order. Insert a tuple into it. Show the contents of t

Online examination system project, entity relationship diagram for online e... entity relationship diagram for online examination system

Explain sorted file with advantages, Explain sorted File with advantages? ... Explain sorted File with advantages?  Sorted file The sort utility shall perform one of the subsequent functions: 1.Sort lines of all the named files together and write the

Compare the nested-loop join and block-nested loop join, Compare the Nested... Compare the Nested-loop join and block-nested loop join Ans: Nested  loop join - It is costly as worst case cost, no. of block accesses needed is n r * b s + b r   where b

What are object interaction diagrams, What are object interaction diagrams?... What are object interaction diagrams? Object interaction diagrams are the diagrams that used to describe order in which messages are communicated in execution of an operation,

Relational algebra, Relational Algebra is a set of basic operations used to... Relational Algebra is a set of basic operations used to influence the data in relational model. These operations allow the user to specify basic retrieval request. The result of re