Question Details

R(A B C D E)


F = {A→ BC, CD→ E, E→A}


Which of the following is correct?

Options

A

A and ED and CK

B

AD, ED, CD are CK

C

A, E, C, D and CK

D

A, E, CD are CK

Show Answer

Correct Answer :

Option B

AD, ED, CD are CK

Solution :

The correct option is AD, ED, CD are CK (Candidate Keys).

To determine the Candidate Keys (CK) of the relation RABCDE with the functional dependencies (FDs) F=ABCCDEEA, we need to find the attribute closures that can determine all the attributes of the relation ABCDE.

Let's analyze the attribute closures for the combinations given in the correct option:

1. Finding the closure of AD, denoted as AD+:
- Start with the initial set: AD+=AD.
- Since ABC, we add B and C to the closure: AD+=ADBC.
- Now we have C and D in the closure. Since CDE, we can add E to the closure: AD+=ADBCE.
Since AD+ contains all the attributes of relation R, and no proper subset of AD (i.e., A or D individually) can determine all attributes, AD is a Candidate Key.

2. Finding the closure of ED, denoted as ED+:
- Start with the initial set: ED+=ED.
- Since EA, we add A to the closure: ED+=EDA.
- Since ABC, we add B and C to the closure: ED+=EDABC.
Since ED+ contains all attributes of R and is minimal, ED is a Candidate Key.

3. Finding the closure of CD, denoted as CD+:
- Start with the initial set: CD+=CD.
- Since CDE, we add E to the closure: CD+=CDE.
- Since EA, we add A to the closure: CD+=CDEA.
- Since ABC, we add B to the closure: CD+=CDEAB.
Since CD+ contains all attributes of R and is minimal, CD is a Candidate Key.

Therefore, AD, ED, and CD are all Candidate Keys of the relation R.

Unlock Our Free Library

Access expert-curated educational resources and study materials—completely free.

Ask AI Tutor
5 left
Q1 View Question & Options
AI Tutor is solving this question...
Reading question context & options...