Define candidate key, alternate key, composite key?
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
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?
How to replace not in with not exist?
Explain about query and reporting.
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What are the three types of database design?
What are the 18 schemas?
Who are naive users?
What is dbms and its application?
What are the types of database model?
Explain what a database is?
How to read and create .LDC data files which are used by linguatic dictionary.
Explain about the hierarchical model of the database?
Which data type cannot be used as a parameter in a udf?
How to combine two function together?