Referential integrity, Database Management System

It can be easily defined as:

The database must not have any unmatched foreign key values.

The term "unmatched foreign key value" means a foreign key value for which there does not exist a matching value of the relevant candidate key in the relevant target (referenced) relation. For instance, any value existing in the EMPID attribute in ASSIGNMENT relation must be in the EMPLOYEE relation. That is, the only EMPIDs that can be in the EMPLOYEE relation are 101, 102 and 103 for the instance / present state of the database given in Figure. If we want to insert a tuple with EMPID value 104 in the ASSIGNMENT relation, it will cause violation of referential integrity constraint. Logically it is very obvious after all the employee 104 does not be, so how can s/he be assigned any work.

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







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

Write discussion on Referential integrity
Your posts are moderated
Related Questions
Draw an EER diagram that captures the "is-a" hierarchy of students in another simple database. The database captures both the "basic" information (say, student ID and student name)

#question.what is mapping constraints and types?.

Implementation of association as an object Implement as a separate association object, independent of either class, as in Figure. An association object is a group of pairs

Explain I command in QBE ? I : It is the command in QBE that is used to insert tuple (s) into the database

Data Control The data control mostly refers to commands that permit system and data privileges to be passed to several users. These commands are usually available to database admi

What is Derived and stored Attribute? Derived and Stored Attribute - In a few cases, two or more attribute values are associated, for example, Age and BirthDate attributes of a

What are the types of storage devices? Primary storage Secondary storage Tertiary storage Volatile storage Nonvolatile storage

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

What are the factors to be taken into account when choosing a RAID level? A) Monetary cost of extra disk storage requirements. B) Performance requirements in terms of number

statical data