Define candidate key, alternate key, composite key?
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
What are the three basic rules which are to be followed for the relational model of the database?
Explain about relational database management systems?
Who are end users in dbms?
What is a database development?
How can I detect whether a given connection is blocked?
In which database can extended stored procedures be added?
What are the three types of database design?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
How to customize error conditions.
How would you design a database for an online site, which would average a million hits a day?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Where is dbms used?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
State the acid rules?
What is data modeling with example?