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
What Is Relational Database
Client Server Architecture
SQL Server Services
Starting SQL-Server Services
SQL Server Installation
SSMS Administer SQL-Servers
Query Analyzer
SSMS Wizards
SqlServer Overview Conclusion
Database Relational Concepts
SQL Server Tables
Data Integrity Elements
Business Rules
Database 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
Sql Server Databases
Database Permissions
Database Elements
Transact Sql Statement
Modifying Databases
Create Manage Filegroups
Drop Database
Database Table
Transact Sql Table
Alter Table Modify
Delete Table Sql
Transact SqlSyntax Conclusion
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 ID
Client Name
Client Contact
101
Strategic Innovations Consulting
Anthony T. Mann
102
XYZ Corporation
Walt Walters
103
ABC Industries
Matt Matson
Tasks
Task ID
Client ID
Task Name
1
101
Identify Requirements
2
102
Develop Application
3
103
Unit Test
4
101
Integration Test
5
101
System 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.