RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Building Database
Relational Concepts
«Prev
Next»
SQL Database Creation
SQL - Server
Relational Database
Client Server Architecture
SQL Server Services
EM Administer SQL-Servers
Database Relational Concepts
SQL Server Tables
Data Integrity Elements
Business Rules
Database Normalization
Data Normalization
Database Denormalization
Primary Keys Unique Constraints
Foreign Keys
Relational Concepts
Column Attributes Table
Table Columns Types
Specifying Length Precision Scale
SQL Allow Null
Specify Default Column Values
Table Identity Columns
Rowguidcol Attribute Flag
Create Transact SQL Datatype
TableColumn Attributes Conclusion
SQL-Server DB Tables
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 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.