Ace engineering academy DBMS functional dependency

Question

Level 1 question 3 .

 

03. R(ABCDE) and F {A B, BC D, D BC, DE }

Find the no. of redundant FDs in F

 

(a) 1 (b) 2 (c) 3 (d) 4

 

Answr is 1. Please explain how it is.

Comments

For each Functional dependencies we will create a new table

So, we will get

AB      BCD     DBC      DE

four tables, but here BCD and DBC are same so one of them is redundant.

---

Isn't there any FD ?