For each of the following sets of functional dependencies on a schema r(A, B, C, D, E)

AB --> C, D --> E, B --> E
A --> CD, B --> DE
AB --> C, C --> D

For each of the above set of functional dependencies, decompose relation r into BCNF

how to decompose r into BCNF of above relation r?

Recommended Answers

how to decompose r into BCNF of above relation r?

Look at this pdf file which has an example you can used:‎

and look at this which has some explanation:

Jump to Post

All 3 Replies

i had found explanation link but example link is not working.

Thanks a lot..

Member Avatar

So you haven't solve this problem for 3 months?

Closure can easily be computed by applying Amstrong's interference rules (reflexity, transitivity, augmentation). For example you may start this way:

a) A -> A (reflexivity rule)
b) A -> ACD (a + transitivity A->CD)
c) A -> ACDE (b + transitivity D->E)

d) Now it's your turn (apply the missing one :)

You already know the meaning of the result?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.