Insert - referential integrity, Database Management System

The insertion of a tuple in the aim of reference does not cause any destruction. Though, insertion of a tuple in the relation in which, we has the foreign key, for instance, in ASSIGNMENT relation it requires to be ensured that all matching target candidate key be; or else the insert operation can be discarded. For instance, one of the possible ASSIGNMENT insert operations would be (LG, 103, 3000).

Posted Date: 3/6/2013 6:38:51 AM | Location : United States







Related Discussions:- Insert - referential integrity, Assignment Help, Ask Question on Insert - referential integrity, Get Answer, Expert's Help, Insert - referential integrity Discussions

Write discussion on Insert - referential integrity
Your posts are moderated
Related Questions
What is Alternate Key Alternate Key: This is the candidate key which is not taken as the primary key of the table. They are named so because although not the primary key, the

The advantages of a database management system (DBMS) include :- Data integrity and elimination of duplication.

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this info

what is the need of a log in dbms

What is Management System? A management system is a set of rules and process which help us to create organize and manipulate the database. It also helps us to add, change delet

Boyce-Codd Normal Form (BCNF) The relation NEWSTUDENT (Enrolmentno, Sno, Sname, Cname, Cno,) has every attributes participating in candidate keys as all the attributes are assu

Define the Query optimisation The query parser commonly generates a standard initial tree to correspond to an SQL query, with no doing any optimization. Such type of a canonica


An entity set that does not have sufficient attributes to form a primary key is called? An entity set that doesn't have sufficient attribute to form a primary key is known as w

In a relational model how relations are termed? In a relational model, relations are termed as tables. (The term ‘relation’ is the technical name of the ‘table’ in RDBMS)