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
- 187763 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / pappu
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 one record per
person) or it can be generated by the DBMS (such as a
globally unique identifier, or GUID, in Microsoft SQL
Server). Primary keys may consist of a single attribute or
multiple attributes in combination
a unique key can uniquely identify each row in a table,
and is closely related to the Superkey concept. A unique
key comprises a single column or a set of columns. No two
distinct rows in a table can have the same value (or
combination of values) in those columns if NULL values are
not used. Depending on its design, a table may have
arbitrarily many unique keys but at most one primary key.
Unique keys do not enforce the NOT NULL constraint in
practice. Because NULL is not an actual value (it
represents the lack of a value), when two rows are
compared, and both rows have NULL in a column, the column
values are not considered to be equal. Thus, in order for a
unique key to uniquely identify each row in a table, NULL
values must not be used, however a column defined as unique
key column allows only one null value, which in turn can
uniquely identify that row/tuple.
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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain buffer manager?
How does database replication work?
Write a query to retrieve for many to many relationships?
define primary key index, bitmap index, hash index,virtual indwx
Which database does facebook use?
What is a database call?
After normalization, what are the conditions which have to keep in mind to de-normalize it?
Is storing images in a database a good idea?
What happens when shared and exclusive locks are applied on data item?
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
What the various ways to tune a teradata query
Display the employees whose salary is less than average salary.
How heap is implemented in database?
What are the types of indexes that are present inside a database?
What does specialization in DBMS mean?
