Summer 2010

Lab04
Identifying Keys

Due: Friday July 02, 2010 11:59 PM

Lab04 - 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.