Define candidate key, alternate key, composite key?
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 what a database is?
What is the maximum length of an extended property?
Who are naive users?
What are data modelling techniques?
How long can an error message be in raiseerror function?
What are the 18 schemas?
Explain about xml databases?
How can you fix a poorly performing query?
What are the key features of dbms?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Explain the cube operator?
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
Explain about relational operator join?
What is DB Development software?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?