Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 146566 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
Which four data types cannot be used as a return type from a user-defined function?
Why does this query return 0?
Explain the role of indexing in databases?
What are the constraints on severity level in raiseerror?
How would you design a database for an online site, which would average a million hits a day?
What is the physical representation for a many-to-many relationship?
How to combine two function together?
How to use online Backups?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
What is dbms explain in brief?
Where is dbms used?
Which data type cannot be used as a parameter in a udf?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
Explain about query and reporting.
fact table and dimension table containg one to many relationship or many to one relastionship
