Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 145604 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
Explain about post-relational databases?
Which four data types cannot be used as a return type from a user-defined function?
Explain what a database is?
Explain about the storage and physical database design?
How to use online Backups?
What are the 18 schemas?
How to replace not in with not exist?
State the acid rules?
Can an extended stored procedure be called from inside a user-defined function?
How to combine two function together?
Explain the rollup operator?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Explain about the relational database?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
What is normalization? Explain different levels of normalization?
