Database Web Apps
SQL Database Creation
SQL - Server
Client Server Architecture
SQL Server Services
EM Administer SQL-Servers
Database Relational Concepts
SQL Server Tables
Primary Keys Unique Constraints
Column Attributes Table
Table Columns Types
Specify Default Column
Create Transact SQL Datatype
Defining primary and foreign keys - Exercise
Identify primary and foreign keys in two relational tables.
This exercise is worth a total of 2 points. It's auto-scored, which means that when you have completed it, click the
button below to receive full credit.
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?
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
below to check your answers against those supplied on the Results page.