Lec-26: Boyce Codd Normal Form

👉Subscribe to our new channel: / @varunainashots
► Database Management System(Complete Playlist):
• DBMS (Database Managem...
Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
• Design and Analysis of...
►Computer Architecture (Complete Playlist):
• Computer Organization ...
► Theory of Computation
• TOC(Theory of Computat...
►Artificial Intelligence:
• Artificial Intelligenc...
►Computer Networks (Complete Playlist):
• Computer Networks (Com...
►Operating System:
• Operating System (Comp...
►Structured Query Language (SQL):
• Structured Query Langu...
►Discrete Mathematics:
• Discrete Mathematics
►Compiler Design:
• Compiler Design (Compl...
►Number System:
• Number system
►Cloud Computing & BIG Data:
• Cloud Computing & BIG ...
►Software Engineering:
• Software Engineering
►Data Structure:
• Data Structure
►Graph Theory:
• Graph Theory
►Programming in C:
• C Programming
►Digital Logic:
• Digital Logic (Complet...
---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
► Subscribe to us on KZbin: / gatesmashers
►Subscribe to our new channel: / @varunainashots
► Like our page on Facebook: / gatesmashers
► Follow us on Instagram: / gate.smashers
► Follow us on Instagram: / varunainashots
► Follow us on Telegram: t.me/gatesmash...
► Follow us on Threads: www.threads.ne...
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Email us at: [e-mail]
#BCNF#BoyceCoddNormalForm#DBMS

[@nev404_]

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.

[@student6555]

If you're able to speak or understand hindi then definitely you'll fall in love with these lectures.

[@Fujihanabi-r1b]

Thats good to hear buddy

[@jokestudio15]

wow!

[@Gamingpotatoxx9]

Which country you r from

[@harshita4427]

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

[@novicemakers_abhishekkamal]

I prefer 1.5x👍

[@shishirpaudel5329]

Me too alwayd

[@novicemakers_abhishekkamal]

@@explorer2375 🙄

[@novicemakers_abhishekkamal]

@@explorer2375 you are so sweet can we contact

[@shreyachavan5904]

Same

[@abhinavmathur6072]

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!!

[@legitfan]

Chtya jaisa to padha tha hai ye

[@gauravkumarsingh2904]

All the lectures of this channel are superb and have appropriate and excellent content. The way of explaining things is outstanding....this is probably the best channel for students who want to learn DBMS 👍👍

[@GateSmashers]

ThankYou Gourav...Your appreciation motivates me a lot..GOD bless you..Keep learning and sharing.. I have also completed operating system..

[@ManishRajput-cq5tj]

Bro it's been 5 years now could you tell me what are you doing now

[@harshitharshmusic810]

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

[@kunalnalawade8822]

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.

[@o8juhikumari311]

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...😊

[@ashiwanikasera6229]

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.

[@TooModernArt]

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

[@sneyeahhh6298]

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

[@ayushjaiswal7298]

Can we talk?

[@sharonjoseph4091]

Aj se pehele kisi ne itna acha nhi samjaya. Appreciated for all the efforts.

[@GateSmashers]

Thank You for your love and support. Bless you

[@sharonjoseph4091]

Gate Smashers bless you too

[@tilakdavidd2358]

nice teaching, excellent teaching. Writing and talking in English helps me to understand. I love you brother.

[@smartcoding174]

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

[@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

[@asnamalik9004]

I just want to tell you that your way of teaching is superb. God bless you Sir.

[@vikasjha1064]

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

[@sadhanapidikiti3240]

From the starting to the end of the video he means alot i mean every word he utter has its precise teaching the best tutor i have ever seen

[@rajshekarpeter]

Explanation is flawless n very clear

[@educational9545]

Thank you sir for giving excellent teaching on Normalization in DBMS.

[@vanidasan9792]

Very clear tq so much sir.............very good explanation in exam point of view.............

[@wgwvwshsusbswhw235]

I am doing software engineering from Pakistan and from semester 1 i am watching your videos before one day of exam and get good marks your videos are very helpful in completing my degree you make videos on each subject of Software engineering Thank you so much

[@SANDHYALALKUMARSANDY]

Really great lectures. Super duper.

[@ashishtayade047]

Thank you sir very nice gide & very nice best boyce codd normal form teaching information video.👍

[@yogeshpandey9549]

Best educational content creator!!🙌

[@Akash-ry4dj]

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

[@GateSmashers]

Thank you so much.. Keep learning and sharing

[@gujjucarry848]

Vaise to ladka hu pr tera dedication dekh ke kiss kr ne ko mann kiyaa Bro tu great hai yrr 🙏🙏🙏🙏😘😘

[@payel9646]

You are doing such a great job sir ! I have learnt DBMS from u.Ur explanatios are very simple nd to the point ! Keep it up ! Looking forward for your help for the next semester also .

[@aanchalaggarwal6073]

Sir u are great 👍👍 your way of teaching is excellent.. Because of you I always perform well in the exams... Thanks a lot for your lectures 🙏🙏 🙏 🙏 🙏

[@kartikranadhikka972]

Thanku sir you are my favourite teacher

[@surajpathak9659]

Excellent teaching sir.... Great teacher u r.. Outstanding ☺☺☺

[@shamsashah3509]

Your way of teaching is superb

[@chaitanyahanda1123]

bhaiyaaa maujjj kradiii, ty sirrr maza aagya padh ke !!

[@thechuckles5675]

Bhat sahi explain krte ho aap

[@anamikasoni6043]

Excellent teaching in a very simple manner....

[@pallavicharnalia1287]

YOUR way of teaching is really good sir, well explanation of all concept sir

[@anjusharma7258]

Thank you very much sir🤗🤗🤗 ..That is my final exam of dbms yesterday ... but I did not understand the topic of normalization and their forms ...🙄🙄🙄 Trust me ... After watching all your videos related to this topic 🤗🤗... I could easily understand it - thanks a lot ..😚😚😚🙏🙏🙏..

[@wasifirshad9818]

Sir you teach really well. Huge Respect

[@FlutterWithRaman]

Today is my exam and I am learning from your lecture now I am not tense about my exam

[@GateSmashers]

All the best

[@FlutterWithRaman]

@@GateSmashers thanks sir for the great explanation my exam got superb. Thanks for the awesome teaching.

[@shiviaggarwal9429]

Nice your lecture Sir

[@ashabadal5798]

Sir you are a great teacher

[@varanasisriharshgupta9757]

Thank you Sir, your lectures are literally very good Sir.

[@poojakumarirollno9880]

Thank you so much sir your explanation is to good for understanding purpose it's becoming very helpful in exam sir so thanks again sir

[@mehakdeep6771]

Waheguru Ji bless you veer ji and your family veer ji ❤️❤️🙏🏻🙏🏻

[@legolas1523]

Thank you sir for great and easy explanation on Normalisation topic...keep uploading more videos I want to learn DBMS from your video lectures...beacuse they are easy to pick ...thnxx ❤️❤️

[@Farahat1234]

I watched many videos on this topic but i did not got, now i am happy that i am prepared for my tomorrow's DBMS paper, thankyou soo muchh sir, you are Smart+ Intellegent+Handsome😊

[@GateSmashers]

Thank you so much.. All the best

[@aakashsharma7604]

sir thank you very much understood all forms in one go

[@Aviman_Bhawarjar]

Very good explanation 👍

[@diaworld7166]

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 ...

[@mohammadsakifibnyousuf6396]

Love u brother.. hats off to ur teaching style..💜💜 it would be of much better help if u could upload the video for 4th and 5th normalization... waiting for those...😊😊

[@maryamumair8634]

Love your teaching method sir💖

[@meetpopat1261]

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

[@shreerambhat1442]

exactly

[@rudranshsinghathwal4513]

Roll no and Voter I'd are two different candidate keys so rollNo is not a proper subset of Candidate Key and hence this is in 2NF

[@kirandoomraarora7191]

thnku sir...a gya smaj

[@aritribera1355]

Thanks a lot Sir.Excellent teaching

[@bhishamlalmandle5390]

Nice video thank you sir

[@FaizanAhmed-yq9re]

good explanation

[@manvirkaur1568]

Best explanation ever

[@sunandanjakta2383]

Great videos sir

[@ArvindSingh-wj7vy]

Thank you sir. The way you teach is so good You makes every topic as it is very simple.

[@technicalhacks5798]

I refer many books but the content you gave is the best thankyou so much sir

[@ARNABDEYcr]

Awesome

[@tanzimibthesam5861]

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

[@AK-us1by]

Nicely Explained.

[@bhumikasatpathy832]

The example that you have mentioned in the beginning, doesn't satisfy the 2NF condition, right? Because in 2NF, the LHS has to have a subset and not a proper subset of candidate keys like mentioned in your previous videos. Please kindly clarify!

[@akankshajha348]

That is the condition when there is a composite key but here there are two primary keys and not a composite key too late for the reply ik

[@farhamasroor0786]

Sir plzz get a video on 4NF and 5NF and also on Mulitivalued dependencies..Will be waiting for your videos on these topics..

[@vickytricky5571]

Yeap,am also

[@vaayuo]

I think it's kinda wrong because of votrid->roll no as rollno is a prime attribute and bcnf says prime attribute shouldn't appear on the RHS

[@ragnarT3]

No on rhs anything is possible Only on lhs we must have CK

[@vaayuo]

@@ragnarT3 oh To be honest I don't remember anything it's been an year

[@Harpreetkaur-fd5fu]

Great explanation sir.. ⚡💫

[@prateekdwivedi6134]

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

[@cybersuvash2303]

votarId also determine Rollno then VotarId+={votarId, age, Rollno,Name} so it is a Alone Ck as well , so it is valid.

[@triptisingh7435]

Thank u so much sir. Thanks a lot for your free lectures. Sir if possible pls upload videos on algorithm, c programming and data structures . May ur effort gets rewarded.

[@Mylikes929]

Supperb bro.. Thank you.. my doubt was cleared with Ur video after lots of other videos

[@AartiSihag-if3hk]

Perfect teacher 💎

[@tuttyfruity4665]

amazing keep it up

[@poojaagarwal6296]

Your all video is superb nd plz upload the video of 4nf nd 5nf form of normalization

[@aravinds6305]

Thank you so much. Really helpful

[@Nia_215]

Nice way of teaching 👌

[@exclusivefacts8956]

Neat explanation,thank you sir!

[@saptarshichattopadhyay8234]

Thank you so much Sir...

[@ayushshah9797]

this normal form is not is 2nf as name which is subset of non prime attributes determined by proper subset of candidate key which is Roll no ? Can you explain?

[@AbhishekRaj-hv1nv]

no there is no violation as Roll No and Voter id are two different candidate key and that is not proper subset of candidate key. Non-prime attribute is determined by candidate key. Hope u got your answer.

[@TusharGodage-ci4od]

DBMS playlist 2018 and in 2024after 6 years stil as best playlist on whole KZbin ❤🔥😍🫡🫡🫡🫡🫡🫡🫡🫡🫡🫡🫡🔥🥵

[@deepakpandey8752]

Thank you very much.

[@adityaaryan2412]

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 ???

[@priyankvashist4103]

Thanks for your efforts.......... commendable job sir :)

[@explorer2375]

I always prefer in 2x ... If there would be greater than this speed I definitely prefer that😊just awesome lectures 😌😌thnk you sirji

[@aneeshsagiraju3985]

Sir your speed is suitable for 90% of the students so maintain the same speed.

[@mehakdeep6771]

Waheguru ji bless you and your family veer ji ❤️❤️🙏🏻🙏🏻

[@harshdeep1953]

in 1st example don't you think there is partial dependency as voterId which is part of candidate key can determine non-key attribute

[@brahmananda1143]

thank you sir for last minute revisions❤️

[@udbhavdave]

Sir please make a video on 4NF also.

[@GUJJARVLOG295]

Superb sir❤

[@adityadhanwai2522]

Sir, The table is not in 3NF as it is not in 2NF bcz proper subset of C.K (Roll no.) is determining a non prime attribute that is name.

[@MohdUsman-tv1ez]

roll number is a candidate key, so if a candidate key is determining the non prime attr, it is valid and in 2nd nf. If candidate key is a composite candidate key and a part of candidate key is determining the non prime attribute then it will not be in 2nd nf.

[@salmanghani9171]

Roll no must be primary key because Roll No is unique

[@sriyakolluru9700]

Sir the last diagram was reverse i guess because 1nf is followed by all... universal set will be out of all the subsets ??

[@suidheer]

Hi, I'm really happy to see these videos. Wonderful explanation. In this particular video I have a doubt. While considering the FDs you have skipped another FD ROLLNo -> Age. Is it also a FD that we can consider?

[@AayushGoyal]

Sir I think last diagram mein, center me 1NF hona chahiye and last circle me BCNF. Because, inner most circle mein jo bhi hain wo definitely outer circle ke part hai but outer circle wale elements jaruri nahi inner circle ke ho.

[@memorableshots2905]

Exactly

[@AayushGoyal]

@@memorableshots2905 are you preparing for gate?

[@memorableshots2905]

Nope. I'm from pakistan

[@SadhanaAwasthi-pp3ej]

Thank you sir

[@sasidhardontu5659]

@Gate Smashers sir, in the given example, roll.no-->voterid, voterid--> age is a transitive in nature ,right!. it violates 3nf. also please clarify how bcnf is a unique concept in comparison to 2nf ,which actually state l.h.s should be superkey that implicitly removes partial dependencies what a 2nf do specifically.

[@dwijeshsaikia8218]

sir you didn't teach about 4th,5th and 6th normal form...... i need it for my BCA 4th sem examination..... plz make videos on that

[@informatics4374]

Good morning sir In the above dependency roll determine voterid and voterid determines age that means rolls determine age which is transitive dependency. Then how will this table be in BCNF. Kindly explain I m confusing. Thanks

[@nivi6414]

Transitive Dependency is when the LHS and RHS both are non- prime attributes. Here prime attributes are {roll no, voterid} and non prime attributes are {name , age}.

[@shrutikanikhar7987]

VOTER ID is not a non prime attribute

[@deepakpandey8752]

Thanks sir 2021 worth watching it.

[@rohanshah6187]

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

[@soumyadeeppatra5478]

exactly that's what i'm thinking

[@shubhdeepsingh3]

Thanks!

[@rebithakr8112]

Sir ..Is it in 2nf? Roll _> name violate 2nf.there is a partial dependency

[@nitaisutradhar4884]

no

[@nag0074]

there is no partial dependency. as the name is fully dependent on the candidate key which is roll.

[@parulkoli4355]

I have same doubt

[@movvamanish1467]

Yeah bro I got same doubt

[@ayushshah9797]

@@nag0074 Can you elaborate?

[@piyushtripathi5566]

Thank you sir ❣️