Interested to Buy Any Domain ? << Click Here >> for more details...
What are different types of Keys? Please explain all the
keys with a suitable example.
- 4 Answers
- 27562 Views
- I also Faced
- E-Mail Answers
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 insert new line characters into strings?
How do I create a stored procedure in sql server?
How to compare the top two records using sql?
Can you leave a union at any time?
How can I know what locks are running on which resource?
Differentiate between ms sql server reporting services vs crystal reports?
How to convert numeric values to integers in ms sql server?
What is the difference between join and inner join?
How to write a query with a full outer join in ms sql server?
Can sql server 2016 run on windows 7?
what is a self join? : Sql server database administration
What are scalar functions?
Name three of the features managed by the surface area configuration tool? : sql server security
What is the use of commit?
What is the sql server agent?
