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 below, Clients and Tasks, from an application that assigns tasks to clients. Based on the data shown and what you've learned in this module, identify which column in the Clients table is the primary key, and which column in the Tasks table is the foreign key that relates it back to the Clients table.

Clients
Client IDClient NameClient Contact
101Strategic Innovations ConsultingAnthony T. Mann
102XYZ CorporationWalt Walters
103ABC IndustriesMatt Matson

Tasks
Task IDClient IDTask Name
1101Identify Requirements
2102Develop Application
3103Unit Test
4101Integration Test
5101System Test

Submitting the Exercise

In the box below, name the primary key column in the Clients table and the foreign key column in the Tasks table, then click Submit to check your answer against the Results page.