Trusted by millions of Kenyans
LoginRegister
Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Browse exam papers
Or go directly to:
Class notes Holiday assignments Topical questions Other resources

Discuss the differences between the candidate keys and the primary key of a table. Explain what is meant by a foreign key. How do foreign...

Discuss the differences between the candidate keys and the primary key of a table. Explain what is meant by a foreign key. How do foreign keys of tables relate to candidate keys? Give examples to illustrate your answer.

Answers

kelvin
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.
kevowmuchiri answered the question on July 4, 2018 at 15:33

Answer Attachments

Next: Discuss the properties of a relational table.

Previous: Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules.

View more Computer Science Questions and Answers  |  Return to Questions Index

Exams With Marking Schemes

Related Questions