Explain about foreign key, Database Management System

What is Foreign Key

Foreign Key: Sometimes we may have to work with an attribute that does not have a primary key of its own. To recognize its rows, we have to use the primary attribute of a related table. Such a copy of another related table's primary key is known as foreign key.

 

Posted Date: 7/26/2013 6:13:24 AM | Location : United States







Related Discussions:- Explain about foreign key, Assignment Help, Ask Question on Explain about foreign key, Get Answer, Expert's Help, Explain about foreign key Discussions

Write discussion on Explain about foreign key
Your posts are moderated
Related Questions
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

Aggregation Aggregation is stronger form of association. It represents the "has-a" or "part-of" relationship. An aggregation association depicts a complex object which is comp


What is the purpose of tables, private synonyms and public synonyms? If there are multiple objects of similar name on an Oracle database, that order are they accessed in? The r

how to construct labelled precedence graph for view serialiability.please explain insteps with one solved examples

What are the two types of indices? The two types of indices are:- A)     Dense index B)      Sparse index

Define outer union operation of the relational algebra. Compute the outer union for the relations R and S given below. Outer Join - If there are any values in one tabl

Example -Find the employee name, salary, department number and average salary of his/her department, for those employees whose salary is more than the average salary of that depart


Question: One of the tasks a database management system must perform is to ensure that the data is still intact in the face of software and hardware failure. This task is known