What is the difference between a primary key and a foreign key?

      

Distinguish between a primary key and a foreign key.

  

Answers


Maurice
(i) A primary Key is a key field that is used to uniquely identify each record in a database table to avoid duplication or null values.

(ii) Foreign key is a key that contains values that correspond to values in the primary key of another table and is used to create relationships between the various tables.
maurice.mutuku answered the question on April 11, 2018 at 09:14


Next: What are the data types used in Ms Access?
Previous: What is the meaning of the term "index" as used in databases?

View More Computer Studies Questions and Answers | Return to Questions Index


Exams With Marking Schemes

Related Questions