Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 144679 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
How to customize error conditions.
Write the fastest query to find out how many rows exist in a table?
How to combine two function together?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Explain about the hierarchical model of the database?
In which database can extended stored procedures be added?
fact table and dimension table containg one to many relationship or many to one relastionship
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
What are data modelling techniques?
What is a database development?
How can I detect whether a given connection is blocked?
What is the database development process?
How to use online Backups?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What are the 18 schemas?
