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

Explain about the storage and physical database design?

723


Which data type cannot be used as a parameter in a udf?

764


What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

798


What is the database development process?

957


Where is dbms used?

843


Explain about the database management systems.

754


Why does this query return 0?

805


What is DB Development software?

1824


How would you design a database for an online site, which would average a million hits a day?

795


What are the main phases of database development?

758


How to use online Backups?

1994


What are the key features of dbms?

774


How long can an error message be in raiseerror function?

763


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

1812


When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

2020