Define candidate key, alternate key, composite key?
Answer Posted / koteswararao bora
candidate key:the minimum set of attributes which uniquely
identifies the touples in a table .
primary key:any candidate key choosen by the developer is
called primary key.
composite key: a candidate key which have more than one
attribute is called composite key.
alternate key: a candidate key other than primary key
is called alternate key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use online Backups?
How can I detect whether a given connection is blocked?
What is DB Development software?
Explain about network model?
What are the constraints on severity level in raiseerror?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
Explain about the storage and physical database design?
Explain the role of indexing in databases?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
Explain about post-relational databases?
Explain about a primary key?
How to customize error conditions.
Who are end users in dbms?
Write short notes on manual refreshes.