4.10 Decomposition into 3NF Third Normal Form

Подписаться 713 тыс.

Просмотров 373 тыс.

50% 1

📝 Talk to Sanchit Sir: forms.gle/WCAF...
💻 KnowledgeGate Website: www.knowledgeg...
📲 KnowledgeGate Android App: tiny.cc/KG_Offi...
➡ Do not miss our Bestseller Courses:
🔴 GATE Guidance-2025: www.knowledgeg...
🟠 GATE Guidance Plus-2025: www.knowledgeg...
➡ Contact Us:
🟩 Whatsapp Chat: wa.me/91859512...
📞Call on: +91-8000121313
🟦 Telegram Updates: t.me/kg_gate
🟩 Whatsapp Updates: www.whatsapp.c...
📧 Email: contact@knowledgegate.in
➡ Our One Shot Semester Exam Videos: 👇
▶ Operating System: • Complete Operating Sys...
▶ DBMS: • Complete DBMS Data Bas...
▶ Computer Network: • Complete CN Computer N...
▶ Digital Electronics: • Complete DE Digital El...
▶ Computer Architecture: • Complete COA Computer ...
▶ Data Structure: • Complete DS Data Struc...
▶ Algorithm: • Complete DAA Design an...
▶ Software Engineering: • Complete Software Engi...
▶ Theory of Computation: • Complete TOC Theory of...
▶ Compiler: • Complete CD Compiler D...
▶ Discrete Maths: • Complete DM Discrete M...
➡ Free Subject-Wise Complete PlayList: 👇
▶️ DBMS: tiny.cc/kg_yt_DBMS
▶️ Operating System: tiny.cc/kg_yt_OS
▶️ TOC|Automata: tiny.cc/kg_yt_toc
▶️ Computer Networks: tiny.cc/kg_yt_CN
▶️ Digital Electronics: tiny.cc/kg_yt_D...
▶️ Compiler Design: tiny.cc/kg_yt_C...
▶️ Computer Architecture: tiny.cc/kg_yt_COA
▶️ Data Structure: tiny.cc/kg_yt_D...
▶️ Algorithms: tiny.cc/kg_yt_A...
▶️ Set, Relation, Function: tiny.cc/kg_yt_D...
▶️ Graph Theory: tiny.cc/kg_yt_g...
▶️ Group Theory: tiny.cc/kg_yt_g...
▶️ Proposition: tiny.cc/kg_yt_p...
#knowledgegate #GATE #sanchitjain
*********************************************************

Опубликовано:

26 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 257

@KNOWLEDGEGATE_kg Год назад

For complete DBMS, check out this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-YRnjGeQbsHQ.html

@shiulisinha8901 6 лет назад

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 6 лет назад

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

@satyamkumar-lf8bw 6 лет назад

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

@imprakrut 5 лет назад

Do you also have an exam tomorrow?

@MN-df2br 5 лет назад

Washing Powder NIRMAAA!!!

@vishalkrishna6344 5 лет назад

Patel Miraj hello

@joshking9537 5 лет назад

yep

@souravraychaudhuri6600 5 лет назад

I have an exam in an hour xD

@ankit7941 4 года назад

YYY

@rewakher8316 2 года назад

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

@KNOWLEDGEGATE_kg 2 года назад

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

@priyangsagar3140 8 месяцев назад

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

@KNOWLEDGEGATE_kg 8 месяцев назад

All the best👍

@akshitbidang9654 8 месяцев назад

Us bhai us

@shrutikaoswal8048 5 лет назад

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?

@vinitagupta3648 5 лет назад

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

@ajitsafeway 5 лет назад

Neta ke ghar me ek aur neta 😂😂

@adityakrishna11 4 года назад

nepotism

@SHASHANKRUSTAGII 4 года назад

🤣laude lag gye neta ke!

@raviashwin1157 3 года назад

@@adityakrishna11 😂

@pasitopasito1967 3 года назад

😀😁😁😀😀😁😀

@SadiqKhan-qn1sf 4 года назад

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

@animeshmishra4282 3 года назад

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

@niloydas5018 6 месяцев назад

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

@KNOWLEDGEGATE_kg 6 месяцев назад

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

@OmitA25 6 лет назад

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

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

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

@nc8002 5 месяцев назад

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

@hardikajmani5088 5 лет назад

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

@pranjalgoyal6747 4 года назад

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

@shashwatmahodaya9695 4 года назад

2x bruh!!!

@souravmukherjee7508 4 года назад

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

@Mayank-sl3bb 4 года назад

Helped a lot while doing assignment during Quarantine

@pratikshachauhan4152 6 лет назад

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

@kartickchandramanna267 2 года назад

Excellent lecture 👍 Thank you sir 🙏❤️

@KNOWLEDGEGATE_kg 2 года назад

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

@PetBuddies Год назад

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

@KNOWLEDGEGATE_kg Год назад

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

@rahulshaw7457 3 года назад

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

@KNOWLEDGEGATE_kg 3 года назад

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

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

@AhamedKabeer-wn1jb 3 года назад

Thank you Sir..Well explained..

@KNOWLEDGEGATE_kg 3 года назад

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

@hamzajee3401 5 лет назад

Sir you are the best teacher

@Ankit-we8ym 6 лет назад

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

@anweshadatta7670 5 лет назад

Thank you sir .you are the best..😊

@mohammadadnaanzakee3302 3 дня назад

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

@iamgroot2810 2 года назад

Brilliant explanation

@KNOWLEDGEGATE_kg 2 года назад

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

@jatinbhatoya8420 2 года назад

exceptional teaching skills

@KNOWLEDGEGATE_kg 2 года назад

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 !

@bhavnagoswami1273 3 года назад

Bhot ache dost ho aap sir🥰

@KNOWLEDGEGATE_kg 3 года назад

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

@mdrashedulislam7453 Год назад

Understanding 🖤

@KNOWLEDGEGATE_kg Год назад

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

@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

@rajasaha1997 5 лет назад

India needs teacher like you sir.Thanks a lot

@Shailesh_Pratap_Singh 5 лет назад

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

@ipatelriya 5 лет назад

Awesome explanation sir🙌

@AashishKumar-vb3qb 2 года назад

sir aap toh jaadoogar hoo !!

@KNOWLEDGEGATE_kg 2 года назад

😂😂😂🙏🙏

@AashishKumar-vb3qb 2 года назад

@@KNOWLEDGEGATE_kg thanks for reply 🙏🙏🙏

@nkag545 Год назад

Thanks a lot!

@KNOWLEDGEGATE_kg Год назад

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

@NishaSharma-nd1dk 3 года назад

Thanks sir g

@abdeali1301 2 года назад

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?

@parthpatel.15 5 лет назад

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.

@supriyakanwar9990 6 лет назад

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

@alihaiderabbas3508 5 лет назад

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

@PANKAJKUMAR-fe8zn 5 лет назад

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

@devanshgupta5728 4 года назад

exam me shortcut nhi allow hota he

@ebteshamkhalidansari8833 4 года назад

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

@everyone2905 3 года назад

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

@HimanshuSingh-zs3mk 6 лет назад

Really Great Explanation Sir ,Thank you so much Sir.

@shaillymegha2840 5 лет назад

Thanku sir..we love you knowledge gate

@muhammadsafiullah8428 5 лет назад

Sir you are great. 💖

@nimmalavishnu3044 5 лет назад

Great Explaination sir,God Bless you sir

@anujsaini8332 5 лет назад

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

@PandeyJii9632 4 года назад

Gajab teacher !!

@chrishhemsworth2682 Год назад

Great sir Now all doubts are cleared 🙏🙏🙏

@KNOWLEDGEGATE_kg Год назад

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

@MuhammadJunaid-zv3kk 3 года назад

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

@rasid_khan 3 года назад

Great teacher❤❤

@KNOWLEDGEGATE_kg 3 года назад

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

@mitrajsinhjadeja2999 4 года назад

you are a saviour

@sumeetkumar298 3 года назад

Thank you so much sir

@rpkumawat8879 5 лет назад

Lucid and vivid explanation

@KNOWLEDGEGATE_kg 5 лет назад

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

@nikkymishra6518 6 лет назад

Best lecture sir

@anusreenandy9251 6 лет назад

Your explanations are the best

@pritigupta4413 4 года назад

Outstanding performance sir ji

@chetanraj1950 5 лет назад

Awesome explanation sir.

@farihazultana 5 лет назад

Bahut pasand ai hai

@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

@oliganguly2051 5 лет назад

U r amazing sir..ur videos are really helpful

@SoniKumari-zq5hd 5 лет назад

Thanku Sir for such a important video😊

@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

@gajendramajhi1688 Месяц назад

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

@KNOWLEDGEGATE_kg Месяц назад

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

@arunavasaha7051 5 лет назад

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 2 года назад

Should be created

@askariaziz4163 4 года назад

thanks

@shivmohanagarwal1746 4 месяца назад

Best explanation sir

@KNOWLEDGEGATE_kg 4 месяца назад

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

@himanshi9685 6 лет назад

Very good explanation sir tq sir

@MohammedAli-qm2bg 4 года назад

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

@narendraparmar1631 6 лет назад

Very precise lecture Thanks sir 😆

@sagarmehla3781 5 лет назад

Nice explnaition

@nathm1526 6 лет назад

Best explanation ever!

@vinitagupta3648 5 лет назад

SIR VERY GOOD LECTURE SIR

@zeeshanmohnavi 5 лет назад

Can't resist giving feedback after watching his videos on FD(Part 3.1) till 3NF(Part 4.8). - His videos are okay to understand the concepts intuitively but will be of little help if you solely rely on it for GATE. Reading a standard book or watching lectures of some reputed colleges (as available on NPTEL/Stanford/MIT) is a must to get the technical jargon and to get the concepts right. - Mr. Sanchit Jain deliberately took examples involving a single candidate key, while solving problems on 3NF, and pretended that this is all that will be asked in GATE/NET. This will give the candidates a sense of "complete" understanding when, in fact, they just learned and practiced the skills to solve a subset of the possible questions. This series was recommended to me by an accomplice, but I won't recommend it if you want to appear for GATE. Supplementing these videos with a reference text might prove helpful. **Views are personal**

@meghnajain7889 5 лет назад

i agree....but it gives a basic understanding for the beginners so that it becomes quite easy to learn further....

@mohordas5557 3 месяца назад

Thank you so much sir 🤍

@KNOWLEDGEGATE_kg 3 месяца назад

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

@sketchesbyMg 6 лет назад

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

@arjunkhanna1803 4 года назад

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

@saisrikar7987 6 лет назад

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

@akashsharma9474 4 года назад

unacademy

@sachinduhan3022 4 года назад

you are god. thank you for such wonderful explanation

@soniaverma7870 3 года назад

TYSM SIR

@gouravsharma1952 6 лет назад

sir pls upload videos on lossless join and dependency preserving

@RaviSingh-yf6jd 5 лет назад

Thanks sir but also upload computer network series please thanks again

@oendricbaidya898 6 лет назад

thank you so much sir.

@rajveerchoudhary5307 6 лет назад

Great sir 👍

@srs_queen 7 месяцев назад

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

@rohanm2793 5 лет назад

Sir, plzz plzz make videos on 4th normal form also

@chetankumar1487 5 лет назад

Kya ye method se semester exam me solve kr skte h????....jldi bta dijye...mera exam 30 may ko h

@richasharma5486 5 лет назад

Sir plzz make a video on query writing bye given schema based qestion

@flywithrohan05 5 лет назад

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

@rahulkumarpandey9596 3 года назад

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

@rohangupta7906 3 года назад

I too observed it . 😎😎

@zainakram1494 4 года назад

What will we do if a prime and non-prime attributes altogether are finding a non-prime attribute?

@WimpyWarlord 5 лет назад

This is priceless!

@dhritimanroyghatak2408 5 лет назад

@KNOWLEDGE GATE Sir Beta kabhi bhi prime atribute kaise hoga kyonkin wo khud alpha se nikala jaa skta h ye baat mujhe smjh nhi ayi kya aap please alaborate karenge.Thank you

@KNOWLEDGEGATE_kg 11 месяцев назад

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