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

What is trigger, What is trigger?  Triggers are statements that are exe... What is trigger?  Triggers are statements that are executed automatically by the system as the side effect of a modification to the database.

Objectives of data management, what are the topics in data management what are the topics in data management

Define the term- having clause and a where clause, What is the difference ... What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? HAVING CLAUSE - HAVING CLAUSE is used only with SELECT statement. - It is normally used in a GROUP BY

Project, project on dbms project on dbms

What are the different integrity constraints in rdbms, What are the differe... What are the different integrity constraints in RDBMS? The various integrity constraints in RDBMS are as: Primary Key: primary key is a grouping of one or more attributes

Define deadlock recovery measures, Define Deadlock recovery measures       ... Define Deadlock recovery measures                   To recover from deadlock, the cycle in the wait-for-graph should be broken. The common technique of doing this is to rollbac

What is the use of a slotted-page structure, What is the use of a slotted-p... What is the use of a slotted-page structure and what is the information are there in the header? The slotted-page structure is used for organizing records within a one block.

Data warehousing and business intelligence, I need help with data warehousi... I need help with data warehousing and business intelligence course project about designing a data warehouse for a jewelry company that does not have one

Lossless-join decomposition, Lossless-Join Decomposition   Let us sh... Lossless-Join Decomposition   Let us show an intuitive decomposition of a relation. We require a better basis for deciding decompositions since intuition may not always be r

Define sequence, Define Sequence A sequence is a set of integers 1, 2, ... Define Sequence A sequence is a set of integers 1, 2, 3 that are generated in order on demand. Sequences are regularly used in databases because lots of applications require ev