Relational Concepts  «Prev  Next»

Defining primary and foreign keys - Exercise

Objective: Identify primary and foreign keys in two relational tables.

Exercise Scoring

This exercise is worth a total of 2 points. It's auto-scored, which means that when you have completed it, click the Submit button below to receive full credit.

Instructions

Consider the two tables in the illustration below. Based on the data shown in the tables and the knowledge you have gained in this module, which column(s) from the Clients table is the primary key, and which column(s) from the Tasks table is the foreign key?
Sample tables
Sample Tables outlining foreign key

Submitting the Exercise

This exercise is auto-scored. Identify for yourself the primary key in the Clients table and the foreign key in the Tasks table, then click Submit below to check your answers against those supplied on the Results page.