Define candidate key, alternate key, composite key?

Answer Posted / shiv om mishra

candidate key- is a combination of two attributes taht can be uniquely used to identify a datbase record without any extraneous data.
Each table may have one or more candidate key.
A candidate key of a relation tells us all teh set of all its attribute is a superkey.

Is This Answer Correct ?    3 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are data modelling techniques?

531


Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

1610


Explain about normal forms?

606


What is the database development process?

692


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

1593






Can an extended stored procedure be called from inside a user-defined function?

616


What is a database development?

524


What is database design and development?

609


What is the maximum length of an extended property?

561


How to use timestamp datatypes

1583


What is DB Development software?

1619


If a column is an image value type, how you can compare column values? How can you use this column in join clause?

598


explain detail about ftp in datastage?

1817


Write short notes on manual refreshes.

2296


Explain what a database is?

615