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

What is relationship instance, What is relationship instance ? Relation... What is relationship instance ? Relationship Instance - A relationship is a relation between two or more entities. An instance of relationship set is a set of relationships.

What is recovery?, What Is Recovery?  During the life of a transaction, ... What Is Recovery?  During the life of a transaction, i.e., a after the start of a transaction but before the transaction commits, various changes may be made in a database state

Describe the term- state diagram, Describe the term- State Diagram Sta... Describe the term- State Diagram State Diagram: An object could receive a sequence of the input instructions. The state of the object can differ depending upon sequence of in

Describe the most important classes of parallel machines, Question 1 Discu... Question 1 Discuss the classification of DBMS based on location of database Question 2 Explain with examples different SQL commands used for creating and deleting relations.

Responsibilitied of DBA, explain five responsibilities of DBA? explain five responsibilities of DBA?

Complexity- drawbacks of data distribution, Complexity : A distributed DBMS... Complexity : A distributed DBMS that is available, reliable, and secure is inherently more difficult than a centralised DBMS. Though, adequate data replication is essential to have

Data control, Identify the need and use of data control through problem sol... Identify the need and use of data control through problem solving, illustration

Give an example of operations from the functions of a bank, Give an example... Give an example of Operations from the functions of a bank. For creation of a saving account, you can write: bank::: create -savings-account (customer)->account. For oper

Give the relational calculus queries of players in sql, An orchestra databa... An orchestra database consists of the following relations: CONDUCTS (conductor, composition) REQUIRES (composition, Instrument) PLAYS (Player, Instrument) Give the relational

Define an operator that a relational algebra does not have, Define an opera... Define an operator that a Relational Algebra does not have Ans: Relational Algebra does not have Aggregation operators.