Interested to Buy Any Domain ? << Click Here >> for more details...
what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 187530 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
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 odm in database?
aht is the difference b/w network & hierarchial & relational dbms????
What are different types of data models available? Explain with example?
What is ase database?
can we delete autodiff back up that we have set through sql server agent.
What is difference between clustered, non-clustered and unique index?
What are the types of indexes that are present inside a database?
What is the concept of Virtual field?
Differentiate between extension & intension?
What is a trace file?
What is the use of default key?
What is redis good for?
how can we view column head in first page but not in remaining pages?
What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?
What are the types of joins?
