Lec 21: What is Canonical Cover in DBMS | Minimal cover Irreducible with example

Поделиться
HTML-код
  • Опубликовано: 27 ноя 2024

Комментарии • 188

  • @JennyslecturesCSIT
    @JennyslecturesCSIT  4 года назад +15

    Simplilearn Course Link (Full Stack JAVA Developer):
    www.simplilearn.com/java-full-stack-developer-certification-training-course?Jenny&March2020

    • @princepratikvines2555
      @princepratikvines2555 4 года назад +1

      Mam please make videos on design and analysis algorithm ,mam it's very important for us

  • @ragv435
    @ragv435 2 года назад +84

    My entire engineering career is dependent on your videos. Im extremely grateful!!!

    • @liemle8084
      @liemle8084 Год назад +1

      LOL =)))), her video is very useful

  • @tarunkumararcot7551
    @tarunkumararcot7551 4 года назад +17

    Ma'am you are the best teacher for me..You have encouraged me to study all these subjects..I have lots of subjects in my current fourth sem....I have dbms,algorithms,java,web(html,css,javascript,php,nodejs,angularjs),Operating systems in just one semester..I know it is headache to study all these subjects in just one semester i.e. 4 months for me..It is driving me crazy...Thanks a lot for your help.I have understood all the concepts because of you in algorithm and OS..Please do all the other subjects as well...You are the best teacher and mentor for me...

  • @_IshikaGupta
    @_IshikaGupta 3 года назад +58

    Another canonical cover I got for this ques is :{B->C, C->A, C->B, A->C}

    • @NikhilKumar-ry7eg
      @NikhilKumar-ry7eg 3 года назад +2

      yep same

    • @ranjeet5806
      @ranjeet5806 3 года назад +6

      same . I think she messed up in AC->B . instead of removing this AC->B as C->B exist. She change AC->B to A->B.

    • @rohmanatasi1771
      @rohmanatasi1771 3 года назад +2

      B--->C , C---->A
      this means , B---->A , according to transitivity.
      so i GUESS , we can do it like this {B->A,C->B,A->C}.
      I got the same answer btw :/

    • @CYB3r_D3m0n
      @CYB3r_D3m0n 2 года назад +3

      @@ranjeet5806 like she said there are many ans depending on which u choose to eliminate , so just follow the rules

    • @chandu5904
      @chandu5904 2 года назад

      @@ranjeet5806 she is correct only

  • @anurajsingh8137
    @anurajsingh8137 4 года назад +14

    Mam in previous sem exams I got 10 out of 10 points on Data structures and algorithms, thanks mam for your support.

    • @devisals
      @devisals 2 года назад +1

      Well done bro!

  • @RaviKumar-gw2ew
    @RaviKumar-gw2ew 4 года назад +2

    Mam your video lectures are just at another level...better than any other coaching institution...your level of effort on every video is just awesome mam...and mam finally all i would like to say is that If you stood in front of a mirror holding 11 roses...you will see 12 of the most beautiful things!!!😊😊

  • @rishabhshailesh4146
    @rishabhshailesh4146 3 года назад +14

    Hi ma'am, I am like a new student on this course. Really loving it!! In this video you promised that you'll make a video on multi valued FD and 4NF and 5NF. Please make a video on them too.. I'm really enjoying this video series.. I have learnt alot. I'm about to complete the whole course and now I'm having alot of confidence on DBMS. Before your videos I have tried to learn from geeksforgeeks and a udemy course but I really like your way of teaching. You are giving alot of knowledge to the students like us for free.. I really appreciate the hard work of yours.

  • @sukh-e4206
    @sukh-e4206 4 года назад +15

    I was waiting for your video for a long time.Finally your video on dbms comes.I am prepared for gate 2021.Thanks mam.Lots of love from Pathankot-Punjab

  • @ashokchougule3979
    @ashokchougule3979 4 года назад +1

    Your teaching skills are very nice Mam
    Now I am BCA 1st year and I have a subject c program
    It is very interesting subject for me
    Thank you for helping me to learn c program

  • @slevencross2714
    @slevencross2714 4 года назад +5

    I just want to say I Love you 😍 I'm from Philippines and you are my new found INSPIRATION 😍

    • @slevencross2714
      @slevencross2714 4 года назад

      Actually you helped me understand the AVL TREES in the the most simpliest way possible and that's what brought me here 😊

  • @madhupadayeswanth1865
    @madhupadayeswanth1865 Год назад +3

    Hi ma'am, I am like a new student on this course. Really loving it!! In this video you promised that you'll make a video on multi valued FD and 4NF and 5NF. Please make a video on them too.. I'm really enjoying this video series.. I have learnt alot.

  • @manojdeva379
    @manojdeva379 2 года назад +4

    Wowww finally got the concept of canonical cover😍 Tq mam

  • @yashsinghal3741
    @yashsinghal3741 2 года назад +5

    this series is amazing and exactly what I was looking for. thank you soo much!

  • @Witcheridoo
    @Witcheridoo 4 года назад +5

    This literally helped me so much thank you! Youre a great teacher

  • @shockedbyjoy
    @shockedbyjoy 4 года назад +3

    Thanks for these videos, Jenny! You are a wonderful teacher and they are really helpful. You explain things better than my professors. :)

  • @shivapatel2569
    @shivapatel2569 4 года назад +7

    Extraordinary lecture
    Really helpful!!!

  • @madhaviperla4402
    @madhaviperla4402 4 года назад

    After one month video from jenny lectures...thanku u sooo much...

  • @dyyno5578
    @dyyno5578 4 года назад +26

    4:00 thank me later

  • @katesaychaleun6322
    @katesaychaleun6322 Год назад

    You're a goddess. Your explanation is gold.
    One of your video is enough to cover my entire lecture haha

  • @mister_meatloaf
    @mister_meatloaf Год назад

    You're brilliant. Answered my query so easily.

  • @AnjaliVerma-zr1jn
    @AnjaliVerma-zr1jn 4 года назад +6

    mam, your lecture series are just amazing u let us learn in one go and no douts are left. Please make lecture series in ER model concept , relational model and concurrency control.. wating for ur uploads...

  • @geogaddi84
    @geogaddi84 2 года назад

    The last step with finding the closure of every one is a bit tedious, but at least now I feel like I understand how to do the whole process. Thanks!

  • @omprakashsharma9767
    @omprakashsharma9767 4 года назад +4

    Finalyy !! thanks a lot in the inception of the video :) your smile

  • @mirzahid223
    @mirzahid223 4 года назад +2

    For 1:00 part iPATE is now latest examination in India .
    And mam for you ( I am having a habit of watching lectures at a playback speed of 1.75x and I did so with yours too , by doing so I was surprised please check it once . And mention me 😊

  • @hamzazaibrajput9794
    @hamzazaibrajput9794 4 года назад +15

    Happy Birthday mam
    your tecahing method is very good
    M from Pakistan 🇵🇰

  • @anasioannis566
    @anasioannis566 4 года назад

    Excellent teaching.Your students are very lucky

  • @vaishalithakur7298
    @vaishalithakur7298 3 года назад

    Thanku mam... I've seen so many videos but doubts mere yahi clear hue

  • @movies7474movies
    @movies7474movies 4 года назад

    YOU ARE A FANTASTIC TEACHER.
    WHENEVER I WATCH YOUR VIDEOS.
    I HAVE TO WATCH IT THREE TIMES
    BECAUSE YOU ARE VERY BEAUTIFUL
    AND IT OBVIOUSLY DISTURBS MY CONCENTRATION.
    LOVE YOU MAM.

  • @liemle8084
    @liemle8084 Год назад +1

    thank you teacher, from VietNam

  • @ranjeet5806
    @ranjeet5806 3 года назад +8

    I got this ques answer :{B->C, C->A, C->B, A->C}
    I think she messed up in AC->B . instead of removing this AC->B as C->B exist. She changed AC->B to A->B.

  • @c.danielpremkumar8495
    @c.danielpremkumar8495 4 года назад

    Thanķs very much for your reply. Don't bother about delay.

  • @kapil8178
    @kapil8178 4 года назад

    Mam your hard work is highly adorable....

  • @avneeshkumar2433
    @avneeshkumar2433 4 года назад +3

    Looking nice mam

  • @Devkumar-en7zu
    @Devkumar-en7zu 7 месяцев назад

    You really teach awesome mam.
    Understood the topics in one go itself. Thankyou 😊
    It would be helpful of there would be video on plsql also

  • @csboi5235
    @csboi5235 2 года назад +1

    notes :
    14:43 : remove the extraneous attributes from left side and remove the trivial dependencies.

    • @vaalarivan_p
      @vaalarivan_p 2 года назад

      extraneous attributes : 7:00

  • @findyourtreasure6024
    @findyourtreasure6024 2 года назад

    Tomorrow my continuous internal evolution exam thank you for this video mam

  • @aishwaryakg2411
    @aishwaryakg2411 2 года назад +4

    Is c->a, b->c, c->b, a->c a canonical form???
    Please do tell please....

  • @rahulsrivastava7017
    @rahulsrivastava7017 4 года назад +1

    lecture starts at 4:11

  • @君の名前わ
    @君の名前わ 2 года назад

    REALLY APPRECIATE FOR THE VIDEO!

  • @ashutoshardu
    @ashutoshardu 3 года назад

    Thank you so much
    Keep up the gud work!!

  • @sitaramdhanak1033
    @sitaramdhanak1033 4 года назад

    Mam ji bhut ache ho aap

  • @ruifazhou7300
    @ruifazhou7300 3 года назад

    Very helpful! Thanks!

  • @dilipsoni6128
    @dilipsoni6128 Год назад

    Tysm for this example 😊

  • @sitaramdhanak1033
    @sitaramdhanak1033 4 года назад

    Raj.14000 vicancy aayegi to aap acha pdate ho esliye aap se nivedan hai ji

  • @user-he1ce9fs3l
    @user-he1ce9fs3l 4 года назад

    God bless you

  • @healthyshorts8601
    @healthyshorts8601 Год назад

    Thanks Mam. I passed my Exams!

  • @herodyapp
    @herodyapp 4 года назад +1

    Mam please make a series on Algorithms

  • @eagle_shadow6665
    @eagle_shadow6665 2 года назад +1

    Great ful mam 💫👑

  • @BWG05
    @BWG05 Год назад

    thank you ma'am

  • @krupeshjoshi5257
    @krupeshjoshi5257 4 года назад

    Closure of AC ={ A,C,B}
    Also C--> B so we can ignore C in AC, It will not impact on the whole function.

  • @KuldeepKumar-ks8uh
    @KuldeepKumar-ks8uh 4 года назад +1

    Hi miss,pls upload video on Java Programming,I want to learn Java Programming

  • @magistrtelebe50
    @magistrtelebe50 4 года назад +2

    Hello Jenny. Please can you suggest me the books you have read about the database?

  • @neerajverma942
    @neerajverma942 4 года назад

    Thanks a lot mam.❤️😀

  • @tanishasen5690
    @tanishasen5690 3 года назад

    thanks

  • @ytchen9227
    @ytchen9227 3 года назад

    Thank you for saving me at 5 am

  • @kishanbeladiya1233
    @kishanbeladiya1233 4 года назад +3

    Thanks a lot for your efforts mam and I want to know in which collage you completed your b.tech ? Let's my college is NIT. Thank you.☺️☺️

  • @ankanaroy7924
    @ankanaroy7924 2 года назад

    very helpful

  • @adityachaudari4321
    @adityachaudari4321 2 года назад

    beautiful

  • @luckyoggog
    @luckyoggog Месяц назад

    Thanks ma'am🥹

  • @FactifyFables1234
    @FactifyFables1234 4 года назад +2

    Good mam keep going mam

  • @hetgaming5943
    @hetgaming5943 2 года назад

    Thanks mam ☺️

  • @abhinaykushwah2768
    @abhinaykushwah2768 4 года назад

    U r so cute so beautiful mam😘😘😘♥️♥️♥️if u r my teacher then i will definately score 100 on 100 on any subject ☺️☺️☺️😊😊😊😊😊

  • @ashupandit2889
    @ashupandit2889 4 года назад +4

    Lots of love from JNU NEW DELHI

  • @aakash8418
    @aakash8418 4 года назад +1

    Mam how to solve NP hard problm in polynomial time🙂 , mam iss topic ke upar ek video Bana do plzz🙃

  • @akashsingh-mp4nr
    @akashsingh-mp4nr 4 года назад +14

    Ma'am you're so cute... I'm arts student still watched whole video...lol😂😂😅😅❤️

    • @manu-singh
      @manu-singh 4 года назад +5

      Bhag saale

    • @harleendiaries
      @harleendiaries 4 года назад +1

      Hahaha, your comment is cute... and funny of course. 😂😂

    • @akashsingh-mp4nr
      @akashsingh-mp4nr 4 года назад +1

      @@harleendiaries thanku you're cute too 😂😬🥰

  • @yashverma2587
    @yashverma2587 4 года назад

    Mam kuch samajh nhi aaya pr dekh ke achha lga

  • @kailashuv3028
    @kailashuv3028 4 года назад

    Mam can you please make a video about lpp simplex method ....please mam ....next week i'm having test but i can't go out due to epidemic...i'm lot confused with the lpp simplex method.....my only last hope is your video mam! It will be more useful to many....
    Thank you mam

  • @c.danielpremkumar8495
    @c.danielpremkumar8495 4 года назад +1

    7:30 this is as good as splitting LHS of an FD (which is not allowed). Since AB-C is not the same as A-C & B-C. Clarification would be appreciated.

    • @rohandilip4173
      @rohandilip4173 4 года назад

      A-C means a can derive c.(If there is a there will be c for sure). B-C means that b can derive c. (if there is b there will be c for sure)
      AB-C means that a and b both combined can be used to derive c. The values of both a and b determines the value of c. so we can only say that if both are present,then only c is present and not if one of them. Hope its clear.
      Anyway sorry for the delay in reply

  • @shivapatel2569
    @shivapatel2569 4 года назад +3

    I am the 18 viewer of the this vedio

  • @aashishshrestha8180
    @aashishshrestha8180 4 года назад +1

    can you please make a video on ER model and relationship...

  • @nitingovil391
    @nitingovil391 4 года назад +1

    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

    • @simplegupta9142
      @simplegupta9142 4 года назад +1

      Bro I tried its { PQ -> R, QS-> P, PR->Q, S->R}

    • @nitingovil391
      @nitingovil391 4 года назад +1

      @@simplegupta9142 thank you I got the same💖

    • @simplegupta9142
      @simplegupta9142 3 года назад +1

      @@nitingovil391 welcome💜

  • @PavanKumar-wx2hd
    @PavanKumar-wx2hd 4 года назад +1

    Ma'am can you explain algorithms and how to find the complexity of the programs

  • @sudo07
    @sudo07 4 года назад

    Meri exam aj hi khtm hui fir bhi video dekhunga pura ☺

  • @keerthipriya3080
    @keerthipriya3080 2 года назад +1

    at 14:23 you did wrong mam. if A->C then why we discard C from AC->B?

  • @arunchinthalapally1724
    @arunchinthalapally1724 2 года назад +1

    Madam if you just move from the board after completing the topic then we can take screenshot.

  • @TheRiyazAhamad
    @TheRiyazAhamad 4 года назад

    I got c>a, b>c, a>c,c>b
    By using c>b in step 2

  • @AdiCode_Hub
    @AdiCode_Hub 3 месяца назад

    If anyone new here and found my comment , and Luckly you are a girl too, then if you are pretty and chubby then I love you ❤.

  • @mohammadruhiroshanara8225
    @mohammadruhiroshanara8225 4 года назад +1

    mam waiting for next video on 4nf and 5nf

  • @minivashishta9288
    @minivashishta9288 4 года назад

    thanku,mam

  • @achalparikh5731
    @achalparikh5731 4 года назад +1

    Kon kehta hain IT ka paper ho ga to me dar jaunga,
    Bete Jenny ke lecture dekhta hoon,
    Extra sheet bhar kar hi jaunga

  • @amitdubey1699
    @amitdubey1699 4 года назад +1

    Maam Java Ka Lectures Dalo..I would love to learn From You..

  • @ashutoshagrahari4896
    @ashutoshagrahari4896 4 года назад

    Mam plz make the video how to write algorithms in data structure of c

  • @wilsonailen5015
    @wilsonailen5015 3 года назад

    please, do you have a video for multivalued dependency and 4th normal form?

  • @Bloodyfuel
    @Bloodyfuel 4 года назад

    I dropped after graduation(cse) 2016 now I want to start again plz recommend/advice which way should I go either gate or private sector. thanku

  • @nihadthaslim21
    @nihadthaslim21 4 года назад

    Mam please do wireless communication lecture

  • @dhakshinamurthy51
    @dhakshinamurthy51 4 года назад

    Pls put videos on process synchronization 🙏, I feel difficult to understand

  • @findyourtreasure6024
    @findyourtreasure6024 2 года назад

    @4:00

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

    ❤❤

  • @KaranKumar-oz9mh
    @KaranKumar-oz9mh 4 года назад +1

    Happy Birthday mam.
    Aap party kab dogi..🍫🍫😭

  • @shauryabahl579
    @shauryabahl579 Год назад

    Ma'am, my answer is F = {C -> A, AB -> C, AC -> B} even if I've followed the rules...

  • @shahid2261
    @shahid2261 4 года назад +1

    Mam c programming b upload karo pls...

  • @sahilsharma7343
    @sahilsharma7343 3 года назад

    Maam is this a full course on DBMS as I am a CSE student and I need a full course to prepare for my semester exams.

  • @alakeshT
    @alakeshT 4 года назад

    Make video on Digital image processing yaar

  • @kartikpatil8462
    @kartikpatil8462 4 года назад +1

    Do you go to Doctor's gym in Kolhapur? I saw someone similar looking to you.

  • @AniketSingh-xn1hw
    @AniketSingh-xn1hw 2 года назад

    aap video bana band kariye exam ke liye apka video dekh ke padh raha tha puri raat sirf aapko dekhte reh gya fail bhi ho gya aapko koi haq nai banta ki aap itni khoobsurat lage

  • @himalagunathilaka2963
    @himalagunathilaka2963 4 дня назад

    🙏💖

  • @anusrutimitra1115
    @anusrutimitra1115 4 года назад +1

    when will you post maam about database transaction?

    • @ashokchougule3979
      @ashokchougule3979 4 года назад

      What is data base transaction?

    • @prakhar9886
      @prakhar9886 3 года назад +1

      @@ashokchougule3979 unit 4 in aktu syallubus

  • @ranjithkumarc2710
    @ranjithkumarc2710 4 года назад

    mam pls make video for 4th and 5th normal form

  • @neilagnihotri3240
    @neilagnihotri3240 4 года назад

    This is so similar to toc lhd to rhd

  • @vishalv3031
    @vishalv3031 3 года назад

    Mam what is best platform for full python course learning