Update operations in dbms - insert operation, Database Management System

Assignment Help:

Update Operations and Dealing with Constraint Violations

There are three basic operations to be executes on relations:

Insertion
Deletion
Update

The INSERT Operation:

The insert operation permits us to insert a new tuple in a relation. When we try to insert a new record, then any of the following four types of constraints can be violated:

Key constraint: If the value of the key attribute in new tuple t is the similar as in the existing tuple in relation R.
Domain constraint: If the value given to an attribute lies outside the domain of that attribute.
Referential Integrity constraint: If the value of the foreign key in t refers to a tuple that doesn't show in the referenced relation.

• Entity Integrity constraint: If the primary key attribute value of new tuple t is given as null.

Related Discussions:- Update operations in dbms - insert operation

Which data type can store unstructured data, Which data type can store unst...

Which data type can store unstructured data? Raw data type can store unstructured data.

North indian plains, i am not clear with the climetic condition of the nort...

i am not clear with the climetic condition of the north indian plain. can u plz explain it for me

File Management Principles, What are the requirements to ensure the objecti...

What are the requirements to ensure the objectives of file management principle is realized?

Objectives-database recovery and security, Objectives Define the te...

Objectives Define the terms RECOVERY and INTEGRITY; Define Recovery Techniques; Explain Error and Error detection techniques, and Define types of Authorisation.

List the steps for converting state diagram to the code, List the steps for...

List the steps for converting state diagram to the code. a) Finding major control path b) Finding the conditional statements c) Finding the loops d) Finding error ro

Explain interblock gap, Explain Interblock gap? Interblock Gap - A trac...

Explain Interblock gap? Interblock Gap - A track of a disk is separated into equal-sized disk blocks. Blocks are separated through fixed-size gaps, called as interblock gaps th

Database schema, #Use the following database schema: 1) Patient—PatientID, ...

#Use the following database schema: 1) Patient—PatientID, Name, DOB 2) Doctor—DoctorID, Name, MedLicenseNumber, Phone 3) Medication—MedicationID, BrandName, GenericName 4) Prescrip

Modifyand removing a sequence-sequences, Modify a sequence: ALTER SEQU...

Modify a sequence: ALTER SEQUENCE SEQSS INCREMENT 2 MAXVALUE 3000; Removing a sequence: DROP SEQUENCE SEQSS;

Define direct file organization, Define Direct file organization? The d...

Define Direct file organization? The direct file organization is employed to enhance the performance in accessing the records than sequential file organization. In direct file

Physical or internal level, give me a diagram about physical or internal le...

give me a diagram about physical or internal level

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages