Define candidate key, alternate key, composite key?
Answer Posted / manumole
Candidate key:
Candidate keys for a table includes the set of columns
which satisfies the criteria of a primary key.
Primary key : a column/combination of columns which
uniquely identifies a row and whose values are not null.
Clustered Key:when a combination of columns becomes a
primary key it is called as clustered key.
Alternate keys:the set of columns which is avialble in the
candidate keys and are not selected as primary key.
Eg:Customer table
candidate keys:{ CustomerID, MobNo(defined as not null) }
primary key: if Db designer selected as CustomerID,then
Alternate key is MobNo
Clustered key:if both combination CustomerID- MobNo is
taken as primary key,it is nothing but a clustered key
Is This Answer Correct ? | 24 Yes | 22 No |
Post New Answer View All Answers
Write short notes on manual refreshes.
Which four data types cannot be used as a return type from a user-defined function?
What are the 18 schemas?
What are the main phases of database development?
How can you log an error to the server event log from a stored procedure?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
What is data modeling with example?
What is a database development?
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 network model?
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 DB Development software?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
How you can make a parameterized view?
What is dbms explain in brief?