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
What is the maximum length of an extended property?
Why does this query return 0?
How to combine two function together?
How to use online Backups?
Explain about xml databases?
What is a database development?
What is DB Development software?
What are the three basic rules which are to be followed for the relational model of the database?
Explain about relational operator join?
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
How to use timestamp datatypes
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
Explain about the relational database?
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?
How you can make a parameterized view?