Questions 1 2 Given Relation R B C D E Identify Candidate Keys Fds C Bd D E Fds Ab C C D B Q37200858

Questions 1 and 2. Given a relationR={A,B,C,D,E}

Identify candidate keys

1. FDs:

A → C

BD → A

D → E

2. FDs:

           AB → C

           C → D

           BD → E

---

Answer

---

1) A C

BD A

D E

The relation R(A,B,C,D,E) does not include B and D in the righthand side of the functional dependencies. So, BD should be includedin the candidate key.

The closure of BD = {BD}+ = {BDA} (as BD A)

= {BDAC} (as A C)

= {ABCDE} (as D E)

So, BD