What are different types of Keys? Please explain all the
keys with a suitable example.
Answer Posted / abdul malik(new college)
keys-A key allows us to identify a set of attributes and
thus distinguishes entities from each other.keys also help
uniquely identify relationships,and thus distinguishes
relation with each other.
different types of keys:
(i)super key
(ii)candidate key
(iii)primary key
(iv)unique key
(v)foreign key
sk-it is a set of one or more attributes that allows us to
identify uniquely an entity set.
ck-a super key for which no subset is a superkey is called
a candidate key.
pk-In a table pk does not take no repetation and does not
allow null values.
fk-it acts as a referential order.it refers one table from
the another one.
Is This Answer Correct ? | 53 Yes | 9 No |
Post New Answer View All Answers
How to list all objects in a given schema?
What is optimistic concurrency?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Tell me about normalization in DBMS.
What does top operator do?
What is reportserver and reportservertempdb ?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What do you mean by a Composite primary key?
What is inner join? Explain with an example?
What is the concept of optimization?
How to delete duplicate rows from table except one?
What purpose does the model database server?
What is hot add cpu in sql server 2008?
Explain sql server service broker?
What is the fastest way to permanently delete a 1 million row table named customers?