Boyce Codd Normal Form | Database Management System

IMPORTANT LINKS:
Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share!

Our Social Media Links:

Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.

[souravghosh]

Finally somebody explained it without technical gibberish... thanks !

[sachinpal-powl]

the explanation is perfectly correct. If somebody is not able to understand then make sure that u have understood the previous normal forms correctly rather than pointing out problem in concept.

[harjotsethi]

You are god god god ....maza agaya yrrr faad di ek dum bahoot ache se samjhaya hai

[laurentiutrifan]

Great videos and straight to the point explanations. Thank you sir.
There's one thing unclear though: I thought I understood that being in 3NF means 2NF and 1NF are achieved. Now, to be in 1NF, one FD must have atomic values (RHS). In this case, A->BCD should had the form A->B, A->C and A->D. Did I misunderstood something? (or was just a shortcut?) Thanks.

[jinip]

Great sir expecting more vedios for gate

[cnsnmms]

Thank you for your tutorials but I think you should correct all the errors before uploading or upload correct versions after an error. Thanks again.

[stefanstamenkovic]

We moved d->b into second relation so we could make BCNF but shouldn't that already be done to make 3NF?

[rahuldas]

what you are saying that
A -->BCD
BC -->AD
D -->B is in 3NF but if you see closely that C.key here is A, BC and also non-prime attribute B is dependent on another non prime attribute D which violates the condition of much confusing.

[financialliteracy]

thanks a lot for uploading the videos and solving our

[AkshayKumar-zhtn]

sir, here B is being determined by D and B&D both are non prime attribute so how it i in 3NF.

[KishoreKumar-isqn]

thanks for the awesome tutorial. please include 4nf videos too

[abhisheksuman]

along with BC and A is DC is also a key??

[VikasAgrawall]

Siddhi Viradiya It is not in 3NF as you can see CD is a candidate key and in FD D->B, D is a Part(ck).
 so it is violating the rule of being in 3NF.

[iamkevinsingh]

What lab microphone are u using ... Company and model

[Sem]

he certainly does alot of detra-mining

[AnujaTayal]

when we broke the relation in R1 and R2 then in R1 how can it be C -> AD??

[vaibhavanandsharma]

the example has changed from what was taken to explain the previous D-->B where did that come from?....or is it just taken to explain the concept..

[iremguner]

thank you very much.. these videos helped me a lot !

[SahilThakur]

the given example is not in 3NF form and you are using it for BCNF as per your stated definition.

[saiakhilgorijala]

can u explain normalization with relation table examples