Managing Constraints   «Prev  Next»

PRIMARY KEY Constraints - Exercise

Course Project: Using primary Key Constraints

Objective: Create primary key constraints for the COIN database

Exercise Scoring

This exercise is worth a total of 24 points. Each completed block of code is worth 4 points. You will be graded on completeness and correctness of code. When you complete your answer, submit your answer.

Background and Overview

Earlier in this course, you created a script file with the SQL statements needed to create the tables in your COIN database. In this exercise, you will modify those scripts to include primary key constraints.
  • Download files: You can download a correct version of the script for this exercise, primarykey.sql, from the project download file found on the Resources page.
  • Instructions: Add a primary key constraint for each table in the COIN database.
  • Hints: You can create a primary key that includes multiple columns by listing the columns, separated by commas.

Submitting your exercise

Submit your answer in the text box below.