what is the difference between primary key & foreign key?

Answer Posted / ibrahim

A primary key is an combination of attributes that uniquely
identifies each row in a relation. A primary key is
designated by underlining the attribute name. The primary
key of an entity set allows us to distinguish among the
various entities of the set.

A foreign key is an attribute in a relation of database
that serves as the primary key of another relation in the
same database.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are named parameters?

616


Which are the five query types available in oracle?

532


What is the relation of a user account and a schema in oracle?

592


How many types of table in Oracle?

619


What is a view and how is it different from a table?

574






Explain table?

655


How do I find my oracle client driver version?

528


How to get maxsal , minsal, ename department wise in single query

1026


What are the different oracle database objects?

588


What is hash cluster in oracle?

596


What is the difference between I and G in Oracle?

605


What is the difference between post-database commit and post-form commit?

517


What are the limitations oracle database 10g xe?

572


Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

1666


what is IDE,DMV in sql server?

2252