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

Implementing a data mining algorithm, i need to implememnt a treee based mi... i need to implememnt a treee based mining algorithm. do you have an expert that can do that?

Discuss the different layers of ansi sparc architecture, Q.1 Briefly discus... Q.1 Briefly discuss the different layers of ANSI SPARC architecture. Ans: The three layers of ANSI SPARC architecture are like this: 1. Internal view is at the lowest leve

Describe embedded query language, Describe Embedded Query Language? Emb... Describe Embedded Query Language? Embedded Query Language - A query language (e.g., SQL) can be implemented in two ways. It can be used interactively or embedded within a host

Describe integrity constraints, Describe integrity constraints? Integr... Describe integrity constraints? Integrity Constraints - A database is just as excellent as the information stored in it, and a DBMS must therefore help avoid the entry of inc

Database design in third normal form, The following data are required to be... The following data are required to be stored by a family physician. Family#, FamilyAddress, Patient#, PatientName, ServiceCode, ServiceFee, ServiceDate A family can have seve

What are the functions of an accumulator, What are the functions of an accu... What are the functions of an accumulator? The accumulator is the register associated with the ALU operations and sometimes I/O operations. It is an integral part of ALU. It hol

Convert erd to rdm model, Regional Gardens has many nurseries, including Wa... Regional Gardens has many nurseries, including Wagga Wagga, Bathurst, Albury, Orange, and Dubbo. Each nursery is known by its campus code, eg WW, B, A, O and D respectively. Additi

What are the two types of errors, What are the two types of errors? The... What are the two types of errors? The two types of errors are: a) Logical error b) System error

DW, #ques Define a job scheduling strategy that will meet business requirem... #ques Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a p

Example of alter table command, Example - ALTER TABLE emp MODIFY (empno NUM... Example - ALTER TABLE emp MODIFY (empno NUMBER (7));