#Normalization

Question

Consider the realtional schema R1(A,B),R2(A,C) the only dependencied that hold on relations in this are BC->A,A->CC and all dependencies that follow from these two .It is in which normal form?

Answer 1

I think it is in BCNF.

As for R1, AB is candidate key so there is no partial and transitive dependency
and for R2(A->C) here also we don't have any partial and transitive dependency , so both are in BCNF.

Comments

You are saying BC->A is redundant bcz B is not in R2(A,C).Is this the way we dont need to consider that FD

---

correct

---

@priya. An FD is redundant only if you can derive that FD from remaining FD's. Here you cant derive that FD from other FD's. So, its not redundant.