About

I am too Lazy to update about me.

Role

Alma Mater:

Not updated.

Experience:

Not updated.
Babytud
Answer
1 year 8 months ago

Clearly, this is in 1NF form.

and candidate keys are {AB,AC,BC}

FDs violating 2NF,3NF and BCNF are:

AD->E, B->D and E->G

and the corresponding decomposition into BCNF will be

R1(ADE), R2(BD),  R3(EG) and R4(ABC).

 

You can also verify the decomposition by checking that it is a lossless decomposition.

moreless

<div class="tex2jax">Oops....!! Find someone to follow. You are not following anyone yet.</div>

pritam's picture
Pritam Prasun
905
sumitverma's picture
Sumit Verma
10677
nandini
23797
devika vasudevan
38665
9 Nov 2016 - 1:14pm

Clearly, this is in 1NF form.

and candidate keys are {AB,AC,BC}

FDs violating 2NF,3NF and BCNF are:

AD->E, B->D and E->G

and the corresponding decomposition into BCNF will be

R1(ADE), R2(BD),  R3(EG) and R4(ABC).

 

You can also verify the decomposition by checking that it is a lossless decomposition.

more less