Lec6:What is Attribute Closure |Closure set of Attribute in DBMS | How to find Closure of Attributes

Поділитися
Вставка
  • Опубліковано 2 лют 2025

КОМЕНТАРІ • 215

  • @amansingh-mo9kb
    @amansingh-mo9kb 3 роки тому +45

    Just 27 min and you are master in closure this is what everyone student wants god bless you mam

  • @lejuan9002
    @lejuan9002 4 місяці тому +8

    I meet you again. DSA, C programing and now, DBSM. You are a life saver, mam

  • @rosscoppage3182
    @rosscoppage3182 Рік тому +11

    Jenny, you are awesome! I was confused but you CLEARLY explained each step perfectly for me!! I understand now and will help on my up coming test! 😊

  • @tanulrai3411
    @tanulrai3411 5 років тому +12

    Mam your Channel is going really fast . I am following your channel for 4 months and the content is good . Thanks for the Data structures playlist . It really helped me .

  • @drcrazzy1134
    @drcrazzy1134 3 роки тому +31

    Awesome lecture! Thanks from the US. Stay safe during this time

  • @aditidas7707
    @aditidas7707 4 роки тому +10

    I love your teaching techniques Ma'am... you are really the Goddess of DBMS. Please provide video lectures for other subjects of Computer Science as well. It would be really helpful.

  • @MyStockz
    @MyStockz 4 роки тому +42

    You deserve way more likes and subs. Too bad, those who watch these lectures are the ones who truly want to learn, or those who only want to pass. Still, it's very helpful

  • @hannahleah5875
    @hannahleah5875 Рік тому +3

    Thanks for this, very easy to understand, and the way you make a point at looking at the camera really kept me focused, thank you!

  • @azharsohail6074
    @azharsohail6074 5 років тому +3

    I was very confused to learn Data structure but u learned very very well.......Thank u so much from Pakistan

  • @memevik2237
    @memevik2237 4 роки тому +5

    It is a wonderful video. The concept is made crystal clear with zero doubt. Thanks a lot.

  • @clipsstudio2810
    @clipsstudio2810 Місяць тому

    I will declare this is the best video available on UA-cam to find closure.😮😮😮

  • @redrose5950
    @redrose5950 4 роки тому +8

    Your way of explanation is purely logical and to the point, brilliant Mam, thank you for this lecture.

  • @ankitsenentertainment9270
    @ankitsenentertainment9270 4 роки тому +5

    Please cover all the topics of dbms....your videos are super amazing..and it helps me to understand the topic from basic...after watching your videos i feel confident on that topic ..you are truly amazing...love you

  • @nanaminana5024
    @nanaminana5024 5 років тому +31

    Your lecture is amazing! Thank you so much!

  • @tushargupta2009
    @tushargupta2009 5 років тому +12

    Your way of explaining things is really ineffable and astonishing. Your lectures are the perfect healing for semester injured students. I really want to meet you once. Thank you mam.

  • @itsybitszy
    @itsybitszy 3 роки тому +6

    Crystal clear explanation ma'am. Way to go.

  • @naeemabbass8183
    @naeemabbass8183 5 років тому +5

    fabulous mam a i am from Pakistan i like the way you teach this series of lectures helps me for my Dbms paper thank u mam........

  • @TheAmigos2
    @TheAmigos2 4 місяці тому +1

    Your lecture is amazing! Thank you so much!😍

  • @고기집아들
    @고기집아들 2 роки тому +2

    way to go. more useful than our univ lec

  • @faustinsemela2757
    @faustinsemela2757 3 роки тому +1

    Thank you more jenny you are going to make me a champion,your lectures are interresting

  • @vijisekar4540
    @vijisekar4540 3 роки тому +5

    Speechless🥰♥️ ...thank u so much jeni from chennai

  • @KaranKumar-hs1fu
    @KaranKumar-hs1fu 2 роки тому

    maza aa gya... aapke jaisa teacher aaj tk nhi dekhaa.. aap bhot badiya pdhate ho mam #jenny_lecture

  • @radhagoyal3606
    @radhagoyal3606 3 роки тому +1

    Hey, I can't think of better lecture.
    This video cleared all doubts.

  • @basavarajneelagund1868
    @basavarajneelagund1868 4 роки тому +1

    Your teaching is excellent madam...liked the way you teach.

  • @zainuddin9484
    @zainuddin9484 3 роки тому +1

    Thank you very much, you deserve much more appreciation ❤

  • @prashanthd7068
    @prashanthd7068 2 роки тому +2

    Just watched your video, what a wonderful explanation! Loved it!

  • @tannubhardwaj5904
    @tannubhardwaj5904 Рік тому +1

    ❤❤ best teacher ever

  • @mmorales0113
    @mmorales0113 4 роки тому +2

    Great explanation. I had a lot of trouble understand normalization. I watched all the videos and the real life examples helped me grasp the concepts. Thank you!!!

  • @pradyumnasinha3963
    @pradyumnasinha3963 4 роки тому +1

    Thank you so much Mam. I would like to thank God so much for sending such nice teacher's like you, who explain the concept very nicely.

  • @prathameshpatil4160
    @prathameshpatil4160 5 років тому +2

    Mam you are fabulous, magnificent...
    Your teaching gets stuck in my head and you in my heart💓
    You are another crush of mine..
    Just keep smiling always..❣❣

  • @bobndalio286
    @bobndalio286 3 роки тому +1

    Thanks alot... very simple to follow up your lectures

  • @peppi44
    @peppi44 4 роки тому +12

    We love you Jenny. Greetings, 4CHIF.

  • @masoodhuraira5870
    @masoodhuraira5870 2 роки тому

    Madam definitely this is the best video to understand

  • @bhaveshsolanki8138
    @bhaveshsolanki8138 5 років тому +6

    Thanks for DBMS ma'am... My DBMS exam on dated 30/11/2019
    I can easily learn from your channel.
    You are combination of beauty and mind.
    Great and easy explanation.
    🔥 🔥 🔥
    Please ma'am make video on transaction control
    Before my exam
    🔥 🔥 🔥
    I have interest in DBMS and DS because of you 😂
    Keep it up!

  • @43harshgirishpatel43
    @43harshgirishpatel43 3 місяці тому

    best video!! it helped me a lot mam....thank-you......continue making videos like these!!

  • @vinaykumar9688
    @vinaykumar9688 2 роки тому +1

    This class is super easy to understand,maja agya padh ke 🤩

  • @nicholascutlip
    @nicholascutlip 2 роки тому

    Thank you!! Your explanation is so clear and considered.

  • @madhavdhungana
    @madhavdhungana 4 роки тому +1

    Thank you from Australia.

  • @mutyamparicherla5109
    @mutyamparicherla5109 4 роки тому

    Iam a big fan of your teaching

  • @sanas.193
    @sanas.193 3 роки тому

    Thank you so much Madam ♥️♥️♥️ You are the best..

  • @dinushachathuranga7657
    @dinushachathuranga7657 Рік тому

    Thanks a lot for the crystal clear explanation❤❤

  • @ramanroy4137
    @ramanroy4137 3 роки тому +2

    Thank you so much mam my all doubts clear 😍

  • @mutyamparicherla5109
    @mutyamparicherla5109 4 роки тому +1

    Your teaching so nice that's why Iam asking you

  • @shashithakavishwara2975
    @shashithakavishwara2975 2 роки тому

    Best lecturer i ever seen♥️

  • @NOOR-dy6yn
    @NOOR-dy6yn 4 місяці тому +1

    Best Teacher

  • @asfandyarahmad8286
    @asfandyarahmad8286 4 роки тому +2

    Thanks mam
    Allah ape ko buhat achi life day

  • @mahabubulalam639
    @mahabubulalam639 2 роки тому +16

    here is total 16 sk :
    A, AB, AC, AD, AE, ABC, ABD, ABE, ACD, ACE, ADE, ABCD, ABCE, ABDE, ACDE, ABCDE

  • @HARSHANTHRAJA
    @HARSHANTHRAJA Рік тому +1

    thank you ma'am!

  • @MANNGARG-tc9sq
    @MANNGARG-tc9sq 6 місяців тому

    Thankyou ma'am! Thankyou Thankyou Thankyou!🙏

  • @thembelanishemu8127
    @thembelanishemu8127 3 роки тому

    After 2hours of reading slides just to understand closure set of attributes (crystal clear) in 28mins. Thank you maam

  • @eagle_shadow6665
    @eagle_shadow6665 2 роки тому +1

    Your explanation 💫👌

  • @saptarshicse0735
    @saptarshicse0735 8 місяців тому

    Thank you so much💗💗💗💗💗💗💗💗💗💗💗

  • @atharvanarale6261
    @atharvanarale6261 3 роки тому

    Thank you mam firstly i have a huge doubt about how to identify the super keys and now by watching your videos my concepts are getting clear day by day

  • @alejandronieto576
    @alejandronieto576 3 місяці тому

    Thanks from Argentina Jenny

  • @AM-xu6sd
    @AM-xu6sd Рік тому

    ❤ Super se bhi upar candidate key

  • @michaelgala9835
    @michaelgala9835 2 роки тому

    I really enjoyed your lecture. You are such a great lecturer. Keep it up

  • @sanmathiraj8938
    @sanmathiraj8938 3 роки тому +7

    Hi Mam,
    I have a Doubt,
    In the video you said 16 keys possible for 4 attributes,
    In a relation having 4 attributes,the number of keys possible is 15[(2^4)-1],
    Right?
    Please clear my doubt,the lecture was Awesome BTW.

    • @schopengaard9796
      @schopengaard9796 3 роки тому

      No, I don't believe so. Considering that XcY means "X choose Y", you want to calculate
      4c0 + 4c1 + 4c2 + 4c3 + 4c4 = 16,
      where 4c0 represents the candidate key with only A as the attribute (and by definition also the primary key because we don't have any other candidates to choose from).

    • @nithinreddy94
      @nithinreddy94 2 роки тому

      Ok

    • @twinkler2854
      @twinkler2854 2 роки тому

      @@schopengaard9796 my doubt is why are we choosing from X i.e. 4? Since none of BCDE is super key and only A is super key. So A, AB,ABC, ABCD, ABCDE etc are super keys. Please explain why we are considering BCDE as X in X choose Y.

    • @jeanrioux8750
      @jeanrioux8750 2 роки тому +3

      @@twinkler2854 If A is a superkey, any combination of A with the other attributes will also be a superkey. Each attribute (B, C, D or E) can be part of the combination or not (2 possibilities). So, you have 2 power 4 = 16 possibilities total, that includes the case of none of B, C, D or E are included in the combination. The possible combinations are A, AB, AC, AD, AE, ABC, ABD, ABE, ACD, ACE, ADE, ABCD, ABCE, ABDE, ACDE, ABCDE.

    • @kartiksaini5847
      @kartiksaini5847 2 роки тому

      @@jeanrioux8750 correct👏

  • @frozanahmadi7894
    @frozanahmadi7894 4 роки тому +1

    Woow, Your lectures really helpful.

  • @зипермкск
    @зипермкск 4 роки тому +1

    thank you so much for these videos!!

  • @frKahEmeka
    @frKahEmeka 3 роки тому

    this has been very helpful. subscribed

  • @Sam0fficial
    @Sam0fficial 2 роки тому

    Thank you so much 🥰❤️

  • @Julia-xl7pr
    @Julia-xl7pr Рік тому

    amazing explanation.. better than my lecture videos..

  • @ManiKandan-lx9zg
    @ManiKandan-lx9zg 3 роки тому

    What a teaching❤️No one will replace u👌

  • @nikhilbhardwaj9000
    @nikhilbhardwaj9000 2 роки тому

    Awesome and easy explanation

  • @saptarshichattopadhyay8234
    @saptarshichattopadhyay8234 7 місяців тому

    Thanks ❤❤❤❤❤

  • @hk97gaming94
    @hk97gaming94 5 років тому +1

    First comment
    Realy you are working so hard

  • @iasaspirant1441
    @iasaspirant1441 3 роки тому +2

    19:32 "definitely not" MSD ❤️

  • @shivalikagupta3433
    @shivalikagupta3433 4 роки тому

    You are awesome. You teach wow.

  • @secretofallthings6962
    @secretofallthings6962 4 роки тому +1

    thank you ma'am 😀

  • @isaicsefxec6721
    @isaicsefxec6721 4 роки тому

    Trick was awesome 👌

  • @anjandey6089
    @anjandey6089 4 роки тому +18

    if my clg professor teach like you, i will be the topper of the batch

    • @delta_mohit
      @delta_mohit Рік тому +4

      If you listen your professor seriously like your class topper then you will definitely become class topper one day...

  • @aishwaryaverma7129
    @aishwaryaverma7129 4 роки тому +3

    Ma'am please make videos on theory of computation also...It will be really helpful :)

  • @RitikKumar-km5io
    @RitikKumar-km5io Рік тому

    Thank You Mam❤!

  • @zakeel-mc2zl
    @zakeel-mc2zl 3 роки тому +1

    Awesome lecture.. maam cna you me an other video for what is entity and attributes. how to find entity for given problem

  • @jatinyaduvansi4327
    @jatinyaduvansi4327 5 років тому +2

    I wish i could have you on our DATE 😎😍😍😍 QUEEN OF DS

  • @johnbelvin3891
    @johnbelvin3891 Рік тому

    Thank you so much ma'am, this is very helpful! I have a quick question - in your trick to find the attribute closure for a given set, do we only have to go over the given functional dependancies, or also have to check the derived FD using axioms? Thank you!

  • @SaurabhSingh-fc8vv
    @SaurabhSingh-fc8vv 4 роки тому

    Amazing your lecture

  • @parthverma5855
    @parthverma5855 4 роки тому +2

    Thank you so much for such a nice lecture. Can you please make a lecture on stable matching problem.

  • @maulikkikani4566
    @maulikkikani4566 3 роки тому

    You're awesome 😊

  • @sadboy-xx6gh
    @sadboy-xx6gh 9 місяців тому +20

    this video could have been less than 10 mins

    • @dmnsterdevil4682
      @dmnsterdevil4682 2 місяці тому +2

      @@sadboy-xx6gh there is a 2 min video out there explaining this topic in most simple way

  • @mayankraj9618
    @mayankraj9618 5 років тому +4

    Your beauty distracts me😆😆🤘 FOCUS🤦‍♂️

  • @rumiNITPatna
    @rumiNITPatna 2 місяці тому

    thank u mam!

  • @oshadhaedirisinghe1455
    @oshadhaedirisinghe1455 Рік тому

    Thank you

  • @continnum_radhe-radhe
    @continnum_radhe-radhe Рік тому +1

    ❤❤❤

  • @Mandeepsingh-jo5cf
    @Mandeepsingh-jo5cf 3 роки тому

    Thank you mam!

  • @anonymousfan9703
    @anonymousfan9703 2 роки тому +1

    I love u 🥰🥰🥰🥰🥰😊😊😊😊😊

  • @nayanjadhav4672
    @nayanjadhav4672 4 роки тому

    Nice explanation

  • @samlinus836
    @samlinus836 5 місяців тому

    @JennyslecturesCSIT Actually the total possible keys are (2^4) - 1 right?

  • @reviewwithabhi794
    @reviewwithabhi794 5 років тому

    Nice video mam...

  • @asitkumarpanda3835
    @asitkumarpanda3835 5 років тому

    Mam you are super ...

  • @manjushphalgun8367
    @manjushphalgun8367 9 місяців тому

    At 19:24 you mentioned that A can be a candidate key. But, how can A be a candidate key since AD is a proper subset of A and AD is a super key?.

  • @mlaxmi8643
    @mlaxmi8643 2 роки тому

    your video are amazing mam but can you give us some question on particular topic by that we can conclude our knowledge

  • @sandeepvineelaresort4636
    @sandeepvineelaresort4636 5 років тому +1

    Ur disturbing me more uff but ur smiles like an angel 🥰👌❤

  • @surajkushwah3221
    @surajkushwah3221 5 років тому

    sab samajh ara hai bohot badiya ..but plz thora jaldi video daal dijiye exam hai 15-20 din mai .. daa to ho gayi meri .. DBMS aur karwa dijiye please ... bacha lo madam.

  • @sandeshrchaudhari6548
    @sandeshrchaudhari6548 5 років тому +1

    mam please make video on...Highest Response Ratio next in operating system concept...plz make Fast...I have exam on this Friday...plz mam🙌🙌

  • @stackritesh
    @stackritesh 2 роки тому +3

    I HAVE A DOUBT !!!!!!
    I tried to find the 16 superkeys which are according to the 2ⁿ-1 formula. but i got only 14 s.ks by combining each attribute to A, AD ( as they are the only closure sets which contain all set of attribute of the given relation) which are A,AB,AC,AD,AE,ABC,ABD,ABE,ACD,ACE,ADE,ABCD,ABCE,ABCDE. Help me which 2 i left ? i couldn't find 16 keys.
    🤔🤔🙄🙄

    • @b1zarre23
      @b1zarre23 2 роки тому +2

      Same: {A, AB, AC, AD, AE, ABC, ABD, ABE, ACD, ACE, ADE, ABCD, ABCE, ABDE, ABCDE } but I find 15 SK which concurs with her formula for finding SK ( 2ⁿ-1 )

    • @Yalla_Balaji
      @Yalla_Balaji 2 роки тому +3

      @@b1zarre23 ACDE

    • @Yalla_Balaji
      @Yalla_Balaji 2 роки тому +2

      All 16 found

    • @omaewa69
      @omaewa69 2 роки тому +1

      @@Yalla_Balaji thanks

    • @ashutoshmishra5884
      @ashutoshmishra5884 2 роки тому

      A, AB, AC, AD, AE, ABC, ABD, ABE, ACD, ACE, ADE, ABCD, ABCE, ABDE, ACDE, ABCDE

  • @aqibanwar3195
    @aqibanwar3195 4 роки тому +2

    Maam, max no of super keys - 2^4 -1 ,so 15, right?

    • @259_parthpatidar9
      @259_parthpatidar9 4 роки тому +1

      Maximum Super keys = 2^n - 1. If each attribute of relation is candidate key. mind this 2nd line you forgot this. so if you are taking n=4, that means you know that 4 attributes are candidate keys ,but in mam's que. that is not the situation. i hope u got it.

    • @PiyushSharma-bo6pp
      @PiyushSharma-bo6pp 3 роки тому

      @@259_parthpatidar9 but since we are combining it with A and A is super key so all the combinations will be super key , and total number of combinations : 4c1(AB)+4c2(ABC)+4c3(ABCD)+4c4(ABCDE) = 15

  • @shijal2526
    @shijal2526 5 років тому

    Thanks mdm❤️

  • @rudrikakalsotra9707
    @rudrikakalsotra9707 4 роки тому

    well explained

  • @sauravsingh4588
    @sauravsingh4588 4 роки тому +1

    Mam please please please make complete video tut for this DBMS subject