what is primary key,unique key, foreign key? can u teach me
in simple language?
Answer Posted / charu gautam
primary key:- the primary key of a relational table uniquely
identifies each record in the table. it can either be a
normal attribute that is guaranteed to be unique . such as
social security number in a table with no more than record
per person or it can be generated by the D B M S .such as a
globally unique identifier ,or G U I D, in microsoft SQL
server primary key may consist of a single attribute or
multiple attribute in combination.
foreign key:- A foreign key is a field (or fields) that
points to the primary key of another table.The purpose of
the foreign key is to ensure referential integrity of the
data.In other words ,only values that are supposed to appear
in the database are permitted.
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
What is a database call?
Explain the table term used in database.
What is redis good for?
Explain phantom deadlock?
Explain entity type?
Explain the field term used in database.
What is the function of cluster index?
How many types of locks are present in a database?
Explain artificial key?
What is a database string?
Is redis in memory database?
What is global database name?
What are the types of joins?
What is the difference between oracle and MS Access?
After normalization, what are the conditions which have to keep in mind to de-normalize it?