Summer 2012

Lab03
Identifying Keys

Due: Thursday June 21, 2012 11:59 PM

Lab03 - Identifying Keys

Requirements

Candidate keys are identified50 pts
Primary Keys are identified50 pts
Total100 pts

Resources

Objective

To identify candidate and primary keys in a database

Instructions

Based on the preliminary table list from the previous lab, review each table and identify all candidate keys and one primary key for each table. Make sure that the candidate keys conform to the Elements of a Candidate Key.

Record all of the candidate keys (ck) and all primary keys (pk) in your table/field list and submit it as the solution to this assignment.