Define candidate key, alternate key, composite key?
- 30 Answers
- 141411 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
Explain the rollup operator?
How to replace not in with not exist?
What is data modeling with example?
Explain about the storage and physical database design?
What are the 18 schemas?
Explain the cube operator?
Can an extended stored procedure be called from inside a user-defined function?
How to read and create .LDC data files which are used by linguatic dictionary.
Where is dbms used?
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 network model?
What are the types of database model?
Write short notes on manual refreshes.
Who are end users in dbms?
explain detail about ftp in datastage?
