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 data integrity, What is data integrity? Ans: It is the data con... What is data integrity? Ans: It is the data consisted of in database that is accurate and consistent.  (Data integrity means that the data should be valid as per to the give

Explain discretionary access control, Problem: (a) Given the following ... Problem: (a) Given the following relation: Stats(Name,Sex,Children, Occupation, Salary, Tax, Audits) Write SQL code to define the following security constraints: (i) User

In an e-r diagram how attributes are represented, In an E-R diagram how att... In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.

What is rdbms terminology for a row, What is RDBMS terminology for a row? ... What is RDBMS terminology for a row? A tuple is a RDBMS terminology for a row

Chapter 1 - Profile for the Organization, Chapter 1 - Profile for the Organ... Chapter 1 - Profile for the Organization You have to select an organization of your choice and assume that you work for that organization. Now you must prepare a brief profile of t

Data modelling, Law Associates is a large legal practice based in Sydney.  ... Law Associates is a large legal practice based in Sydney.  You have been asked to design a data model for the practice based upon the following specification: The practice emplo

What is meant by object-oriented data model, What is meant by object-orient... What is meant by object-oriented data model? The object-oriented paradigm is based on encapsulation of data and code related to an object in to a one unit, whose contents are n

Define average latency time, Define average latency time. The average l... Define average latency time. The average latency time of the disk is one-half the time for a full rotation of the disk.

Oracle, how oracle can be used how oracle can be used

Database Normalization, I have a homework assignment due today by midnight.... I have a homework assignment due today by midnight. I need help understanding databasse normalization and determining the type of form violation & how to fix the violation.