4.10 Decomposition into 3NF Third Normal Form

[@KNOWLEDGEGATE_kg]

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

[@shiulisinha8901]

Sir you are terrific... You are best teacher in youtube i have come across...sir you are doing great job...your style of explaining and making things simple and easier is commendable. Usually i dont put comments in youtube but i couldnt resist in your case. Sir where are you from and where do you teach?

[@aishmash5325]

You are the Best Sir!!!! Just amazing ! This is really really very noble task you are doing.thankyou so much.

[@satyamkumar-lf8bw]

One of best teacher I have seen on You tube.fabulous sir.❤

[@rewakher8316]

Thank your sir, for your wonderful explanation 😀😀 You explain the topic in depth and make the topic easily understandable

[@KNOWLEDGEGATE_kg]

You are most welcome dear student, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@priyangsagar3140]

Tomorrow is my exam and i'am watching this playlist on 2X and now i can feel the confidence.

[@KNOWLEDGEGATE_kg]

All the best👍

[@akshitbidang9654]

Us bhai us

[@KNOWLEDGEGATE_kg]

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

[@SadiqKhan-qn1sf]

Great sir.. Mai nai boht videos dakey hai but jis trha ap dill sy parhatay ho. Is trha koyi nhi parhata 💜 Thanks my all concepts have been cleared

[@shrutikaoswal8048]

Instead of checking further can we directly say , Every function dependency is divided into separate table and if key is not part of this then create 1 more table for key..?? Is it a correct?

[@OmitA25]

very nice explanation..............Sir plz start uploading videos on COA..

[@vinitagupta3648]

If there is more than one candidate key than how to normalize 2 and 3 normal form. Plz Plz upload one lecture also.

[@imprakrut]

Do you also have an exam tomorrow?

[@MN-df2br]

Washing Powder NIRMAAA!!!

[@vishalkrishna6344]

Patel Miraj hello

[@joshking9537]

yep

[@souravraychaudhuri6600]

I have an exam in an hour xD

[@ankit7941]

YYY

[@souravmukherjee7508]

Best explanation sir, it will helps me a lot in fourtcoming exam .Thank you sir

[@animeshmishra4282]

I will watch the whole advt . Thats the only tribute i can pay to him.

[@kartickchandramanna267]

Excellent lecture 👍 Thank you sir 🙏❤️

[@KNOWLEDGEGATE_kg]

Most welcome dear 😍 keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@hardikajmani5088]

Great videos! Just reduce the number of ads, or organize them in a little better way as it breaks the concentration while watching.

[@ajitsafeway]

Neta ke ghar me ek aur neta 😂😂

[@adityakrishna11]

nepotism

[@SHASHANKRUSTAGII]

🤣laude lag gye neta ke!

[@raviashwin1157]

@@adityakrishna11 😂

[@pasitopasito1967]

😀😁😁😀😀😁😀

[@nc8002]

excellent video with really good examples and explanation. love it sir

[@pranjalgoyal6747]

The beauty of the video increases if you watch in 1.75x

[@shashwatmahodaya9695]

2x bruh!!!

[@itsmayank-08]

Helped a lot while doing assignment during Quarantine

[@niloydas5018]

Most recommended video for normalization. All the confusion has just vanished.

[@KNOWLEDGEGATE_kg]

Glad to hear that Niloy, thank you for watching, keep learning & stay with us for more content.

[@pratikbal-x9e]

sir in example no 4, we found that AB ->C proves that R is not in 3NF, so we decomposed AB ->C i.e. R1(ABCI) but sir here A is a prime attribute and it finds I which is a non prime attribute so there should be no problem but sir you have again decomposed R1 to R11 and R12. Why so sir?

[@PetBuddies]

best... Hats off... Love from Bangladesh

[@KNOWLEDGEGATE_kg]

Thanks a lot dear ❤️ Keep learning & supporting ! Stay connected for more amazing videos & contents 👍😊

[@saiyamjain1285]

Hello, I have a question here. How do we deal with a case where there is a circular dependency that means in R(ABCD) we have given that A->B, B->C, C->D, D->A....how do we find the candidate key in that relation and then convert it further into normal forms?

[@rahulshaw7457]

Gajabbbbbbbbbb 😁😁😁😁😁😁😁😁😁😁 maja AAA Gaya sir ji

[@KNOWLEDGEGATE_kg]

Thanks a lot Rahul.. Keep learning and supporting. Do visit our website www.knowledgegate.in for more courses and contents.

[@Shailesh_Pratap_Singh]

Well done sir ...your concepts are awesome ..✌✌

[@ipatelriya]

Awesome explanation sir🙌

[@hamzajee3401]

Sir you are the best teacher

[@AhamedKabeer-wn1jb]

Thank you Sir..Well explained..

[@KNOWLEDGEGATE_kg]

You are welcome Ahamed.. Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses and contents !!

[@supriyakanwar9990]

thanks ....really helpful in understanding concepts and solving questions...

[@jatinbhatoya8420]

exceptional teaching skills

[@KNOWLEDGEGATE_kg]

Thank you so much dear Jatin, keep learning & supporting, stay tuned ! You can also visit our website www.knowledgegate.in for more amazing contents & courses !

[@rajasaha1997]

India needs teacher like you sir.Thanks a lot

[@pratikshachauhan4152]

Sir please make a vedio in which we have more than one candidate key

[@HimanshuSingh-zs3mk]

Really Great Explanation Sir ,Thank you so much Sir.

[@anweshadatta7670]

Thank you sir .you are the best..😊

[@margipatel8489]

Best explanation 👍

[@KNOWLEDGEGATE_kg]

Thank you 🙂Keep learning & stay connected for more amazing contents👍😊 You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

[@arjunkhanna1803]

21:11 just to convert a relationship table to 3NF we need 6 table so will it take more space in database?? Increase the complexity??

[@AashishKumar-vb3qb]

sir aap toh jaadoogar hoo !!

[@KNOWLEDGEGATE_kg]

😂😂😂🙏🙏

[@AashishKumar-vb3qb]

@@KNOWLEDGEGATE_kg thanks for reply 🙏🙏🙏

[@alihaiderabbas3508]

I don't know in which manner I should say you THANKS ..you are just amazing .

[@iamgroot2810]

Brilliant explanation

[@KNOWLEDGEGATE_kg]

Thanks dear Sudipa, keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing contents & courses !

[@rasid_khan]

Great teacher❤❤

[@KNOWLEDGEGATE_kg]

Thank you so much friend.. keep following and watching videos..

[@ektabansal5332]

Bookish language had made these topics so much difficult, thanks a lot sir for these videos

[@KNOWLEDGEGATE_kg]

You are most welcome dear @Ekta😍 Keep learning & stay connected for more amazing videos👍

[@srs_queen]

Sir can we combine the tables R11 and R4 in last 4th example ? 20:39

[@anujsaini8332]

You r the best teacher Thanku so much sir Thanks 🙏 Sir

[@muhammadsafiullah8428]

Sir you are great. 💖

[@parthpatel.15]

Sir, Can you solve the following question to decompose the table into first 2NF and then 3NF? Given, the relation: R (a, b, c, d, e, f, g, h, i, j, k, f) and the FDs: a -> c, d, e; a, b, g, h -> i, j, k, f; j, i, g, h -> f, a, b. Decompose the given relation first into 2NF and then 3NF. It will be of great help if you help me in this sir.

[@pritigupta4413]

Outstanding performance sir ji

[@PandeyJii9632]

Gajab teacher !!

[@only_rashed]

Understanding 🖤

[@KNOWLEDGEGATE_kg]

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

[@nimmalavishnu3044]

Great Explaination sir,God Bless you sir

[@rahulkumarpandey9596]

sir at 17:41 you have mistakenly included ( A - I ) which is a partial dependency . 😎😎

[@rohangupta7906]

I too observed it . 😎😎

[@bhavnagoswami1273]

Bhot ache dost ho aap sir🥰

[@KNOWLEDGEGATE_kg]

Thanks a lot Bhavna, Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses and contents !!

[@Ankit-we8ym]

sir can you please teach how to check dependency preserving and lossy/lossless nature of decomposition

[@chrishhemsworth2682]

Great sir Now all doubts are cleared 🙏🙏🙏

[@KNOWLEDGEGATE_kg]

Excellent dear👏Keep learning & stay connected for more content👍

[@chetanraj1950]

Awesome explanation sir.

[@anusreenandy9251]

Your explanations are the best

[@ebteshamkhalidansari8833]

AB->CD,CD->EF,BC->DEF,D->B,CE->F CONVERT THIS 2NF IN 3NF sir plz reply for this question

[@shaillymegha2840]

Thanku sir..we love you knowledge gate

[@nikkymishra6518]

Best lecture sir

[@rpkumawat8879]

Lucid and vivid explanation

[@KNOWLEDGEGATE_kg]

Thank you my friend.. Thank you for following the videos regularly and providing your valuable feedback..

[@PANKAJKUMAR-fe8zn]

Thank you a lot .....a ton of thank you sir......because of you, in this theoretical paper....i have very much confidence now.....

[@devanshgupta5728]

exam me shortcut nhi allow hota he

[@mohammadadnaanzakee3302]

You might find confusing at first, but believe me you won't find simpler explanation than this!!

[@nkag545]

Thanks a lot!

[@KNOWLEDGEGATE_kg]

Most welcome dear❤ Keep learning & supporting! Stay connected for more amazing videos & contents 👍

[@narendraparmar1631]

Very precise lecture Thanks sir 😆

[@mitrajsinhjadeja2999]

you are a saviour

[@farihazultana]

Bahut pasand ai hai

[@sayansahu7389]

well done sir

[@KNOWLEDGEGATE_kg]

Thank you @Sayan❤ Keep learning & supporting! Stay connected for more amazing contents & videos 👍

[@himanshi9685]

Very good explanation sir tq sir

[@SoniKumari-zq5hd]

Thanku Sir for such a important video😊

[@oliganguly2051]

U r amazing sir..ur videos are really helpful

[@nathm1526]

Best explanation ever!

[@riyabansal8835]

amazing sir

[@KNOWLEDGEGATE_kg]

Thanks! Keep learning & stay connected for more amazing contents👍😊 You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

[@chandanyadava2228]

Consider a relation R(A,B,C,D,E) with set F= { A→CD, C→B,B→AE} What are the prime attributes of this Relation and Decompose the given relation in 3NF 🙏 sir solve this problem

[@asifiqbalkhan5601]

A,B,C are candidate keys and A,B,C are prime atributes this relation dont have any partial or transitive dependancy so, it is in 3NF

[@vinitagupta3648]

SIR VERY GOOD LECTURE SIR

[@rajveerchoudhary5307]

Great sir 👍

[@everyone2905]

Neta Neta har Koi kehta teesri manzil pe rehta .... -Jagdish Bhagat

[@abdeali1301]

Thank-you sir for amazing video !!! Sir Ek Doubt Tha ki Question me Jitni bhi Dependecies di hai hum usika hi Table Create Kar dete hai to uske Bad Ye sab step karne ki to Zaroorat hi nahi hai. To ham ye step kyu kar rahe hai?

[@saisrikar7987]

your videos are great sir!! Thanks. Sir,By the way, Where do you teach.?

[@akashsharma9474]

unacademy

[@sagarmehla3781]

Nice explnaition

[@RaviSingh-yf6jd]

Thanks sir but also upload computer network series please thanks again

[@gajendramajhi1688]

Thank you so much sir....😊😊😊😊😊

[@KNOWLEDGEGATE_kg]

You're welcome, Gajendra. Keep learning, supporting & stay connected for more content👍

[@mrdaring2225]

ThankYou so much.

[@KNOWLEDGEGATE_kg]

You're welcome! Keep learning & stay connected for more amazing contents👍😊 You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

[@SaurabhSingh-db8xq]

thanks a lot sirji.

[@MohammedAli-qm2bg]

How do we decompose this relation? R(ABCD) F = {AB → C; BCD → A; D → A; B → C} The candidate key is BD.

[@askariaziz4163]

thanks

[@arunavasaha7051]

in 2nd and 3rd example why we are not creating a separate relation with only keys i.e. R(AB) when AB is a candidate key.. unlike 1st and previous examples?

[@aryanarya72]

Should be created

[@akashkumaryadav1827]

GREAT

[@KNOWLEDGEGATE_kg]

Thank you dear! Keep supporting & stay connected for more amazing contents👍😊 You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

[@pranavmaiya4386]

brother amazing man

[@KNOWLEDGEGATE_kg]

Thanks a ton, Pranav. Keep learning, supporting & stay connected for more upcoming content👍

[@shivmohanagarwal1746]

Best explanation sir

[@KNOWLEDGEGATE_kg]

Thanks a lot, Shiv. Keep learning, supporting & stay connected for more content👍

[@MuhammadJunaid-zv3kk]

*Sir in questions ma to apny simple ye btaya hua hai k A--->B OR AD--->E but sir actual problem hi to yahi ha hamin samjh ni ati k konsa attribute kis ko determine kr rha ha normal questions ma ye ni likha hota k ye attribute isko determine kr rha yahi chiz find krni parti ha so kindly koi method btayin jis sa hamin asani ho k ye attribute isko determine kr rha ye ni kr rha etc....

[@WimpyWarlord]

This is priceless!

[@gouravsharma1952]

sir pls upload videos on lossless join and dependency preserving

[@harshitharshit6448]

3rd example me BD and DE Me decompose kiya gya but B Part of cadidate key and prime attribute ek non prime ko identify karra to ye toh 2nf me hi nai hai kaise 3nf me ho gya

[@mohordas5557]

Thank you so much sir 🤍

[@KNOWLEDGEGATE_kg]

You're welcome. Keep learning, supporting & stay connected for more content👍

[@flywithrohan05]

In 1st Example, R12 mei, B candidate key kaise Bana? Can you please clear my doubt , tomorrow I'm having my exam... thanks sir

[@soniaverma7870]

TYSM SIR

[@nehapratap8360]

Thank you sir

[@sketchesbyMg]

I have a doubt.If relation is given A->DE and D is a prime attribute but E is not and A is not a superkey so can I say that this relation is valid for 3 normal form??

[@sachinduhan3022]

you are god. thank you for such wonderful explanation

[@vivekpandey794]

Jo neta ban raha hai... Usko neta bana do 😂😂💜😉😉

[@sumitverma5296]

if you had added 4NF 5NF and DKNF then it would have been even more beneficial.