Define candidate key, alternate key, composite key?
- 30 Answers
- 137647 Views
- IAS, IBM, I also Faced
- E-Mail Answers
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
Which data type cannot be used as a parameter in a udf?
explain detail about ftp in datastage?
What are the three types of database design?
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?
What is dbms explain in brief?
Why does this query return 0?
What is database design and development?
Explain the process of the user request and data generating?
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).
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
Explain about relational database management systems?
How to replace not in with not exist?
What is the physical representation for a many-to-many relationship?
Can an extended stored procedure be called from inside a user-defined function?
How long can an error message be in raiseerror function?
