Define candidate key, alternate key, composite key?

Answer Posted / jeff

A candidate key is able to identify a unique tuple in a
relation through an attribute or attribute set.

A foreign key makes sure that a tuple in a relation does
not match a tuple in another relation which does not exist

Is This Answer Correct ?    46 Yes 58 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to replace not in with not exist?

1463


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.

1603


Explain about query and reporting.

1688


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?

576


fact table and dimension table containg one to many relationship or many to one relastionship

2078






Explain about the storage and physical database design?

532


Explain the role of indexing in databases?

642


What is the physical representation for a many-to-many relationship?

576


How is data stored in dbms?

524


What is dbms explain in brief?

563


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

1585


How long can an error message be in raiseerror function?

548


How to generate OIDS

1662


Explain about the database management systems.

568


What are the constraints on severity level in raiseerror?

582