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

Creating views with check option-data control, Creating views with check op... Creating views with check option : This option limits those updates of data values that cause records to go off the view. The following instance tells this in more detail: Examp

What are the issues are formed while selecting a database, What are the Iss... 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

What is object identity, What is object identity? An object retains its... What is object identity? An object retains its identity even if some or all the values of variables or explanations of methods change overtime.

Aims of the design project, The aims of the project are: 1. To enable th... The aims of the project are: 1. To enable the students to undertake the detailed design of a specific plant or process 2. The design projects includes: process selection; und

Explain transaction manager and their work, Explain Transaction manager and... Explain Transaction manager and their work? Transaction Manager: Ensure the database remains in a constant (correct) state despite system failure, and in which concurrent trans

4, explain the level architectures of the database management system explain the level architectures of the database management system

Assignment, Research Value: 7% Due Date: 17-Sep-2018 Return Date: 11-Oct-2... Research Value: 7% Due Date: 17-Sep-2018 Return Date: 11-Oct-2018 Length: 700 words Submission method options: Alternative submission method Task back to top You are required to

State the data flow diagram of functional model, State the data flow diagra... State the data flow diagram of functional model Any action initiated by transition in the state diagram can be extended into an entire data flow diagram in functional model. Th

Create database for car application, The Database MySQL scripts cars_f... The Database MySQL scripts cars_for_sale.sql and car_details.sql containing the data to use for this task have been supplied. To complete this task, you need to first create

Explain about database system structure, Explain about database system stru... Explain about database system structure? Storage manager Authorization and integrity manager Transaction manager File manager Buffer manager Storage manager