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
In how many parts events are classified Events are classified as four types in UML 1.  Signals 2.  Calls 3.  Passing of Time 4.  Change in State

Define raid? Briefly explain it? A range of disk organization methods, collectively called redundant arrays of independent disks (RAID) o   Improvement of reliability throug

Explain how the object classes are mapped to tables. Each object class maps to one or more than one tables in the database. The objects in the class may be partitioned horizont

need requirement analysis for database management of stock market

sql is relationally complete-justify

Explain the following functions of Oracle with suitable examples: (i) To_Char( ) (ii) Count( ) (iii) Trim( ) (iv) Length( ) Ans: (i) To_char( ): The TO_CHAR function conver

Design an algorithm to implement operations  Each and every operation specified in the functional model could be formulated as an algorithm. The algorithm indicates how operat

Data Definition Language It organises the data in the form of columns and rows. But what does the data field column of table accumulate? How do you describe it using SQL? Th

Objectives Define the terms RECOVERY and INTEGRITY; Define Recovery Techniques; Explain Error and Error detection techniques, and Define types of Authorisation.

What is Disadvantages Of DBMS ? 1. Cost of Software and Hardware and Migration - A important disadvantage of the DBMS system is cost. 2. Reduced Response and Throughpu