How to perform 3NF Decomposition and BCNF Decomposition?

In this video I go over how to perform 3NF Decomposition and BCNF Decomposition to bring relations into a stable Normal Form.

[qanda]

Hi everyone! Yes you're right, for BCNF at 6:12 it is R-X and XA, not R-A and XA.
I didn't say it correctly, but it is written correctly.
Thank you for everyone that pointed that out! 😊

[Clara-qmdp]

This is much more useful than what my lecturer said in class, thank you very much

[evelynsun]

the candidate key for first question in 3NF should be ACDF? Since E can be determined by ACD already

[scorpionedge]

for BCNF its not R-X and XA its R-A and XA.

[alankotlyar]

Thank you! Why is that the candidate key is included among the relations in the first example (2:51) but not in the second (5:50)?

[VAMSIKRISHNA-krqf]

At 2.43 the candidate key u have mentioned is wrong it acdf from acd u get e so no e is required....for me the video was good . Thank you

[m.preacher]

5:47 why u wrote so many relations? ADFHG includes alrady part of the candidate key(AD)

[NosamFree]

3:40 why we dont delete AEH -> B hence we already have A->B ?

[prandrex]

Excuse me but, at 6:45 you say R2(BCD) because it's R-A, but the dependence is D->A so D is our X and R-X is R1(A, B, C) and R2 (A, D) or is it wrong?

[ohhhbirdy]

I get lost at 1:50, how does abcd equal abcde when it's not anywhere on the right side? I seriously can't understand BCNF for the life of me

[alldayforgotten]

thank you, this is excellent explanation! you have a very nice voice and handwriting

[Mrdotcom]

For the example starting at 2:52, is it possible to get two (or more) different minimal bases?

[luigidorigatti]

Great video! How do I find the Candidate Keys(ck) once I split the violation into 2 relations? For example at @7:11 where they are -BC and A-? Please answer me I have a test!

[Jsheng]

The last example of BCNF, why R4 is in BCNF?

[vishnuvardhan]

I think BD is not bcnf for the last question

[eugeneku]

pretty voice, best explanation that solved my troubles during past 6 hrs

[axela.]

You dont explain what BCNF is to begin with

[areebans]

try not erasing lines(they are usefull too)...great explaination though!!!

[anky_arts]

You're really good at explaining terms,
Can you make similar type of playlists for OOP USING C++ AND RDBMS

[shaqtech]

Awesome tutorial, easy to understand!