what is primary key,unique key, foreign key? can u teach me
in simple language?
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
If the master device is full, how do I make the master database bigger?
What is the best database?
What is a sequence? Explain it with one example?
What is the role of tester in discovery(in Checklist)?
Is it good to store images in database?
How to produce such kind of file?
Is database a hardware or software?
How many indexes can be created on a table?
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
What is database collection?
How do database connections work?
What are the advantages of views in a database?
What is Object Oriented model?
What is a Database?
HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?