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

MS Access 2010 - Form Updates Table, Hi there, Have an issue with my Databa... Hi there, Have an issue with my Database. I have: TblOrderDetails and FmOrderDetails TblCircuit and FmCircuit Whenever I add data into the Form, it will update the table as expect

Describe the grant function and explain security, Describe the GRANT functi... Describe the GRANT function and explain, how it associates to security. What kind of privileges may be granted? How are they revoked? Ans: Since more than one user can aacce

Employees and projects scenario, how many hourse have been spent on a certa... how many hourse have been spent on a certain project

Backup - restore utilities, These are designed to reduce the effects of a d... These are designed to reduce the effects of a database failure and make sure a database is restored to a consistent state if a failure does arise. Manual backup/restore utilities n

What are ways of finding out derived attributes, What are ways of finding o... What are ways of finding out either an update is required or not for derived attributes? The ways to find out an update is required or, not are as: Explicit update

Design and build a data mart, You are required to design and build a data m... You are required to design and build a data mart/data warehouse using Oracle. A national bank allocates funding every year for its local branches to provide temporary staff cove

Explain the process-oriented decomposition, Breaking into Subsystems D... Breaking into Subsystems Decomposition is a significant technique for coping with complexity based on idea of divide and conquers. In dividing a problem into sub problems, the

Oracle, List and explain the memory constructs of the Oracle 12c databases?... List and explain the memory constructs of the Oracle 12c databases?

Explain about database system structure, Explain about database system stru... Explain about database system structure? Storage manager Authorization and integrity manager Transaction manager File manager Buffer manager Storage manager

Explain the term - control as concurrent tasks, Explain the term - Control ... Explain the term - Control as Concurrent Tasks As we know, any object can be implemented as a task in programming language or operating system. This is the most general approa