4.12 How To Identify BCNF Boyce Codd Normal Form

[@aayushagarwal5666]

We went on distributing sweets to our college teachers upon placement..Then I felt the one who deserved them most were channels like yours, Ravindrababu sir etc..Thanks Sir !!

[@SumitKumar-je9pr]

what was your package???

[@kalm4757]

Which college/institute, what package u got? What course and branch? How many years experience u had or fresher?

[@agyaani8060]

I have a Q What topics should I focus on for placement in dbms i m not preparing for gate... I only want to study it for placements.

[@zorith]

How's everyone?

[@adityaHB456]

teacher-What is normalization ? me-"jo neta banna chahta hai use banne do.."

[@nimranimramaqbool9028]

😂😂good one

[@chetannamne9890]

True question

[@devkumar9889]

True

[@-preronachaudhuri1869]

you have always been a stress buster whenever i am stuck with a concept that too ,the night before my exams :D thanks!

[@KNOWLEDGEGATE_kg]

For complete DBMS, check out this video: kzbin.info/www/bejne/j4PRm3qbhsemfrM

[@KNOWLEDGEGATE_kg]

🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg 🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg

[@arpitsaxena5972]

You just do very well very great....i don't have words to explain that how worthy your lectures been...🖤🖤🖤 thanks a lot sir

[@KNOWLEDGEGATE_kg]

So nice of you, Visit tiny.cc/yt_kgwebsite for more helpful content and courses👍

[@sadaffatima2076]

Aap har tough topic ko itna easily samjha dete h....u r great....Sach me..u r great

[@kk-op6qg]

Jo neta banna chahta hai use neta banado 😂 Superb sir superb 👌🏻👏🏻 I want u as my professor

[@ifrahkhan6957]

i wish u get billions subscriber for this entire hardwork .

[@reenathomas7936]

thank you, sir... Actually, I am a Keralite. I don't know much more Hindi. Then too I can understand these topics. Your way of explanation is very nice .

[@deepjyotibasu5077]

I owe you my semester grades, sir.

[@shrishtymishra374]

Thank you Sir....I have watched this playlist of DBMS.....I started liking the subject... all because of you...U r great teacher with marvelous teaching skills and the explanations are very easy and can be easily memorised

[@anuragpratap6826]

chlo acha bkwas na karo jyada, bail

[@alberteinstein4123]

Thank you so much sir... I'm feeling confident now for my exam...

[@khushi_jha16]

Einstein

[@nileshvishwakarma5653]

sir you are the best ! na aapke jaisa koi hua tha na hoga

[@abhishekprajapati6712]

THQ sir your each and every lecture beneficial for my exam.. ❤️❤️🔥💯

[@ujefmalek77]

You are amazing teacher ❤️🙏🏻

[@redrose5950]

Thank you So Much for your efforts and great lectures.

[@KNOWLEDGEGATE_kg]

Thank you so much.. Keep learning and supporting.. Do visit our website www.knowledgegate.in for more courses and contents.

[@yashthakur9393]

sir what a explanation love you sir please keep making this type of easy to understand stuff thank you very much -- a general gate aspirant

[@KNOWLEDGEGATE_kg]

Glad to know that Yash.. Thank you so much for your feedback. Stay blessed. Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses and contents.

[@swapnilgundre88]

Sir, you are really great. Cleared all the doubts. Thanks a ton

[@KNOWLEDGEGATE_kg]

You are most welcome,Visit tiny.cc/yt_kgwebsite for more helpful content and courses, 👍

[@vinayaksharma-ys3ip]

Very very helpful lectures Sir.......💯💯💯👍

[@KNOWLEDGEGATE_kg]

Thanks a lot dear Vinayak..keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@narendraparmar1631]

Learn some new concepts today. Thanks sir ji😆

[@digambarpatil5019]

this man is gem 😍

[@redrose5950]

Very well explanation Sir,

[@akhilsinghsanoria4666]

Sir it is not dependency preserving decomposition so make Second table as AB not AC then it will be dependency preserving ,love you sir

[@jatinsharma4313]

Great sir💪

[@KNOWLEDGEGATE_kg]

Thank you❤ Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@pradeepkumarsingh6964]

thnk u sir , for ur free means of knowledge sharing

[@satyamkarki1675]

i have exams day after tomorrow.. and im gonna pass that shit..(re exam though) lots of love from KU..

[@gavalinilesh80186]

Regards. This is excellent !!!

[@masleniamubarrat2710]

Respect From Bangladesh

[@KNOWLEDGEGATE_kg]

Thank you dear, keep learning & supporting..

[@NishaSharma-nd1dk]

Thanks sir g

[@mayankchopra6860]

B and C Have incoming edges and we hav taken Ab and AC as candidate key is this correct but Ab and AC closer is giving the relation R so this is also correct

[@Sudeshsorout]

sir g locking base protocol bata dijiye net exam nazdik h g...... or sir g thank you very much ... m apke lectures se hi padh raha hu g. aap bahut achha padhate h g.... but sir jitna achha yaha per samjh m aata h utna class m kyu nhi aata g ... waha bhi toh Hume aap hi padhate ho g.

[@gollasaivenkatesh]

hello sir, awesome explaination but i have a small doubt ,is the table given in video is in 3nf? according to 1st rule it has transitive dependency so it shouldn't be in 3nf but according to 2nd rule since ab is super key and b is prime atrribute it is 3nf . which is correct?

[@dinkylakhani2461]

3NF only says that there shouldn't be any non prime attribute determining another non prime attribute ... So , even if we consider 1st rule , it is in 3NF

[@lohitmarla6168]

very good explanation sir

[@askariaziz4163]

شکریہ سر جی Thank you

[@Girepunjeshashank]

Sir u r great ....

[@namandubey20]

Sir i think u made a mistake when u wrote R3(AB), it should be R3(ABC) bcoz AB->C . And then C would be common b/w R1 and R3 and C is candidate key of R1 also . So we could have included R3.

[@anoopshukla7936]

Yes you are write.

[@devmittal3095]

I have one doubt in this solution. Here AB and AC are candidate/super keys and while identifying in which form the relations are in, for BCNF we check whether the left side of FD is a super key. Now here our final relations are AC and CB, well AC is a candidate key, but CB is not a candidate key or super key, so how come this satisfies the super key condition, thus making it BCNF. Please explain I am really confused here.

[@kashifrahman]

yes it is not in bcnf it is in 3nf we have decompose into two table to make it in bcnf

[@surajtiwari8066]

Sir please upload videos on multilevel indexing thanks?

[@aniketk11]

Sir can you please tell tha if there are two candidates keys then what are the steps to decompose a table. For ex .if r(a,b,c,d) And fd=>ac->bd,bc->ad,b->a,a->b. And the candidates keys are ac and bc

[@mutyaluamballa]

Sir, In the previous video you have mentioned, BCNF on a FD(X-->Y) should be of form (Prime/non-prime -----> Prime). But if X is a super key then it can never be a Non-prime. If yes then, does BCNF handle (NP --> PRIME) scenario??

[@saddamahmad2310]

thank you very much sir for this video

[@yogeshmahajan2206]

Last m ac relation m konsi ck h kyoki is relation m dono attribute same value ko contain kr rahe h Or key hamesha unique hoti h decomposed hone k bad jis relation ko uniquely identify kiya ja ske muje lgta h kuchh missing h

[@Happinesshubblogs]

ABC table bnna chhaiye tha.. But you took only AB... Please reply sir

[@gopalgoyal9850]

Sir, in the table AC, where A is acting as a candidate key, there is an inconsistency i.e. on same value of 'c', there are two values i.e. 'z' and 'w', so, how to remove this inconsistency?

[@akilansundaram2181]

I don't think A is the candidate key for AC.

[@utkarsh_108]

arre sir neta toh aap ho DBMS ke !!

[@newbegin1583]

Wow! Amazing!!!

[@aniketnikam9666]

[@thenerdytales396]

Knowledge Guruji😁

[@suboomdeb3572]

I have watched all your videos but there is one question . How C is a proper subset of candidate key (AC), since C alone is unable to find other attributes (A,B).

[@anonymouswdh]

But it can find the other candidate key thats enough

[@nirdhast]

in the first table there is dependancy A->C but A has duplicate values(c) in the column. can u explain it?

[@vishalbhardwaj8577]

No, actually the thing is AC as a whole is a primary/candidate key in that table, there is no dependency from A->C and also AC as a whole will always give unique values like cw,cz

[@tusharaggarwal3975]

Sir why have you removed the videos from this playlist as earlier 165 videos were there in this playlist.😭

[@KNOWLEDGEGATE_kg]

Dear Tushar, for complete course on DBMS, please click on the link below: tiny.cc/DBMS_Sanchitsir

[@tusharaggarwal3975]

@@KNOWLEDGEGATE_kg okay sir, thanx👍🙏

[@sminetube6354]

This is the best lecture for the topics I have studied, but there is too much add which is very irritating... like add after every 2-3 min is very irritating.. please do something to just reduce the frequency of add. Thank you

[@aamirnawab959]

You can download adblocker if you are watching videos in google chrome.

[@himanshuupadhyay3129]

Sir can earn only through these ads.. Watch them and consider them as fees for sir's hardwork and dedication towards us😊

[@ifrahkhan6957]

outstanding

[@ajitsafeway]

Actually I am confused here related wth 3NF.. itz in 3NF because there is no transitivity rit ? Means since C determine B and both are prime attributes so it avoids transitivity (non prime determine non prime) .. correct me If I am wrong Sanchit ?

[@sachinpandey4095]

Yes, you are right.

[@ajitsafeway]

Dost aapne 2 yrs ke baad reply kiya 😁 by ths time now i finished my master degree 😅 but anyway i would really thanks to you as you have provided me incredible support in my 1st sem indeed ! 🙏

[@yokerrekoy2904]

sir please upload videos on multi level indexing thknu

[@arpandashore2032]

Nice video sir, but make a video for 4nf

[@spider-man150]

Sir ye table 3nf mai kesa hoga 3nf ke condition toh N.p- N.p ha ???

[@devinderkaur9811]

Can we use R2 (AB --> C) with R1(C --> B)? This way we have common attribute in both the schemas and there is no FD loss and its also in BCNF form.. what say?

[@arinjain25]

Same doubt I am having today as I have my exam at 10 AM can u please tell me is it correct or not what u have said?

[@mokshmahajan6340]

Sir, will you upload lectures on Microprocessor and interfacing?

[@parthapal3915]

Microprocessor is a big topic...if you want to know about microprocessor then you must buy e microprocessor 8085/8086 book in order to observe every single step actions... microprocessor book writer name:- guenkar(I personally prefer this because I studied that book early and that was very helpful)

[@saumyojitdas4212]

The book name is gawokar . It is very thick book .along with it if u watch videos in KZbin it will be useful

[@imrohit2611]

For microprocessor watch Bharat acharaya sirs videos

[@hardiikagarwal9952]

@5:15 dont you think venn diagram should be reversed

[@rudradas2283]

Sir why you said AC is candidate key because AB already a candidate key as well I will find all the attributes with AB candidate key . I mean all the relation like AB-ABC

[@Sudeshsorout]

sir g inner outer join bhi btaa do sir g..... poore you tube per kisi bhi teacher ka samjh m nhi aa raha g

[@Sudeshsorout]

sir g users kitne hote h g or kon kon kya kya karta h g ... aik chhota sa lecture unka bana dijiye sir pls

[@sahilfuturetech3182]

it is known as pseudo transitive dependency

[@Good-tz8ep]

🙏🙏❤️❤️💕💕

[@nikhilkumar4892]

how this example is 3NF in this example C to B which is non prime to prime so how can it be 3NF please explain??????

[@shifazahera7099]

How can ac be a candidate key because from ab->c and then a->c then c->b but a is the part of ab and a cant find alone c ??

[@tusharpatil9774]

Can you please upload a video on 4NF.

[@manikshah2268]

The table made by u is not correct, Becz in it column a is giving two values for c, ie w and z, please tell me about this

[@gavalinilesh80186]

AC both are part of the primary key... (A is NOT the ONLY key in AC table). Hope it helps.

[@sportscity5487]

I am confused. You should describe what case your are setting first AB CK Or AC CK.

[@ashutoshsingh912]

sir how it is in 3NF because c is part of canditate key then how it is possible ?

[@kamaldeep770]

In AC table, c has 2 values z and w !!! its not in 1nf right? how did normalization helped here?

[@gavalinilesh80186]

It is in fact in 1NF - if we had c -> (z,w) in the same row then it is not in 1NF. Hope this has helped.

[@blueSurfer]

clicking on ads intensionally to thanku

[@PandeyJii9632]

Jiyo.

[@vaibhavkumarchaudhary]

Jo neta ban na chahta hai usko neta bana de :P

[@guyswapnil]

Meee Neta Bana Chata Huu😂😂

[@jhumkidas6604]

It's all about ok bt after making table of only A and C..we can find multiple values through c...like c=>z and c=>w as well as ....how???

[@sachinpathak3084]

Suppose A is candidate name B C is item purchased and B is price of the item. So same person(A) can buy different item(C).

[@SanjaySingh-ce6mp]

0:48

[@shivswain3598]

Why r making (A &C) attribute as a candidate key....? C attribute can find B attribute by it self..! explain that first..?

[@kunalgrover8526]

🔥🔥🔥

[@Rashtrika]

Sir when u made relation R3 (AB) then why didn't u mention C in that as C is entirely dependent on AB?

[@aviatattar6634]

Please like share...

[@nabhyachaurasiya5957]

ac candidate key kaise

[@siddhant2943]

Normalisation ❌ Netabazi ✅ Concept Crystal Clear

[@shivalisaxena4206]

I don't understand why ac will also key

[@kondapallysaimanasa5261]

Why another relation ABC not there

[@naincypriya7017]

How B is not a key in AB and CB

[@souravshaw9344]

dont know😵

[@akashrajput1858]

Maza aagay jain bhaiyaa 4 GF aapko free

[@KNOWLEDGEGATE_kg]

Hahahaha aap ko 40, Visit www.knowledgegate.in for more helpful content and courses.

[@micky3982]

your sound is similar to Mr Aravind kejriwal

[@arfatbagwan48]

How the c → b ?

[@rajat__rg]

pehli baar video dekhne me kuch smaj nhi aaya , baad me revise krke dubara dekhni pdegi .

[@tanyasharma4034]

but c is not a super key...so that means this is still not in bcnf. isn't it?

[@nileshrathi4759]

Tanya Sharma c is superkey for the new table R1.

[@nimishajain9361]

C is not in superkey that's y we did decomposition cuz it didn't statisfy BCNF

[@buketyilmaz5043]

what is the "nehihe"????????????

[@akshay3506]

It's not there..

[@mukeshKumar-kr6xo]

sir how c became key ?

[@chandnigupta912]

c is not a super key

[@Anagha_VK]

I dont get things u r saying in hindi...i dont understand hindi.mso plzz do lectures in english only.so that everyone could understand u..

[@umangverma3660]

Intro theme reminds me of MARIO....

[@kuldeepsharma9733]

sir R(A C ) kaise aya?

[@sachinpathak3084]

Because we need to have a table for candidates key to have lossless decomposition.

[@sefa_computer_class]

wap institute

[@everythingishere7864]

Add htao master ji

[@initiator0016]

Kyo bhai?

[@everythingishere7864]

@@initiator0016 hurr 2 mnt mai add aate h

[@usmanakhtar9155]

Paid courses lay lo phr agr add b ni dakh sktay bhi ap..

[@nijhumreza9878]

You talk too much sir. -_-