Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 145541 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / mona
A set of fields that uniquely identifies a tuple according
to a key constraint is called candidate key for the relation.
(1)No two values of keys are same
(2)the set of fields{sid,sname} is not a key for
students,because this set properly contains the key{sid}.
The set {sid,sname} is an example of a super key,which is a
set of fields that contains a key.
EX:
create table customer(customer_name char(20),street
char(30),city char(30),primary key(customer_name));
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
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
Why does this query return 0?
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 the process of the user request and data generating?
What is normalization? Explain different levels of normalization?
What is an application role and explain a scenario when you would use one?
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?
What are the three basic rules which are to be followed for the relational model of the database?
How you can make a parameterized view?
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?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
How can I detect whether a given connection is blocked?
What are the three types of database design?
Write the fastest query to find out how many rows exist in a table?
Explain about relational operator join?
