Define candidate key, alternate key, composite key?

Answer Posted / viresh rajput

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:-A candidate key uniquely identifies the rows
in a table.there can be more than 1 candidate key in a
table, in which one should be 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 ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Who are end users in dbms?

742


How can I detect whether a given connection is blocked?

811


To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

3737


Explain about a primary key?

767


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?

2231


What is dbms explain in brief?

777


In which table collections errors are stored.

2162


What is the maximum length of an extended property?

749


How to combine two function together?

1875


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


Why does this query return 0?

804


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

1811


What is DB Development software?

1823


How to use timestamp datatypes

1789


There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

2200