Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 145522 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
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Explain the process of the user request and data generating?
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?
Which data type cannot be used as a parameter in a udf?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
How long can an error message be in raiseerror function?
How you can make a parameterized view?
Explain what a database is?
In which database can extended stored procedures be added?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
How can I detect whether a given connection is blocked?
Explain about query and reporting.
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
What is dbms explain in brief?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
