Define candidate key, alternate key, composite key?

Answer Posted / palanivel

primary key:- The attribute or combination of attributes
that uniquely identifies a row or record.

Foreign Key:- an attribute or combination of attribute in a
table whose value match a primary key in another table.

Composite key:- A primary key that consistsof two or more
attributes is known as composite key

candidate key:- is a column in a table which has the
ability to become a primary key.

Alternate Key:- Any of the candidate keys that is not part
of the primary key is called an alternate key.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a database development?

744


What are the main phases of database development?

772


Where is dbms used?

861


Explain about a primary key?

789


What are the types of database model?

839


Which four data types cannot be used as a return type from a user-defined function?

828


Explain about post-relational databases?

798


Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

2250


How can you fix a poorly performing query?

895


What is normalization? Explain different levels of normalization?

61420


How to generate OIDS

1939


Explain about the database management systems.

773


How is data stored in dbms?

733


How to replace not in with not exist?

1729


How to use online Backups?

2011