Threesuns

Email the Instructor

Contact

All Semesters

Semesters

All Courses

Courses

2010Spring

01.11.10 - 05.09.10

Database Design (Online)

CSYS2643

Online
12:00 AM - 12:00 AM

Identifying Keys

Lab04

Objective: To identify candidate and primary keys in a database

pastdue

Submit Your Solution

Lab04

Requirements

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

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.