4.13 How to Identify Normal Form Practice Question Part-1

  Рет қаралды 480,259

KnowledgeGATE by Sanchit Sir

KnowledgeGATE by Sanchit Sir

Күн бұрын

Пікірлер: 508
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
For complete DBMS, check out this video: kzbin.info/www/bejne/j4PRm3qbhsemfrM
@ScreenieMyMusic
@ScreenieMyMusic 6 жыл бұрын
Bro, im not even indian, but my parents used to watch bollywood films, and i learnt hindi through that. And its paying off, this guys amazing. He really wants you to understand, this is how you teach! Thank you for the videos!!!!!!!
@sajalagrawal1430
@sajalagrawal1430 5 жыл бұрын
yes , we INdian always try to make things easier to learn .it is in our gene
@ArkabrataDattaRoyChowdhury11
@ArkabrataDattaRoyChowdhury11 5 жыл бұрын
Thanks for the nice comment man. It's really rare for foreigners to appreciate Indian online teachers. They work really hard and in my opinion are the best in what they teach.
@deadlydangaming
@deadlydangaming 4 жыл бұрын
I can agree , I'm from Pakistan and i respect India and their teachers so much , they are really good and they know how to properly teach and making things alot easier for us , Respect from Pakistan 🇵🇰
@yutaitadori7318
@yutaitadori7318 3 жыл бұрын
@@deadlydangaming only KZbin tutors dude !!!
@hrithik5220
@hrithik5220 3 жыл бұрын
Sachit sir ki international fan following hai
@codingwithelhacen990
@codingwithelhacen990 Жыл бұрын
Taking my hat off to Indians for their WELL simplified explanations EVERYWHERE. Thank you
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
Thanks a lot for your kind words ❤ Keep learning & supporting! Stay connected for more amazing videos & contents 👍
@ash_engineering
@ash_engineering 8 жыл бұрын
please upload MVD , 4NF and 5NF videos also .. your explanation are really very easy to comprehend, and I really dont understand these topics at all. I am preparing for GATE 2017
@nausifmaknojia8713
@nausifmaknojia8713 6 жыл бұрын
plz can u upload 4NF
@vivekojha4807
@vivekojha4807 3 жыл бұрын
Gate nikla?
@yutaitadori7318
@yutaitadori7318 3 жыл бұрын
Why are you preparing for gate
@vidhikumar1664
@vidhikumar1664 3 жыл бұрын
@@vivekojha4807 lol, now its your time!
@vivekojha4807
@vivekojha4807 3 жыл бұрын
@@vidhikumar1664 ⊙﹏⊙
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg 🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg
@surekhapadmam2336
@surekhapadmam2336 3 жыл бұрын
I can't believe myself solving all examples which I've feared only by looking at them. ☺️ It's hard not to comment. Thank you sir ❤️
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 3 жыл бұрын
Well done !! Great, Visit www.knowledgegate.in for more courses and content !!
@TheBergsteinsson
@TheBergsteinsson 8 жыл бұрын
Watching from Iceland. You have really helped me alot! Thanks mate :)
@akshaypathange3582
@akshaypathange3582 5 жыл бұрын
Really? Wow!
@AdishKGupta
@AdishKGupta 4 жыл бұрын
why do you need to watch this? Do ice skating and enjoy...
@mitrajsinhchavda5659
@mitrajsinhchavda5659 3 жыл бұрын
@@AdishKGupta that's where trust issues begin Iceland has greenery and greenaland is covered by ice Lolzz
@being1better801
@being1better801 3 жыл бұрын
@@mitrajsinhchavda5659 that is where trust issues begin You would have told him ,why can't he watch but no😂, you explained him about ice and greenary.
@mitrajsinhchavda5659
@mitrajsinhchavda5659 3 жыл бұрын
@@being1better801 welcome to India
@shekharpandey844
@shekharpandey844 7 жыл бұрын
great examples, one thing to add , as soon as we get Partial dependency we can immediately say it is not in 2 NF , and conclude
@sharkk2979
@sharkk2979 7 жыл бұрын
Your technique of finding 3nf is very good You recognized the thing You r hacker
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 7 жыл бұрын
Hello Sharang, thanks for appreciation. :)
@adityapaithon6499
@adityapaithon6499 6 жыл бұрын
In 3rd case how did you find candidate key?
@saumyojitdas4212
@saumyojitdas4212 5 жыл бұрын
@@KNOWLEDGEGATE_kg In the first question u haven't checked the other dependencies ,u check the first two and concluded that the table is in 1nf. But earlier at the starting of the video u told to check for every dependency. Is it a shortcut?
@saumyojitdas4212
@saumyojitdas4212 5 жыл бұрын
In the first question u haven't checked the other dependencies ,u check the first two and concluded that the table is in 1nf. But earlier at the starting of the video u told to check for every dependency. Is it a shortcut?
@salmananjum-thestoryteller1515
@salmananjum-thestoryteller1515 7 жыл бұрын
I'm from Electronics background, I haven't studied these courses in my graduation so guys tell me are these topics that simple to understand? or is this the wonder of this man's skills that I'm able to solve each and every question by myself in the 1st go? For you Sir, in our Pakistani Slang --> Chaa gaye ho aap ;-)
@rajeshrathod6344
@rajeshrathod6344 5 жыл бұрын
Topic is difficult but its easy only due to best teaching.
@silverzero9524
@silverzero9524 5 жыл бұрын
i would say these topics can be a little tricky to get and also students arent usually very interested in these because they seem boring
@vishaldhanani7241
@vishaldhanani7241 6 жыл бұрын
Sir aap jese or bahut sare teacher ki zroor hey....hmare clg me Jo teacher ushe bhi apke video dekh ke sikhna chahiye..
@papanchowdhury7881
@papanchowdhury7881 7 жыл бұрын
sir ur style of solving NF is so good.. I love it so much.. But I have a request.. plz plzz upload for finding 4nf 5nf dknf mvd plzzz.. preparing for gate 18..
@devarshisingh9349
@devarshisingh9349 7 жыл бұрын
Wow! I missed my coaching classes on this topic. I am glad I missed. Thank-you.
@kanhaiyaya
@kanhaiyaya 5 жыл бұрын
Your lecture video is filled with your passion to make the student understands the basic concept first and your way of interaction is just like real time viewing that makes us fully involved during the session , and of course without getting bored. I really appreciate your work. Thanks for your amazing teaching methodology.
@vimmysaini
@vimmysaini 7 жыл бұрын
amazing amazing. ..... pehli bar normalisation smj ayi hai. .life me.. great work sir.... best lecture.. Thank you so much....
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 7 жыл бұрын
Thanks for your appreciation,glad i could help :).
@Angela-Gee
@Angela-Gee 3 жыл бұрын
you are a GEM... I understood these concepts finally
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 3 жыл бұрын
Thanks a lot dear student, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
@devanshmesson2777
@devanshmesson2777 2 жыл бұрын
Thank you so much for a crystal clear explanation! It helped me so much in clearing the concepts!
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
You're most welcome dear, keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents !
@relaxandchill4968
@relaxandchill4968 2 жыл бұрын
Sanchit sir you are my inspiration you are the best teacher from you any student will be wiling to learn I just love your vedios crisp explanation thank you sir you are the best🤩🙏🙏
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
Thanks a lot dear for your kind & generous words 😍😍 Wish you all the very best for your future, stay blessed 👍😊 Keep learning & supporting, do visit our website www.knowledgegate.in for more amazing contents & courses 👍
@bestlearning2644
@bestlearning2644 4 жыл бұрын
Very good teaching sir..you teach very well..because i dont understand the concept of normalization but after watching your videos, I can solve all the questions of normal form. Thank you sir
@sagrikachauhan519
@sagrikachauhan519 6 жыл бұрын
we need teachers like you in our colleges.The university system of our country sucks
@jssaini1998
@jssaini1998 6 жыл бұрын
Thanks sir.. your video is the best source for learning all the normal forms in a single go! the only perfect solution for dbms on inernet!
@darinebouzar3575
@darinebouzar3575 7 жыл бұрын
After watching this video I do not have any problem with BCNF, that was like a big ghost for me, God bless you sir
@rohan8758
@rohan8758 4 жыл бұрын
I have done this all question myself in less time due to your teaching style. Thank you sir....
@Jyoti_Trivedi
@Jyoti_Trivedi 4 жыл бұрын
Thank you so much sir....I am doing this like homework in my notebook with interest..... Thanks again to spread knowledge free....u r great 😇👍
@gurinderkaur6377
@gurinderkaur6377 6 жыл бұрын
I think it better to chk for 2nf first...then 3nf n then bcnf... First check if there any fd which is partial dependency..nd no need to check further.. nd if there is no partial dependency...then chk for transitive...( If u find even a single dependency which is transivite ( using ur logic) ..then no need to check further....) Just a suggestion to save time
@priyapatel796
@priyapatel796 6 жыл бұрын
Sir u r awesome ur teaching style is Awsmmm... U Teaches all easy way to solve the pblm.and help me in all sem Exams at last moment... Thankuuuu so mch ......
@gauritiwari2373
@gauritiwari2373 6 жыл бұрын
Awesome...fear of normalisation hv gone..thanks..you gave simplest way to check out normalisation forms..❤
@meesamali8782
@meesamali8782 8 жыл бұрын
Sir I was struggling for few days to understand normalization topic but you made it really very simple. Thanks a lot. can you please tell me the other subjects you teach or upload videos ?
@bppb829
@bppb829 7 жыл бұрын
after watching all lecture one of normalizatin i hv bcm yr spuper fan .....thank u so much sir
@pankajhindlekar7045
@pankajhindlekar7045 7 жыл бұрын
Its Amazing Collection of SQL Concepts..really Helpful for me..kep it up sir..You are doing really good job...👍
@rajrehman9812
@rajrehman9812 7 жыл бұрын
good evening sir, sir thank you for such a beautiful explanation of normal form solutions,but sir in this video of part 13 I was unable to identify why u have chosen ABC,ACD as super key? I will be grateful to u sir for the explanation..thank you sir
@mohsinkirmani1833
@mohsinkirmani1833 7 жыл бұрын
Hi sir, This is one of the best channel I came across over KZbin for educational concerns. Very well explained, up to the point. Kindly upload some videos of 1NF, 2NF and 3NF pertaining to table decomposition. I'll be very thankful to you. Stay happy and keep this good job up :)
@anjumshaikh6060
@anjumshaikh6060 7 жыл бұрын
pls uplode video to solve the question : consider R=(A,B,C,G,H,I) and the set F of functional dependancies ,F={A->B,A->C,CG->H,CG->I,B->H}. The correct member of closure of F are :(a) A->H,CG->HI,AG->I (b) A->HI,CG->A (c) AG->BI (d) A->B,B->I
@sushmita7184
@sushmita7184 4 жыл бұрын
(a)
@shekharkumar8780
@shekharkumar8780 5 жыл бұрын
Thanks, sir.. your video is the best source for learning all the normal forms in a single go! the only perfect solution for DBMS on the internet!
@adityadevchakke3668
@adityadevchakke3668 4 жыл бұрын
A great salute..!!! Hats off to you sir...an amazing human being with gifted talent of teaching ,making efforts to give this knowledge.THANK YOU SIR FOR ALL THESE VIDEOS
@seanjalali9788
@seanjalali9788 7 жыл бұрын
Hi Knowledge Gate, Hi Sanchit. First of all, thank You so much for These Videos. I am new to this Community and I am very glad to learn from You. My Question to You and the Community is: Can we say for Example 1, that the second Dependency is not in third Normalform because A is not A Candidate Key ? I guess DE as Non-Prime Attributes have to rely on a CK and not a part of Prime-Attributes (as here in A). Right ?
@anshgyl
@anshgyl 7 жыл бұрын
Yes absolutely right the dependency "A --> DE" is a partial dependency as "A" is a part of the candidate key and not the whole candidate key. Therefore it is not in 2NF, hence it can't be in 3NF.
@catarina-6614
@catarina-6614 6 жыл бұрын
Thank you for your videos!! I have a question tho, how would you normalize: R(A,B,C,D,E,F) with Functional Dependencies = {ABC -> DEF, D-> E, ABC -> A} and in what form is it? Thank you once again!
@sushmita7184
@sushmita7184 4 жыл бұрын
2NF.
@ashishwildlifeandtravelpho7308
@ashishwildlifeandtravelpho7308 8 жыл бұрын
Ur knowledge is so refined really thanks for such nice lectures keep up ur good work sir :)
@murarisinghchoudhary5377
@murarisinghchoudhary5377 6 жыл бұрын
The Lectures are very useful for those who does not have basic concepts
@uvdg8t
@uvdg8t 5 жыл бұрын
supersirji aaj pheli bar engg ke 10 sal bad normalization sahi se samj aaya
@shradhasoni3177
@shradhasoni3177 3 жыл бұрын
Simply just one word. Excellent.
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 3 жыл бұрын
Thank you so much dear Shraddha😀 Keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
@kalyanchoudhury6254
@kalyanchoudhury6254 7 жыл бұрын
ur explanations are really good and understanding...I like ur all videos so much like(like os and all).. But I have a request sir ,plzz plzz upload 4nf 5nf dknf and mvd also,,,preparing for gate 18 as well as semester.....love u sirrrrrr...
@shagunverma8597
@shagunverma8597 7 жыл бұрын
sir, can you please check this relation for bcnf?? R is (A, B, C, D) with FD’s A -> B, B -> C, C -> D, D -> A.
@subhamkumardash3515
@subhamkumardash3515 5 жыл бұрын
Sir the way you explain each and every concept (whether the topic is easy or difficult) is fantabulous. Every video in this series is extraordinary. Keep it up.
@surbhisharma-qp1gl
@surbhisharma-qp1gl 6 жыл бұрын
Hello sr I must say u explain in very well manner and now my concepts are more clear .thanks a lot
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 6 жыл бұрын
Thank you for watching and providing feedback.. Will try to make more easier ones..
@surbhisharma-qp1gl
@surbhisharma-qp1gl 6 жыл бұрын
KNOWLEDGE GATE Can u plzz upload the videos In dependency preserving
@muj99ali
@muj99ali 5 жыл бұрын
"Here we see partial dependency. Hence it also not in *WHAT* ? 2NF." That "WHAT" is repeated so many times during explanations 😂 Btw Great tutorial videos sir ! Every category of student can find your tutorials helpful. Thanks for putting in the effort.
@saumyojitdas4212
@saumyojitdas4212 5 жыл бұрын
In the first question u haven't checked the other dependencies ,u check the first two and concluded that the table is in 1nf. But earlier at the starting of the video u told to check for every dependency. Is it a shortcut?
@Krodhaislive
@Krodhaislive 5 жыл бұрын
@@saumyojitdas4212 no need to check further. that's the logic
@himanshulahare7378
@himanshulahare7378 4 жыл бұрын
Lol
@arungarg5790
@arungarg5790 7 жыл бұрын
hello sir how to solve this question.. A-->BCD BC-->DE B-->D D-->A Compute a canonical cover for the above set of functional dependencies F; give each step of your derivation with an explanation. Give a 3NF decomposition of r based on the canonical cover. Give BCNF decomposition of original functional dependencies. can you get bcnf deconposition using canonical cover.
@adityasinghaswal4923
@adityasinghaswal4923 7 жыл бұрын
Your way of teaching is very lucid.Subbed and eagerly waiting for more videos.
@rajeshkotina
@rajeshkotina 7 жыл бұрын
superb explanation sir..but bit confused with logic of 3nf here while telling in examples..3nf video part was clear..but wen u apply in examples it's a confusion..
@amandeepsingh-ci4gb
@amandeepsingh-ci4gb 6 жыл бұрын
thanks a lot......video concepts are good enough to grasp the knowledge....no time wastage,,,i recommend it for others
@namanmittal9726
@namanmittal9726 5 жыл бұрын
Your videos are really helpful ! Thankyou so much sir.
@krishnaupadhyay4736
@krishnaupadhyay4736 6 жыл бұрын
Sir can you please upload a video on joins! As the way you are explaining is very good and normalisation questions in gate are mostly appeared with the joins
@abcabc-bu9rk
@abcabc-bu9rk Жыл бұрын
college teachers: bacche normalization jaldi se samaj gaye meanwhile students: isko neta bana do learning from knowledge gate Thanks sirr🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
@ajayraj4911
@ajayraj4911 4 жыл бұрын
sir aap to humare senior ho , DTU awsm lecture's
@chinmayagrawal5119
@chinmayagrawal5119 7 жыл бұрын
Really One of the best!!!! Thanks sir for uploading such fantastic videos
@learnfreewithvaibhaviupret5489
@learnfreewithvaibhaviupret5489 Жыл бұрын
My all doubts are clr after watching this video, thankyou sir 🙏
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
Most welcome ❤ keep learning & supporting! 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
@nezmika2911
@nezmika2911 6 жыл бұрын
Nice video sir ! Thank u so much, very clear, keep going! U r really awesone ..Thank u knowledge gate!
@pavankulkarni9756
@pavankulkarni9756 8 жыл бұрын
sir please make videos on 4NF and 5NF and please solve problem on how to normalize a relation videos on these concepts will help me a lot in my university exam Thanks a lot sir for uploading such a wonderful set of videos .
@SHASHANKRUSTAGII
@SHASHANKRUSTAGII 4 жыл бұрын
Love you sir. Thanks for this video. This would be my third GATE attempt with job. I hope I ace this exam #171 days left
@hemajeya3532
@hemajeya3532 6 жыл бұрын
Really outstanding teaching. Super sir.
@learnwithmanu5655
@learnwithmanu5655 8 жыл бұрын
very clear cut and Excellent explaination sir g thank u very much , sir g please upload the video on multivalued dependency , join dependancy , 4NF , 5NF, Relational calculas ,relational algebra. please sir g if u have time .
@AhmadRadwanalarfdah
@AhmadRadwanalarfdah 6 жыл бұрын
You're really good tbh. Sad that professors don't teach in this way.
@manantyagi614
@manantyagi614 2 жыл бұрын
thank you so much sir, my exams are approaching. And you have explained so well....#saviour
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
You're most welcome dear Manan, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
@sounaksana8128
@sounaksana8128 6 жыл бұрын
I am really very grateful to you sir.Your tutorial lectures tremendously help me to do very well in the sem.Thank u very much sir...
@sketchesbyMg
@sketchesbyMg 6 жыл бұрын
Well done sir !!!You are a brilliant teacher..
@sustadasgupta2780
@sustadasgupta2780 4 жыл бұрын
Candidate key is a minimal form of super key as sir has explained. So, at first we are finding out the minimal version of super key , i.e. candidate key, or any super key? Also, the Prime attribute that we need to check for 3NF...is the Prime attribute a part of a super key or necessarily a part of a Candidate key?
@AMITSINGH-nq4sy
@AMITSINGH-nq4sy 2 жыл бұрын
Sir In example no.5 wrong candidate key is being defined in the video at time 22.04
@patelurvesh9404
@patelurvesh9404 8 жыл бұрын
Sir you have done a great job. I am enjoying your teaching.thank you so much. Sir one request to you that please upload whole course of DBMS. I hope you will think on request. And thanks again.
@darshanpatel_1611
@darshanpatel_1611 Жыл бұрын
Maja aa gaya bhai Pura Chapter Clear ho gaya 😅❤
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
Glad to know this❤ Keep learning & supporting! Stay connected for more amazing videos & contents 👍 You can also check out our CS bundle course for complete preparation of Computer Science subjects, sharing course link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
@VivekSharma-yl9ki
@VivekSharma-yl9ki 7 жыл бұрын
In the eighth example, ABD-->E, You take it as a fully dependency but how it can possible because AB is the subset of ABD and D is the part of ACD.
@shwetashirsat383
@shwetashirsat383 6 жыл бұрын
Thank you so much sir..It is very much helpful for my NET exam.... God bless you abundantly...
@madhavmohan5754
@madhavmohan5754 3 жыл бұрын
Sir, in the 3rd example I am feeling doubt as you are saying "DC" are a non-prime attributes but "BDC" is a candidate key in itself at you said 17:04 "DC" is not a part of candidate key!, sir please help
@59ks68
@59ks68 6 жыл бұрын
Thx sir,i watch your video before my exam,its cover my whole semester lesson.
@PakistaniMaterial
@PakistaniMaterial 6 жыл бұрын
*Sir, Your lectures are great
@shekharkumar8780
@shekharkumar8780 5 жыл бұрын
yes
@InformaticaVids
@InformaticaVids 7 жыл бұрын
Given R(ABCD) and AB → C ; ABD → C ; ABC → D ; AC → D which the highest possible normal form for the above relation ?
@dheervaryani5873
@dheervaryani5873 7 жыл бұрын
Arup Dey 3nf is the answer?
@warunparker4061
@warunparker4061 6 жыл бұрын
AB is the candidate key and now if we check 1) It's not in BCNF because AC is not a super key 2) it's not in 3NF because first three fd no problem but last one AC here it's not a candidate key or a super key. So check RHS is that a prime attribute? (part of candidate key!?) Nooo D isn't. Therefore it's not in 3NF 3) and also AC->D D depends on A. Therfore Partial dependency therefore not even in 2NF Answer 1NF
@asitbiswas1242
@asitbiswas1242 4 жыл бұрын
@@warunparker4061 till the 2nd point that is all right. But in the 3 rd one As AB is the candidate key so in case of 2 NF in left hand side there must be a proper subset of candidate key. As AC is not a proper sub set of AB thats why it will be of 2 NF. So the highest possible Normal Form will be 2 NF.
@asitbiswas1242
@asitbiswas1242 4 жыл бұрын
2 NF
@bhumikasharma2281
@bhumikasharma2281 7 жыл бұрын
Sir add more videos related to DBMS. Keep doing the nice work!!!
@asmaramushtaq8479
@asmaramushtaq8479 6 жыл бұрын
I need 2 learn 4th NF & 5th NF ...give tutorials on them
@brijeshsharma7273
@brijeshsharma7273 4 жыл бұрын
Salute to your explaining skills.. It helped me a lot...
@Alina-er9vv
@Alina-er9vv 4 жыл бұрын
In the bottom-up approach, since, we have checked for BCNF before, and we found out that alpha is not a key, we then went on to check 3NF, so instead of checking if alpha is a key (which we already figured that it's not), we can directly prove beta to be a prime attribute, right? That would save time.
@shantanu0707
@shantanu0707 4 жыл бұрын
I'm so thankful for these amazing videos. Please make videos on 4NF, 5NF, Multivalued dependency and DKNF
@vikash-mw9kt
@vikash-mw9kt 7 жыл бұрын
Its really a great video sir.....truly a great explanation.....keep it up
@arpitamaiti5623
@arpitamaiti5623 7 жыл бұрын
vikash choudhary caCapCAT
@WimpyWarlord
@WimpyWarlord 5 жыл бұрын
This is pure gold!
@shivamsaxena13
@shivamsaxena13 7 жыл бұрын
sir, i watched all your dbms videos from part 01 to part 16. your each and every video is quite simple and easy to understand. but in this video i have a small confusion in 3nf explanation. sir, is video se pehle ki jitni bhi videos hai usme aapne ye bataya hai ki koi table 3nf mein tab hi hogi jab wo 2nf ki sari condition ko satisfy kar rahi hogi aur usme transitive dependency (when a non prime attribute depend upon another non prime attribute) nahi hogi aur agar transitive dependency hogi to wo table 3nf mein nahi hogi. lekin sir is video mein jab aap first question ke A->DE mein 3nf check kr rhe hai tab A->DE mein transitive dependency to hai hi nahi kyunki DE bhale hi non prime attribute hai par A to prime attribute hai jiska matlab hua DE (non prime attribute) depend upon A (prime attribute). to sir mera question ye hai ki A->DE ko kis wajah se 3nf mein nahi rakha gaya hai ?
@anshgyl
@anshgyl 7 жыл бұрын
A --> DE ko 3NF me isliye nahi rakha qki woh toh 2NF me bhi nahi hai. 2NF ki condition hoti hai ki har NON-PRIME complete candidate key pe depend kare uske kisi part pe nahi, par yahan pe "DE" sirf "A" pe dependent hai, jabki 2NF me hone ke liye usse complete candidate key "AB" par dependent hona chahiye tha. Isliye hum isko 3NF me nahi rakh sakte.
@PravinJanjal92
@PravinJanjal92 7 жыл бұрын
thanks! this is the only video on net for soluttion
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 7 жыл бұрын
Thanks for appreciation.
@chinmayrath8494
@chinmayrath8494 6 жыл бұрын
Amazing video series. I absolutely love it!
@sandeepshyoran5906
@sandeepshyoran5906 7 жыл бұрын
thank you very much sir for such a simple and easy explanation for such type of complex topic
@ravikumarprajapati3950
@ravikumarprajapati3950 4 жыл бұрын
teaching technique is marvellous
@hashiratanjirou
@hashiratanjirou 4 жыл бұрын
I really enjoyed so much to watch this video.Welldone sir.Keep it up🙏👍👌🏻
@vinayaksharma-ys3ip
@vinayaksharma-ys3ip 2 жыл бұрын
Great Lecture Sir!!!
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
Thank you so much dear Vinayak :) keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
@shashanksharma4377
@shashanksharma4377 4 жыл бұрын
Wahh...Kya baat hai (3 Idiots movie dialogue fits perfectly here) 😀
@shortsongs2
@shortsongs2 6 жыл бұрын
the way you teaching is awesome....!
@manojrao327
@manojrao327 6 жыл бұрын
u r great sir
@ashutoshomer5269
@ashutoshomer5269 7 жыл бұрын
Thank you very much sir .... Well explained
@sandeepKumar-hc1co
@sandeepKumar-hc1co 7 жыл бұрын
thank u very much sir,very good explaination.
@utkarshagrawal839
@utkarshagrawal839 7 жыл бұрын
you are doing a great job sir
@Mahaveerkeyluck
@Mahaveerkeyluck 6 жыл бұрын
Thanks for making these video,and big thanks for making these video free.
@food__o__graphy
@food__o__graphy 7 жыл бұрын
Your teaching style is TOO GOOD!
@suvadipghosh1385
@suvadipghosh1385 7 жыл бұрын
i am privileged to get you sir...it made me a master
@AmitVerma-gi8bg
@AmitVerma-gi8bg 6 жыл бұрын
A lot of thanks sir you are grate and your teaching style is awesome.
@jeeteshgupta7634
@jeeteshgupta7634 7 жыл бұрын
Sir Please upload whole series on IDBMS.. We have to prepare for End Sem .. Please !!!!
4.14 How to Identify Normal Form Practice Question Part-2
12:27
KnowledgeGATE by Sanchit Sir
Рет қаралды 129 М.
4.15 How to Identify Normal Form Practice Question Part-3
30:54
KnowledgeGATE by Sanchit Sir
Рет қаралды 227 М.
这是自救的好办法 #路飞#海贼王
00:43
路飞与唐舞桐
Рет қаралды 66 МЛН
This dad wins Halloween! 🎃💀
01:00
Justin Flom
Рет қаралды 41 МЛН
4.11 BCNF Boyce Codd Normal Form
10:21
KnowledgeGATE by Sanchit Sir
Рет қаралды 800 М.
4.16 Lossless Join Decomposition in DBMS in HINDI Part-1
16:29
KnowledgeGATE by Sanchit Sir
Рет қаралды 327 М.
Database Normalization 1NF 2NF 3NF
10:26
Jesper Lowgren
Рет қаралды 173 М.
4.2 Basic Concept of Normalization
13:34
KnowledgeGATE by Sanchit Sir
Рет қаралды 739 М.
Boyce-Codd Normal Form (BCNF) | Database Normalization | DBMS
4:42
Studytonight with Abhishek
Рет қаралды 781 М.
functional dependency in dbms
7:45
Education 4u
Рет қаралды 389 М.
Normalization - 1NF, 2NF, 3NF and 4NF
19:02
channel5567
Рет қаралды 2,2 МЛН
1st, 2nd and 3rd Normal Form (Database Normalisation)
11:42
Learn Learn Scratch Tutorials
Рет қаралды 446 М.
4th Normal Form (4NF) | Multi-Valued Dependency | Database Normalization
4:51
Studytonight with Abhishek
Рет қаралды 518 М.
Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
28:34
Decomplexify
Рет қаралды 2 МЛН