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

Ask an Expert

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

Write your message here..

Related Questions

Explain trigger, Explain trigger? Trigger: A database trigger is proc... Explain trigger? Trigger: A database trigger is procedural code which is automatically executed within response to certain events on a particular table in a database. Trigger

By the relations get details of employees working in sql, Consider the rela... Consider the relations: PROJECT(proj#,proj_name,chief_architect) EMPLOYEE(emp#,emp_name) ASSIGNED(proj#,emp#) Use relational algebra to express the subsequent queries: (i) Get

Prepare a data flow diagram for computing the volume, Prepare a data flow d... Prepare a data flow diagram for computing the volume and surface area of a cylinder. Inputs are the height and radius of the cylinder. Outputs are the volume and surface area of th

What is a b+-tree index, What is a B+-Tree index? A B+-Tree index takes... What is a B+-Tree index? A B+-Tree index takes the form of a balanced tree in which each path from the root of the root of the root of the tree to a leaf of the tree is of the

Explain the concept of deadlock, Question: In a multi-user database env... Question: In a multi-user database environment, locking mechanisms can be used to solve the three basic problems of concurrency. On the other hand, however, locking may also le

What is online transaction processing, What is OLTP (Online Transaction Pro... What is OLTP (Online Transaction Processing)? In OLTP - online transaction processing systems relational database design use the discipline of data modeling and generally follo

Non-redundant cover and canonical cover, Given the following set of functio... Given the following set of functional dependencies {cf?bg, g?d, cdg?f, b?de, d?c} defined on R(b,c,d,e,f,g) a.Find a non-redundant cover. b.Find a canonical cover.

Determine the persistent object, Determine the Persistent object Persis... Determine the Persistent object Persistent object can be stored in one of the following: Files Cheap, permanent, simple storage Low level (Write, Read) Ap

What is multiplicity in the associations, What is multiplicity in the assoc... What is multiplicity in the associations? Give an example to explain multiplicity? Multiplicity in association indicate number of objects participate in any relationship. For

Describe the statement in sql which allows to change, Describe the statemen... Describe the statement in SQL which allows to change the definition of a table? In SQL Alter statement is used to allow the changes the definition of a table.