##
**Set of solved exercises in
Normalization / Normalization Solved Examples / How to find candidate keys, and
primary keys in database? / Sets of examples to find the keys of a tables /
Process of Key finding in a database - Examples**

__Question:__
Consider a relation R(A, B, C, D, E) with FD's AB → C, CD → E, C → A, C → D, D → B.

Determine all the keys of
relation R. Do not list superkeys that are not a candidate key.

__Solution:__

__Key 1:__
From above points, we would know
that the attributes AB together can identify all the other attributes of R uniquely.
Hence,

**AB**is one of the keys.

__Key 2:__
From AB, we can obtain the rest
of the attributes. (See the discussion in Key 1 above). Hence,

**C**is one of the keys.

__Key 3:__
From AB, we can obtain the rest
of the attributes. (See the discussion in Key 1 above). Hence

**AD**is one of the keys.
The keys are

**AB**,**AD**, and**C**.**Go back to Normalization - Solved Exercise page.**

## No comments:

## Post a Comment