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

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

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

50% 1

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

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

18 авг 2016

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

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

@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 6 месяцев назад

Sahi h

@sheifmomin7510 7 лет назад

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

@marvel438 5 лет назад

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

@ritik.bhardwaj889 4 года назад

LMAO😂

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

lmaooo

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

ha ha.

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

Yess ... add 7:05

@m.svinayak7277 2 года назад

@@trojanhorse8278 LMAO

@BaljeetSingh-zs7zz 6 лет назад

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

@sabyasachisome7329 6 лет назад

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.

@pooricooks3609 7 лет назад

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

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

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🙏🇮🇳🔥

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

4:40 remember dhammal😂😂😂😂😂😅

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

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

@vipinbohra4806 6 лет назад

Clearly Explain with cool mind.. Thanks

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

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

@ravneetkaur9175 7 лет назад

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

@nothingelse893 5 лет назад

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

@pragatiagrawal3773 5 лет назад

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

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

Thank you sir you have a great teaching skill.

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

You r right

@deepnarayanchaudhury8201 7 лет назад

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 :)

@PavanKumarN-Vlogs 6 лет назад

thanks a lot! your making DBMS learning easy!

@yashpunia 6 лет назад

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

@divyabharti3204 7 лет назад

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

@joitamondal7641 7 лет назад

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

@iRSarkar Год назад

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

@anuragkothare6181 7 лет назад

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

@udityarajsrivastva7403 7 лет назад

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

@lsuremusic3787 5 лет назад

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

@thatshowyoudoit8523 6 лет назад

your teaching method is very impressive .its Really helpful

@466edik 4 года назад

Thank you, really helped me out!

@7guitarlover 7 лет назад

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 =)

@orangutan79 7 лет назад

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

@nadimshakya3361 6 лет назад

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

@himanshu431 6 лет назад

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.

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

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

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

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

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

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

@harikachagantivlogs 7 лет назад

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

@KNOWLEDGEGATE_kg 7 лет назад

Thank you so much Harika

@rv589 6 лет назад

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

@shubhammahajan6696 6 лет назад

maf kare ya saf kare 🤣 🤣 🤣 🤣

@mrkunalgoswami2010 6 лет назад

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

@lakshayparashar1465 5 лет назад

Saaf karege B-)

@arbazshahab5965 Год назад

Sir ne to PDA ki yaad diladi

@pallavichoudhary8080 7 лет назад

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.

@AbhishekNigam 7 лет назад

Thanks a lot!

@ArpanPathak 7 лет назад

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.

@shubhamsaini3382 7 лет назад

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

@abhidevvaishnav7738 5 лет назад

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

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

Best explanation ever! Thank you

@abhishekpdy88 7 лет назад

Thank You Sir!! Gr8 Work

@wildglorypsn 7 лет назад

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

@KNOWLEDGEGATE_kg 7 лет назад

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

@shaillymegha2840 5 лет назад

Thanks sir..for such nice concepts..we love you knowledge gate😍

@chintalapativenkataramarahul 6 лет назад

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

@raghavmundra4006 6 лет назад

Venkata Rama Rahul Chintalapati i

@paragverma_ 7 лет назад

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

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

Amazing explanation sir!

@SumanMondal-td3hj 5 лет назад

Best! Thank you so much , sir!

@RohanSharma-eh4kf 7 лет назад

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

@vinamra95 7 лет назад

awesum sir.......thanks a lot for this amazing series of videos.....:)

@ptech4solutionsllc454 6 лет назад

Can you please upload some videos about relational algebra?

@rafaelperes6333 6 лет назад

Great explanation, sir.

@nontechnicalpuruji 7 лет назад

u deserve more subscriber. ur videos are really helpful.

@debojyotisaha7836 6 лет назад

Wonderful explanation sir..

@avinashsrivastava2247 6 лет назад

sir upload lecture videos on compiler design.

@princepatel1133 7 лет назад

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

@NEHAYADAV-zw8wi 3 года назад

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

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

@RahulKumar-um7tl 5 лет назад

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

@tamaldas3544 6 лет назад

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

@sudeshnamondal3380 6 лет назад

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

@sanketbeladiya5473 6 лет назад

sir mere problem he saf kardiya thanks sir

@ravneetkaur9175 7 лет назад

Plz upload vedios on lossless join decompostion

@kartickchandramanna267 Год назад

Excellent lecture 👍 Thank you sir 🙏❤️

@shuklaization 7 лет назад

gr8 explanation...........

@sabanaz9368 7 лет назад

Sir plz upload the videos for SQL and relational algebra and calculus

@AyanKhan-zr6gu 7 лет назад

sir are you going to add video on different subject like compiler design and networking

@sumankumarisao3434 6 лет назад

well explained

@ManishSharma-xq9be 6 лет назад

Perfect explanation

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

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

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

very good teaching sir.

@shivangiverma819 7 лет назад

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

@avinashsrivastava2247 6 лет назад

sir upload video on design and analysis of algorithm

@Make.money5 4 года назад

Thank u sir Love u sir For playlist

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

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

I also feel the same

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

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

@sushantsikka3813 7 лет назад

Great video... Thanks for the effort !

@KNOWLEDGEGATE_kg 7 лет назад

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. :)

@muskangarg905 6 лет назад

here if we could find z from w, then should if reduce the dependency to w->y by taking the wz->y fd in consideration. basically what i am asking do we include this fd wz->y while checking left side redundancy or not?

@Aysh_Sach_16-2 2 года назад

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

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

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

@subodhmishrasai4094 7 лет назад

sir on the last part when we are checking for w and z as extra or redundant we find that w is redundant. so we can remove w from L H S

@Harini.R 6 лет назад

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

@jitendrakumar2056 6 лет назад

Sir please make videos on complex sql queries..

@nilanjansantra3756 5 лет назад

thank you.

@mohsinalijafery2217 5 лет назад

clear explaination sir!

@abhijeetkaurav6981 7 лет назад

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.

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

@dreamermegha 5 лет назад

Thnkeww for this video sir..🙏🏻

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

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

@Aman-lo3jb 4 года назад

you are great, Sir

@ritusolanki4025 7 лет назад

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

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 :)

@prateekarya1998 5 лет назад

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

@muhammadsheraz3627 6 лет назад

thanks a lot god bless you

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

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

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

Thank you, keep learning👍😊

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

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

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

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?

@RohIt_bhopali 5 лет назад

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?

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

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

@shafaatmosvi 6 лет назад

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

@abbas3633 6 лет назад

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

@banashreeghosh5552 6 лет назад

Sir please upload more video about decomposition in normalisation form which relation contains more than one keys

@sid_mod 7 лет назад

You are awesome....

@prateekarya1998 5 лет назад

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