Lec-26: Boyce Codd Normal Form #BCNF #DBMS #Normalization with best examples

► Database Management System(Complete Playlist):

Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
►Computer Architecture (Complete Playlist):
► Theory of Computation
►Artificial Intelligence:
►Computer Networks (Complete Playlist):
►Operating System:
►Structured Query Language (SQL):
►Discrete Mathematics:
►Compiler Design:
►Number System:
►Cloud Computing & BIG Data:
►Software Engineering:
►Data Structure:
►Graph Theory:
►Programming in C:
►Digital Logic:

---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:

#BCNF#BoyceCoddNormalForm#DBMS

[nev_]

I speak Spanish (I'm from Latin America). And of all the videos in my language that I saw, with none I could understand or only found complicated explanations and mostly without examples. And I find it incredible that I ended up in this video and with the subtitles I could understand much more than with any other video. Step by step and simple explanation. This is how everyone should teach. Thank you very much, greetings.

[harshita]

I watch your videos on 2x and that's just amazing as well as time saving

[abhinavmathur]

I'm currently in this leacture and not bored for even single second...the way he teaches is godly...
Just want to write my opinions... Thank you Varun sir!!

[harshitharshmusic]

One of the best DBMS teacher one could get . Amazing sir, looking for more from you .

[kunalnalawade]

Hats off to you, sir! I have seen Normalization questions in so many interviews which has made me nervous about this topic. This is such a difficult concept to understand, but the way you explained all the details was simply brilliant. Watching your videos has quelled my fear of Normalization.

[ashiwanikasera]

Sir hats off, I am from ECE background and working professional as AEE in PSU last 3 years but still I am understanding your all vedio. Its amazing teaching style. With love 🙏🙏🙏 for delivering the best content for us.

[prateekdwivedi]

Voterid is defining age which is non prime attribute and voterid is a part of candidate key isn't that partial dependency...anyone ????

[ojuhikumari]

I recently admissioned in bca and for first semester I have to learn DBMS thank God I got ur channel, I hope atleast I will get help in tougher chapters from ur videos .Thank you sir for helping us...😊

[alankarjamle]

Sir, the two gems in your lectures are first your explanation in hindi and second is your examples relating with real world.

[sneyeahhh]

Sir YOU ARE GREAT !! Literally conquered a 5 mark question in 5 minutes! Hat’s off to you👏🏻

[vedant_dhamecha]

00:03 BCNF is a more restrictive form compared to 3NF
00:50 Candidate key is important in functional dependencies.
01:36 There are two candidate keys in the table.
02:21 Functional dependency and candidate keys
03:23 Voter ID is a candidate key and all functional dependencies are given in the table
04:17 The table should be in BCNF and the third normal form
05:13 The Second Normal Form
06:05 To determine if a table is in third normal form, check for transitive dependency

[meetpopat]

In this example, rolln0 -> name, is it in 2nd normal form ??
We are checking BCNF, but it is not even in 2nd normal form

[vikasjha]

Gajab air Kya padhate ho
Sir aap isi Tarah you tube pe free classes continue rakhiye
Aur sir languages ki playlist start kijiye
Jaise Java, c, python ki

[diaworld]

sir roll number alone c.k. kaise bna h yaha pr ?...jbki c.k. { rollnoVoterid } dono h...isse phli wali video me toh aapne mna kra tha ...3nf wali video me 2nd example me jb usme{AB CD } 2 c.k thi toh c ->b f.d. me aapne mna reject kr diya tha ...

[smartcoding]

I always depend on your channel for my preparation.. thanks a lot for the most understable lectures...😊

[vanidasan]

Very clear tq so much good explanation in exam point of

[Akash-rydj]

Your hard work and dedication reflect on your you sir....keep it up and I wish that 1M should cross as soon :)

[rohanshah]

isnt voilating 2NF? rollno determining name as roll no is proper subset of CK

[tanzimibthesam]

As per my knowledge to be even 2NF every non key attribute must be part of entire composite primary key. Here isnt name partially dependant on voter_id and age partially dependent on roll_no.Would love a clarification thanks

[adityaaryan]

I have a doubt, this particular example does not satisfy 2NF or 3NF right ? cz PA:{Roll No., Voter Id} NPA:{Name, Age} and the very first FD is Roll no. --> Name. Here a NPA is dependent on a PA so it should be false for 2NF and hence for 3NF ???