Define candidate key, alternate key, composite key?
- 30 Answers
- 141154 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / shreyas joshi
Candidate key- A candidate key is defined as an attribute or
set(combination) of attributes that no 2 tuples(rows) in a
relation hold duplicate values of it.or we can say that a
candidate key is a kind of superkey, if whose subset taken
than it cannot be said as a superkey..in otherwords consider
a customer table with attributes(cust_id,cust_name,cust_street).
than candidate key is (cust_name,cust_street)(combination)
Now this is sufficient to uniquely identify an entity in a
table.But if its subset taken i.e alone cust_name or
cust_street, they individually cannot identify uniquely a
tuple or entity..IN short a candidate key is a superkey with
no super key as it subsets.
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
What is normalization? Explain different levels of normalization?
Why does this query return 0?
What are the key features of dbms?
What are the three types of database design?
What is dbms explain in brief?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
What is an application role and explain a scenario when you would use one?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What are the constraints on severity level in raiseerror?
How to generate OIDS
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
Explain about the hierarchical model of the database?
What is database design and development?
Which data type cannot be used as a parameter in a udf?
Explain about the storage and physical database design?
