Objective

To identify candidate and primary keys in a database

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.