Discuss the differences between the candidate keys and the primary key of a relation. Explain what is meant by a foreign key. How do foreign keys of relations relate to candidate keys? Give examples to illustrate your answer.
What will be an ideal response?
The primary key is the candidate key that is selected to identify tuples uniquely within a relation.
A foreign key is an attribute or set of attributes within one relation that matches the candidate key
of some (possibly the same) relation.
Computer Science & Information Technology
You might also like to view...
A thumbnail is an image that has been reduced to a smaller size
Indicate whether the statement is true or false
Computer Science & Information Technology
Access reports are based on a selected ____________________ or ____________________.
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology