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

Ask an Expert

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

Write your message here..

Related Questions

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

Describe the concept of aggregation, Aggregation Aggregation is strong... 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

Hashing technique, note on hashing technique note on hashing technique

What purpose of tables, What is the purpose of tables, private synonyms and... 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

View serialiabilty-labelled precedence graph, how to construct labelled pre... how to construct labelled precedence graph for view serialiability.please explain insteps with one solved examples

What are the two types of indices, What are the two types of indices? T... 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, Define outer union ... 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

Find the employee name, Example -Find the employee name, salary, department... 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

Database Design For Inventory, how design database from begining how design database from begining

Describe the basic steps involved in recovery, Question: One of the tas... 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