what is primary key,unique key, foreign key? can u teach me
in simple language?

Answer Posted / janu

Primary Key:

A primary key is a field or combination of fields that
uniquely identify a record in a table, so that an individual
record can be located without confusion.
Foreign Key:

A foreign key (sometimes called a referencing key) is a key
used to link two tables together.

Is This Answer Correct ?    6 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Data structure used to implements a menu:

635


Is storing images in a database a good idea?

550


Why do we need distributed database?

550


Can a database table exist without a primary key?

540


What is Object Oriented model?

626






What is database collection?

580


What is the difference between database and server?

534


What is the DIF format and when we will use in teradata

2093


What is a Database?

598


What is the best database software for small businesses?

507


What is difference between data and database?

560


Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.

1390


Explain buffer manager?

557


How to do Data integrity testing? Who does this testing (Developer or tester)?

1618


what is data access layer?

1982