3.8 Minimal Cover or Canonical Cover or Irreducible set of Functional Dependencies

[@KNOWLEDGEGATE_kg]

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

[@oye_pritpal]

6 years ago these videos were uploaded and they are very relevant and fresh till date!!! great job sir, you really are a saviour!

[@KNOWLEDGEGATE_kg]

Thank you so much dear ❤ keep learning & supporting! You can also check out our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@bhavyabansal8938]

@@KNOWLEDGEGATE_kg yeah it's not even Tommorow actually today is my university exam in afternoon and all of us are taking reference of your videos these are just amazing.... tysm sir for your efforts ❤️

[@TM-jx6et]

Sahi h

[@sheifmomin7510]

I normally don't comment on youtube videos, but I want to tell you that this normalization series is exceptional. Thank you so much.!!

[@sabyasachisome7329]

The videos are so crisp and clear that anybody would understand DBMS just by gazing at them. It would be so very generous of you if you please suggest some books or online pdfs to practice problems based on the topics present in this as well as other lectures of ours, specially the normalization and relational algebra part. Thanks and Congrats in advance for the awesome work.

[@ayushiydvKG]

14: 09 sir X->W, WZ->Y, Y->Z should be the correct canonical cover. Y->X is not essentially required.

[@BaljeetSingh-zs7zz]

Well Done , I can see very organized efforts, Long Live and Stay Healthy God Bless You...

[@marvel438]

4:12 That's what my last job said.

[@ritik.bhardwaj889]

LMAO😂

[@humortman]

lmaooo

[@ashishjangid1298]

ha ha.

[@trojanhorse8278]

Yess ... add 7:05

[@m.svinayak7277]

@@trojanhorse8278 LMAO

[@tunedinkala]

The selfless effort you are putting in ..must be showered with gratitude ..Thank you so much.

[@me.rajuofficial]

Aacha huya sir g aap koi universities mein na jakar Kiuki hum logoko koi ek best understanding guide mil gaya hai clg mein ghanto ka lecture sunne k bhi utna samaj nahi aata hai wajah aapka 1 explanation vdo kafi hai Aap jaise teacher aur bhi jarurat hai society mein 👍 🙏

[@KNOWLEDGEGATE_kg]

Thank you so much dear for your valuable feedback❤ Keep learning & supporting! Do check out our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@aaa_1711]

Hello everyone, what is the correct procedure of finding redundancy on the LHS??? Actually in present and next video sir has taken different steps, in this video: while checking if there's any redundancy on LHS at 11:35, sir has ignored one functional dependency which was "wz=>y"... But in the next video in the same method(video name 3.9 practise questions..), at 19:45, sir has not ignored "vw=>x". And if we do not ignore "vw=>x", we get a different result.. What is the correct way!!!

[@ANUSHKAVARPE-v6q]

Got any solution??

[@kiiilangli5045]

That famous dialogue! Maaf kre ke saaf kre! 😂😂! . . . Btw Sir your teaching style is just incomparable! You saved me last year! And this year I hope I'll get quite decent marks! And obviously just because of you🙏🇮🇳🔥

[@indrajeetbanerjee3893]

Most complete lecture on Minimal Cover till date!!

[@harikachagantivlogs]

your lectures are really helpful...your single lecture is very clear than the hours that our lectures take to explain each topic

[@KNOWLEDGEGATE_kg]

Thank you so much Harika

[@vishes1655]

How you simplified the things are just remarkable. You are best of the best.

[@KNOWLEDGEGATE_kg]

Thank you so much dear Vishes for your kind words❤ Keep learning & stay connected 👍

[@pragatiagrawal3773]

✌️the most amazing person with the most amazing skill😍

[@pragatiagrawal3773]

Thank you sir you have a great teaching skill.

[@jitendrasharma8062]

You r right

[@NEHAYADAV-zw8wi]

What an explanation I mean how smoothly you explain all topics just another level Hats off to you sir and thank you so much

[@KNOWLEDGEGATE_kg]

You're most welcome Neha.. and thank you for your valuable feedback.. Keep learning and supporting !!

[@7guitarlover]

Awesome Video Sir !!! What took my prof 50 min to teach ; you taught in 15min and that too far better than him !!Eagerly Waiting for Normalization Video !!! Keep up the good work =)

[@wildglorypsn]

Very helpful....I am gaining much more confidence in DBMS because of your videos.Thank you so much!

[@KNOWLEDGEGATE_kg]

We are glad that we could be helpful :) :) Hit the subscribe button for best tutorials.

[@Reequat]

Sir, your videos are more better understandable then our professors.....Thank you sir for making the lectures on youtube.

[@akashh5238]

4:40 remember dhammal😂😂😂😂😂😅

[@ravneetkaur9175]

Extremely helpful.Best method of teaching. Thanks a lot sir👍🏼👍🏼i am gaining much knowlegde , which we cant get ftom reading books.

[@inspired_enough_to_grow_up]

5 saal pahle k lectures aaj bhi utne hi relevant!! level man

[@KNOWLEDGEGATE_kg]

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

[@tirtharajsapkota3149]

very nice explanation but one thing ..we shouldn't say x tends to to y..we should rather say x determines y(x-->y)

[@pratap20201]

F = {A ----> B, ABCD ----> E, EF ----> G, EF ----> H, ACDF ----> EG} find canonical cover Sir

[@anshgyl]

A --> B ACD --> E EF --> GH ACDF --> G

[@nothingelse893]

I am appreciate for ur work, which help me a lot. Thanks again. I think ur lectures are much better than the lecture of Top 20's university

[@deepnarayanchaudhury8201]

Hello sir, thank you for making such wonderful videos.They're really helping me get a lot ideas regarding dbms. Hopefully you will be covering other aspects of dbms. Eagerly waiting for the rest of the topics. Thank you :)

[@nitingovil391]

Consider a given relation R=(P,Q,R,S) with following set of FDs: PQ→R PS→Q QS→P PR→Q S→R Find the minimal set of FDs from the above set. Please help

[@labs2612]

BEST VIDEO FOR CANONICAL COVER

[@KNOWLEDGEGATE_kg]

Thanks a lot dear for your valuable feedback ❤ Keep learning & supporting! Stay connected for more amazing contents & videos 👍

[@YashGupta-xg4gs]

sir ma bohot dino se GATE SMASHER channel se padh ra tha unki concept pura ( geek for geek) site se liya gaya ha jo ke dimag me easily nahi ghuss raha tha BUT FIR APP KA CHANNEL MILA---bass fir jo chizz samajhne me 2 din lag ra tha wo app ke ek video dekhne me he ho ga ra ha

[@KNOWLEDGEGATE_kg]

Thanks a lot dear for your valuable feedback❤ 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

[@dr.amandeep6752]

Sir ur lectures on dbms specially normalisation are the best among all other KZbinrs...i really appreciate your efforts....

[@KNOWLEDGEGATE_kg]

Thank you so much Amandeep, am glad you liked our content. Stay connected for more content & keep learning👍

[@prateekarya1998]

Sir can we write minimal functional dependecy as A->B,C->B,D->BC,AC->D to AC->DBC,C->B,D->BC

[@swayampravasahu]

the best teacher ever thank u sir

[@KNOWLEDGEGATE_kg]

You're welcome dear, stay blessed 🥰🥰 Keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@azverndias913]

Finally a video that blindly dooesnt tell u what to do but actually explains.

[@KNOWLEDGEGATE_kg]

Thank you, keep learning👍😊

[@thatshowyoudoit8523]

your teaching method is very impressive .its Really helpful

[@RohanSharma-eh4kf]

How we can prove that AB -> C A -> C In the above two FD , B is extraneous by using the method you have given?

[@joitamondal7641]

Thnak you sir....fr such splendid video tutorials.....sir it will be more helpful if you upload full length tutorial videos on DBMS.

[@yatharthsaxena9515]

I have a doubt. When I am checking ""is Z redundant in WZ->Y ?"" then why we are hiding "WZ->Y" completely. Rather what we should do, is to HIDE ONLY Z i.e. keeping "W->Y" Because if Z is redundant in WZ->Y , then resulting FD will be W->Y.

[@preksharai5321]

I also feel the same

[@sarthakgupta3338]

No you cant do that because you have chosen wz from that particular so you will hide all hope it understoood.

[@yashpunia]

Sir I learned alot from all yours videos Sir can you please tell about Er diagrams

[@udityarajsrivastva7403]

thankyou sir,your video helped me in scoring 10 marks in UPTU 2016 exam preparation

[@orangutan79]

Because of you, I learned both Databases logic and also Hindi, lol!

[@anuragkothare6181]

You are Just Amazing Sir ...Very Useful videos.

[@himanshu431]

sir you know what? you are the best teacher thanks a lot for the videos.Please keep your channel always active and upload more videos. Thanks once again.

[@pallavichoudhary8080]

Hi, You make a great teacher.No matter which topic you take,you make it a point to give a clear explanation of that topic. A quick question you said in the video that it is a introductory video hence the topic is not covered in deep.I am preparing for Gate,can you suggest me any book for covering this topic in deep.

[@ArpanPathak]

You are the best sir.. hats off.. what an explanation . I'm really enjoying your videos otherwise these theories were not making any sense to me.

[@sanketbeladiya5473]

sir mere problem he saf kardiya thanks sir

[@vipinbohra4806]

Clearly Explain with cool mind.. Thanks

[@divyabharti3204]

This is the best explanation. Thank you very much Sir :) God Bless you

[@mihirsheth9918]

Wonderful. Got complete clarity! Thanks sirji 🙏

[@KNOWLEDGEGATE_kg]

Most welcome dear @mihir! Keep learning & stay connected! You can also check out our website www.knowledgegate.in for more amazing videos & contents👍😊

[@ritusolanki4025]

sir i have subscribed you channel... ... sir plz upload videos for CO also....ur video creates my interest in dbms for which i had phobia but now it is interesting for me...

[@KNOWLEDGEGATE_kg]

Hi Ritu, Thank you so much for showing your interest, We are working on CO. Ans we are glad that we could help you out :)

[@kartickchandramanna267]

Excellent lecture 👍 Thank you sir 🙏❤️

[@ojjasvijain8773]

Amazing teaching style sir...... thank u so much for all videos

[@viky4215]

There is a set of functional dependency F={A->C,AC->D.E->AD,E->H}. In the functional dependency AC->D, is C redundant?

[@anshgyl]

Yes C is redundant as "A --> C" & "AC --> D" hence we can simply say "A --> CD" But this statement would be valid in only this case as all the closures would remain the same even after this modification.

[@abbas3633]

outstanding sir..........plz gate oriented sql topic video upload plz......love sir

[@rupeshshete6162]

very good teaching sir.

[@pratapkumar3434]

Revision krrha hu m.... Sir u r just amazing

[@chintalapativenkataramarahul]

Very clear explaination sir! Very very helpful sir. Thank you very much!

[@raghavmundra4006]

Venkata Rama Rahul Chintalapati i

[@Shalikram]

i can't find canical cover ac -> g d -> eg bc -> d cg -> bd acd -> b ce -> ag

[@taylenaloverx03]

Canonical Cover for this sum is d->eg bc->d cg->d acd->b ce->ag

[@amaxcool99]

Best explanation ever! Thank you

[@shivamk3397]

Awesome teacher

[@KNOWLEDGEGATE_kg]

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

[@lsuremusic3787]

Wow!!!! What an explanation.. I m stunned. Thnk u sir

[@abhijeetkaurav6981]

sir, in the last step(in simplifying LHS), that particular (wz-y in given example) should be hidden or not while computing (wz-z)+ or (wz-w)+. It is more confusing. In some places(other's solutions) it is not hidden ans sir you have advised to hide it. Please clear the doubt. I will be highly obliged to you for it.

[@rv589]

Great effort, thanx sir, I'm clear many topic by the help of your video. Thnx o lot

[@paragverma_]

Great Job on the content! I have a suggestion... There's a slight background noise in the audio, I think a bit of audio processing to strip the noise will definitely improve audio clarity...

[@shubhamsaini3382]

i appreciate your work sir will u plz upload the lectures on transaction ,concurrency and file andd indexing thanks for developing my intrest in dbms.. really appreciable..

[@236__kumarmanvendra2]

what do you mean by i am not going into the depth of the topic , does these videos are helpful for college exams

[@sudeshnamondal3380]

Exams Tomorrow but u mde it easy....respect sir😊

[@PavanKumarN-Vlogs]

thanks a lot! your making DBMS learning easy!

[@KNOWLEDGEGATE_kg]

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

[@divyasrinandamuri2823]

Thank you because of your classes i learnt few concepts in compiler as well as DBMS 🙏

[@RahulKumar-um7tl]

Very good explanation of every topic , please post a video of concurrency control (lock based protocol)

[@nontechnicalpuruji]

u deserve more subscriber. ur videos are really helpful.

[@debojyotisaha7836]

Wonderful explanation sir..

[@zacle1641]

Your videos helped me to get a good grade in database. Thank you so much

[@KNOWLEDGEGATE_kg]

Hi Zacle Programmer Thank you so much for your encouraging words. We upload more topics every week, Please subscribe this channel for best GATE tutorials.

[@prateekarya1998]

if f.d. ={A->B,C->B.D->ABC,AC->D} THEN WHAT SHOULD minimal fd for this ? i have some confuse in this as according to me my answer is A->B,C->B,D->BC,AC->D .IS IT RIGHT

[@nadimshakya3361]

very clear concept ! Helped me a lot .. thank you sir !

[@suchimaheshwari6129]

The best teacher🤩

[@tamaldas3544]

best explanation...........solid

[@shubhammahajan6696]

maf kare ya saf kare 🤣 🤣 🤣 🤣

[@mrkunalgoswami2010]

bhai nice explanation - i can say - mujhe maaf kare nahi to kudhh kuch kare

[@lakshayparashar1465]

Saaf karege B-)

[@arbazshahab5965]

Sir ne to PDA ki yaad diladi

[@shivangiverma819]

Great explaination sr.. plz if you can increase the contrast

[@ravneetkaur9175]

Plz upload vedios on lossless join decompostion

[@Arj_pnja]

vry helpful....plzz make videos of other topics also in dbms with details

[@KNOWLEDGEGATE_kg]

Hi Anand , we are happy that we could be helpful :) Yes, we shall soon :)

[@sushantsikka3813]

Great video... Thanks for the effort !

[@KNOWLEDGEGATE_kg]

Hi Suhsant, we truly appreciate your kind words for our efforts.We upload more topics every week, Please subscribe this channel for best GATE tutorials. :)

[@avinashsrivastava2247]

sir upload video on design and analysis of algorithm

[@sivaranjaniduraisamy8766]

2:32 In functional dependency , if y --> x and y --> z then x=z right? How can we decompose it like that? suppose if we have y --> 345 and y --> 346 is valid. But decomposing them will create violations in functional dependency right?

[@princepatel1133]

Thanks a lot sir your video is very useful great job.....

[@pragyarastogi9335]

What do you understand by the term closure of a relation (R) with functional dependency set (F) ? Compute the closure for relation R(/, m, n, o, p) with functional dependency set F as given below : F{/ -> mn; no -> p; m -> o; p l} Identify the candidate keys for the relation (R) i dont know how to solve it please help sir

[@RohIt_bhopali]

Sir , kindly explain how to find all other canonical covers of a given FD set, is there any short trick or any other permutations to know to actually how many Canonical covers are possible?

[@Harini.R]

WZ->Y can be replaced by W->Y right? Since through Y->Z we can get Z

[@shafaatmosvi]

"Maaf karo ya saaf karo." Splendid! :D

[@abhidevvaishnav7738]

so thankful for your channel videos, it's easy to understand via your videos :)

[@jaykadam3704]

Amazing explanation sir!

[@mohsinalijafery2217]

clear explaination sir!

[@reydias7044]

Sir i love u tenx 4 dis video i suksesfuly passed DBMS paper

[@kumarrahulraj2815]

sir, plz make videos on every topic of GATE examination.

[@shubhamtariyal439]

Great videos but too many ads

[@krishnaravishanker]

[@avinashsrivastava2247]

sir upload lecture videos on compiler design.

[@sumankumarisao3434]

well explained

[@Aman-lo3jb]

you are great, Sir

[@ManishSharma-xq9be]

Perfect explanation

[@namahshivaya9753]

Isko maaf karenge ya saaf karenge:) Sir your expressions and that wicked smile was ultimate at 7:03.