Threesuns

Email

Contact

All Semesters

Semesters

All Courses

Courses

Database Design

CSYS2643

3 credits

Labs

Identifying Keys

Lab

100 points

Requirements

Candidate keys are identified50
Primary Keys are identified50
Total100 pts

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.