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

Microeconomic, anyone have a textbook solutions case fair, 8 edition of vo... anyone have a textbook solutions case fair, 8 edition of vol 1 ?, please give me

Explain hashing techniques, Explain Hashing techniques The hashing tech... Explain Hashing techniques The hashing techniques can be categorized as: Static Hashing Techniques - In this method, the data can be viewed a collection of buckets, along with

Explain hash file organization, Explain hash file organization? Hash fu... Explain hash file organization? Hash functions a) The distribution is uniform Hash functions assign each bucket the similar number of search -key values from the set of a

What is sql?, What Is Sql?  Structured Query Language (SQL) is a standa... What Is Sql?  Structured Query Language (SQL) is a standard query language. It is usually used with all relational databases for data manipulation and definition. All the re

Weak entity, Entity types that do not have any key attribute, and therefore... Entity types that do not have any key attribute, and therefore cannot be identified independently, are known as weak entity types. A weak entity can be recognized uniquely only by

Explain how the object classes are mapped to tables, Explain how the object... Explain how the object classes are mapped to tables. Each object class maps to one or more than one tables in the database. The objects in the class may be partitioned horizont

Fragmentation, Differentiate between horizontal & mixed horizontal fragment... Differentiate between horizontal & mixed horizontal fragmentation?

What are the two methods for dealing deadlock problem, What are the two met... What are the two methods for dealing deadlock problem? The two procedures for dealing deadlock problem is deadlock detection and deadlock recovery.

Database, A database has been designed for this beauty parlour in order for... A database has been designed for this beauty parlour in order for the staff to manage specific things such as bookings made by clients, payments, staff availability, level of exper

Normalization, Process of normalization is the integral part of designing a... Process of normalization is the integral part of designing a database. Justify this statement with suitable database design