For relation ABCDE that has functional dependencies AB C C

For relation = ABCDE that has functional dependencies:

AB -> C

CD -> E

DE -> A

Convert this to BCNF.

Solution

Decompose the relations into collections of relations that are in BCNF. (ABCDE) Break down (ABCDE) with CD->E (ABCD) and (CDE) Break down (ABCD) with AB->C (ABC) And (ABD) So we get R1(ABC), R2(ABD) and R3(CDE) ,3 relations in BCNF
For relation = ABCDE that has functional dependencies: AB -> C CD -> E DE -> A Convert this to BCNF.Solution Decompose the relations into collections o

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site