Define candidate key, alternate key, composite key?
- 30 Answers
- 141268 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?
What are the constraints on severity level in raiseerror?
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?
Why does this query return 0?
How is data stored in dbms?
Explain about post-relational databases?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Explain the role of indexing in databases?
How long can an error message be in raiseerror function?
What is the physical representation for a many-to-many relationship?
How can you fix a poorly performing query?
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
What is normalization? Explain different levels of normalization?
What is the database development process?
