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

Database project, A database to track your progress in your college program... A database to track your progress in your college program will track your progress towards graduation! A database that has information containing the classes that you have taken, c

Help, #questiononsider the following relation: CAR_SALE =(CAR_ID,oPTION_TYP... #questiononsider the following relation: CAR_SALE =(CAR_ID,oPTION_TYPE, Option_listpreice, Sale_date, Option_discountedprice)..

Advanced database systems, Consider an information system designed for an o... Consider an information system designed for an online company which provides IT products and services These include desktops, laptops, networking products, IT books, parts, and

Explain sequential file organization, Question 1 What do you mean by datab... Question 1 What do you mean by database management system? Question 2 Write a note on Object-Oriented Model Question 3 Explain Sequential File Organization Question

Difference between internal tables and extra datasets, What is the differen... What is the difference between internal tables and extract datasets? The lines of an internal table always have the similar structure. By using extract datasets, you can ha

Why object-oriented system use the relational dbms, Why, generally does an ... Why, generally does an object-oriented system use the relational DBMS? The reasons for using relational DBMS for OO systems could be any combination of following: a. Many or

Concurrency executions, Explain TPS concurreny executions stating their adv... Explain TPS concurreny executions stating their advantages in online business advancement

What are stored and derived attributes, What are stored and derived attribu... What are stored and derived attributes? Stored attributes: The attributes keeps in a data base are known as stored attributes. Derived attributes: The attributes that are de

Data control, Identify the need and use of data control through problem sol... Identify the need and use of data control through problem solving, illustration

There are two major types of fragmentation, There are two major types of fr... There are two major types of fragmentation: Horizontal& Vertical. Horizontal fragments, as the name suggests are subsets of tuples and vertical fragments are subsets of attributes