4.10 Decomposition into 3NF Third Normal Form
Вставка
- Опубліковано 16 тра 2018
- 📝 Talk to Sanchit Sir: forms.gle/WCAFSzjWHsfH7nrh9
💻 KnowledgeGate Website: www.knowledgegate.in/gate
📲 KnowledgeGate Android App: tiny.cc/KG_Official_App
➡ Do not miss our Bestseller Courses:
🔴 GATE Guidance-2025: www.knowledgegate.in/learn/GA...
🟠 GATE Guidance Plus-2025: www.knowledgegate.in/learn/GA...
➡ Contact Us:
🟩 Whatsapp Chat: wa.me/918595120657
📞Call on: +91-8000121313
🟦 Telegram Updates: t.me/kg_gate
🟩 Whatsapp Updates: www.whatsapp.com/channel/0029...
📧 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_Digital
▶️ Compiler Design: tiny.cc/kg_yt_Compiler
▶️ Computer Architecture: tiny.cc/kg_yt_COA
▶️ Data Structure: tiny.cc/kg_yt_DataStructures
▶️ Algorithms: tiny.cc/kg_yt_Algorithm
▶️ Set, Relation, Function: tiny.cc/kg_yt_Discrete_Relations
▶️ Graph Theory: tiny.cc/kg_yt_graphtheory
▶️ Group Theory: tiny.cc/kg_yt_grouptheory
▶️ Proposition: tiny.cc/kg_yt_prepositions
#knowledgegate #GATE #sanchitjain
*********************************************************
For complete DBMS, check out this video: ua-cam.com/video/YRnjGeQbsHQ/v-deo.html
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?
One of best teacher I have seen on You tube.fabulous sir.❤
You are the Best Sir!!!! Just amazing ! This is really really very noble task you are doing.thankyou so much.
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
If there is more than one candidate key than how to normalize 2 and 3 normal form. Plz Plz upload one lecture also.
thanks ....really helpful in understanding concepts and solving questions...
Best explanation sir, it will helps me a lot in fourtcoming exam .Thank you sir
excellent video with really good examples and explanation. love it sir
Tomorrow is my exam and i'am watching this playlist on 2X and now i can feel the confidence.
All the best👍
Us bhai us
Really Great Explanation Sir ,Thank you so much Sir.
Neta ke ghar me ek aur neta 😂😂
nepotism
🤣laude lag gye neta ke!
@@adityakrishna11 😂
😀😁😁😀😀😁😀
Helped a lot while doing assignment during Quarantine
Thank your sir, for your wonderful explanation
😀😀
You explain the topic in depth and make the topic easily understandable
You are most welcome dear student, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
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?
I don't know in which manner I should say you THANKS ..you are just amazing .
Great Explaination sir,God Bless you sir
very nice explanation..............Sir plz start uploading videos on COA..
U r amazing sir..ur videos are really helpful
Do you also have an exam tomorrow?
Washing Powder NIRMAAA!!!
Patel Miraj hello
yep
I have an exam in an hour xD
YYY
Thank you sir .you are the best..😊
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?
Thanku sir..we love you knowledge gate
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??
I will watch the whole advt . Thats the only tribute i can pay to him.
Thanku Sir for such a important video😊
sir can you please teach how to check dependency preserving and lossy/lossless nature of decomposition
Your explanations are the best
Awesome explanation sir.
Very precise lecture
Thanks sir 😆
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.
Sir you are great. 💖
You r the best teacher
Thanku so much sir
Thanks 🙏 Sir
Thank you a lot .....a ton of thank you sir......because of you, in this theoretical paper....i have very much confidence now.....
exam me shortcut nhi allow hota he
Very good explanation sir tq sir
Best explanation ever!
Great videos!
Just reduce the number of ads, or organize them in a little better way as it breaks the concentration while watching.
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??
Outstanding performance sir ji
Sir please make a vedio in which we have more than one candidate key
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?
Well done sir ...your concepts are awesome ..✌✌
Awesome explanation sir🙌
Sir if humne 3nf me decompose krne waqt ek relation me candidate key ko Bhi rakhte but sir if agar aisa relation mile jaha par ek hi letter ki ck ho tb kya uss suppose only 'A' toh waha pe relation kese bnega
Thank you Sir..Well explained..
You are welcome Ahamed.. Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses and contents !!
Sir you are the best teacher
Best lecture sir
@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
Excellent lecture 👍
Thank you sir 🙏❤️
Most welcome dear 😍 keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊
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?
best... Hats off... Love from Bangladesh
Thanks a lot dear ❤️ Keep learning & supporting ! Stay connected for more amazing videos & contents 👍😊
R22 Mei koi bhi candidate key ka attribute nahi hai sir ,,, then won't it be lossy ? ??
thank you so much sir.
Most recommended video for normalization. All the confusion has just vanished.
Glad to hear that Niloy, thank you for watching, keep learning & stay with us for more content.
Sir I couldn't find the vedios on join and division operations ....help me if it's possible 🙁
sir pls upload videos on lossless join and dependency preserving
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
your videos are great sir!! Thanks.
Sir,By the way, Where do you teach.?
unacademy
Thanks sir but also upload computer network series please thanks again
SIR VERY GOOD LECTURE SIR
This is priceless!
Bhot ache dost ho aap sir🥰
Thanks a lot Bhavna, Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses and contents !!
thanks a lot sirji.
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?
Should be created
What will we do if a prime and non-prime attributes altogether are finding a non-prime attribute?
Kya ye method se semester exam me solve kr skte h????....jldi bta dijye...mera exam 30 may ko h
Gajab teacher !!
Lucid and vivid explanation
Thank you my friend.. Thank you for following the videos regularly and providing your valuable feedback..
Thanks a lot!
Most welcome dear❤ Keep learning & supporting! Stay connected for more amazing videos & contents 👍
Great sir
Now all doubts are cleared 🙏🙏🙏
Excellent dear👏Keep learning & stay connected for more content👍
In 1st Example, R12 mei, B candidate key kaise Bana? Can you please clear my doubt , tomorrow I'm having my exam... thanks sir
Sir can we combine the tables R11 and R4 in last 4th example ? 20:39
Brilliant explanation
Thanks dear Sudipa, keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing contents & courses !
India needs teacher like you sir.Thanks a lot
If beta primary attribute only and alpha super key with beta primary attribute ...................plz give example such type?
Bahut pasand ai hai
Sir, can you kindly explain again why have you made the table R4(A,B,D) in decomposition ? I have a doubt in this part .
Same because H determines J but it's not a part of Candidate key.
Kindly explain anyone
Thanks sir g
Bookish language had made these topics so much difficult, thanks a lot sir for these videos
You are most welcome dear @Ekta😍 Keep learning & stay connected for more amazing videos👍
Great sir 👍
Thank you so much sir
you are a saviour
Thank you sir
Best explanation 👍
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
Thank u so much sir
Thank you sir 🙏
exceptional teaching skills
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 !
ThankYou so much.
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
Gajabbbbbbbbbb 😁😁😁😁😁😁😁😁😁😁 maja AAA Gaya sir ji
Thanks a lot Rahul.. Keep learning and supporting. Do visit our website www.knowledgegate.in for more courses and contents.
The beauty of the video increases if you watch in 1.75x
2x bruh!!!
Dear sir, Is this method(without solving for 2nf seperately) applicable in university exam . If yes then would it provide full marks?
Pata chala bhai ¿
Sir plzz make a video on query writing bye given schema based qestion
thanks
amazing sir
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
*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....
Sir, plzz plzz make videos on 4th normal form also
Nice explnaition
Sir in question no 4 . There is mistake because sir here in R1 we decompose it but sir why because here candidate key is A ,so already the table is in 3 NF so why we decompose it into R11 and R12
Great teacher❤❤
Thank you so much friend.. keep following and watching videos..
Understanding 🖤
Thank you so much dear❤ Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing contents & complete courses 👍😊
well done sir
Thank you @Sayan❤ Keep learning & supporting! Stay connected for more amazing contents & videos 👍