Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 145626 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / sonya jalil khan
candidate key:if it qualifies to uniquely select a specific
row in the table such that the data in that table depend
completely on that key and nothing else is required.the
candidate key cannot hold NULLS.the candidte key should
never change it must holds the same value for a given
occurence of an entity for the lifetime of that
entity.
example:
EMP ID , NAME,JOB,DEPARTEMENT ID
here emp id is a candidate key.becouse a minimal set of
columns that can be used to identify a single row
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Explain about the hierarchical model of the database?
Explain about relational operator join?
What are the types of database model?
How to combine two function together?
Explain about the storage and physical database design?
How long can an error message be in raiseerror function?
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?
Can an extended stored procedure be called from inside a user-defined function?
Who are end users in dbms?
State the acid rules?
What is normalization? Explain different levels of normalization?
How can you fix a poorly performing query?
How you can make a parameterized view?
How can you log an error to the server event log from a stored procedure?
What are the three basic rules which are to be followed for the relational model of the database?
