Lec 5: Armstrong's axioms in DBMS | Inference rules of Functional Dependency

Sdílet
Vložit
  • čas přidán 25. 11. 2019
  • In this lecture, We will learn:
    Types of Functional Dependencies
    Armstrong's Axioms of Functional Dependency with Example.
    Best DBMS Tutorials : • DBMS (Database Managem...
    *******************************************
    Connect & Contact Me:
    My Second Channel Link: bit.ly/354n7C7
    Facebook: / jennys-lectures-csit-n...
    Quora: www.quora.com/profile/Jayanti...
    Instagram: / jayantikhatrilamba
    Twitter: / khatrijenny
    *********************************************
    More Playlists:
    C Programming Tutorials: • Programming in C
    C++ Programming Tutorials: • Lec 1: How to Install ...
    Placement Series: • Placements Series
    Data Structures and Algorithms: https: • Data Structures and Al...
    Design and Analysis of Algorithms(DAA): • Design and Analysis of...
    Python Full Course: • Python - Basic to Advance
    Printing Pattern in C: • Printing Pattern Progr...
    Dynamic Programming: • Dynamic Programming
    Operating Systems: // • Operating Systems
    #dbms #dbmstutorials #normalization #jennyslectures #losslessjoin
    #armstrongaxiomsindbms
    #DBMS
    #ugcnetcomputerscience
    #jennylectures

Komentáře • 210

  • @abhimanyusoni491
    @abhimanyusoni491 Před rokem +69

    The best lecturer of computer science at CZcams. Even Better than gate smashers and abdul bari also

    • @vasusukhija5015
      @vasusukhija5015 Před rokem +22

      come on bro we cant act like legends cannot co-exist all these guys are best

    • @SteveBClark
      @SteveBClark Před rokem +4

      That's why some people watch their videos instead of her, because they know their teaching ability. I don't hate anyone

    • @Kim_jong_un69
      @Kim_jong_un69 Před 9 měsíci

      Your mentality is terrible 🤣

    • @divyanshpandey8355
      @divyanshpandey8355 Před 8 měsíci

      bro just go and cry in corner. Simp.

    • @csengineer8819
      @csengineer8819 Před 6 měsíci +1

      @@Kim_jong_un69 😁

  • @eliphasmasuka5730
    @eliphasmasuka5730 Před 4 lety +23

    I have watched more than 3 lectures, at once all because you are so clear ma'm wonderful efort

  • @nikithasaurabh4019
    @nikithasaurabh4019 Před 3 lety +7

    Simplified yet very effective explanation of the concepts. This is the best explanation of FD and normalisation I have come across so far. Keep up the good work Mam. We need teachers like you to help the student community!

  • @goldiea6481
    @goldiea6481 Před rokem +11

    Thank you so much for the straightforward explanation! Your videos have carried me through my Algorithms class, and now DBMS! You have a true gift for teaching 😊

  • @ashankavindu2409
    @ashankavindu2409 Před 3 lety +39

    I'm a University student madam but...I learn from you more than the university.....thank you so much 💓 God bless you....keep doing this for student like us...

  • @alishallawadhi780
    @alishallawadhi780 Před 3 lety +4

    Thank you so much ma'am for being there. I have watched so many lectures your clarification is very clear. I have passed my last semester exams because of you. You are just like a god to me.

  • @micah167
    @micah167 Před 4 lety +5

    i love how you put effort in your tutorials! thank you very much !!!

  • @tushargupta2009
    @tushargupta2009 Před 4 lety +1

    Your teaching really shows your hardwork and the quality you have to teach a topic. Thank you mam for the lectures.

  • @jacobs1219
    @jacobs1219 Před rokem +13

    When i joined engineering you have 750+k subscribers....now you hit 1.1M. Giving us free tutorial where as we give 85000+ in colleges for the same . The difference is we understand your lectures

  • @pacochamorro-fierro122
    @pacochamorro-fierro122 Před 4 lety +14

    Hi, Jenny. I just wanted to thank you for this amazing explanation. I was just interested in Armstrong'a axioms but definitely I am staying around to learn more from you.

  • @arielguerrero5803
    @arielguerrero5803 Před 3 lety +11

    Thank you, my Database professor doesnt even compare to the quality of lecture you posted. Truly a course saver!

  • @abhishekpathak2409
    @abhishekpathak2409 Před 4 lety +2

    Very nice mam i have seen so many of videos online but the way u taught us incredible thanks for helping us

  • @amanprajapati3417
    @amanprajapati3417 Před 2 lety +1

    don't understand why people are not liking this video😐😐😐😐😐😐😐😐 she explains flawlessly❤❤

  • @debashrutibhattacharjee5023

    Seamlessly explained. Thank you so much!!

  • @WeirdDictionarylearning
    @WeirdDictionarylearning Před 3 lety +5

    Very well explained Jenny . I have watched this video after 1NF 2 NF explanation.
    I have had watch before then it could be easier to understand normalisation technique.

  • @elyasaf755
    @elyasaf755 Před 4 lety +1

    Very clear. Thank you so much for this course!

  • @ajaykrishna0079
    @ajaykrishna0079 Před 2 lety +2

    You are the one who saving so many furures👏👏🙌🙌 .. Keep working mam 😍

  • @pavithrapavi6213
    @pavithrapavi6213 Před 4 lety +14

    Yesterday class my mam teach this with same example.i think my mam copy from you thanks to make understand the topic

  • @anilmiral
    @anilmiral Před 3 lety +2

    Thank you so much mam for such a great explanination ...........and the way of teaching is awessom,,,,

  • @_sarthakmisal
    @_sarthakmisal Před 2 lety +2

    Mam I like your lectures the most you teach really great
    I wish you will be one of the top educators on CZcams very very soon Love you Mam❣️

  • @bhushankumarkhade2985
    @bhushankumarkhade2985 Před rokem +4

    Nice explanation mam.... The example of Ram, Sham and Mohan in awesome...💯

  • @kayyan7912
    @kayyan7912 Před 3 lety +2

    Thanks so much Jenny. Great tutorials!! Love from Australia

  • @evanskiprotichkorir9902
    @evanskiprotichkorir9902 Před 3 lety +1

    I really Love you lecturers they're very much clearer thanks very much

  • @chandnijaiswal9751
    @chandnijaiswal9751 Před 3 lety +2

    Ma'am I just want to say you is "Jab aap samjhati ho to Makhan jaisa samaj mai aata hai". Thank you soo much maam ❤️❤️ . Your videos are helping me alot❤️ and my interest in cs is growing 🔥it all bcoz of you😌

  • @lukamugosa911
    @lukamugosa911 Před 4 lety +2

    You re a great teacher! Keep it up👍

  • @mosesmbira5808
    @mosesmbira5808 Před 3 lety +1

    Your lectures are well explained and simplified.

  • @Khedhar108
    @Khedhar108 Před 2 měsíci

    Great Teacher - love the way you taught in simple way

  • @dinushachathuranga7657
    @dinushachathuranga7657 Před 9 měsíci

    Your teaching potential is amazing . Bunch of thanks ma'm❤❤

  • @prathapg8065
    @prathapg8065 Před 2 lety +2

    Thank you mam, your videos are really understandable and useful for my placements👍🏼

  • @varshasharma7072
    @varshasharma7072 Před 4 lety +2

    Mam you are really awesome with concept explaining 👌

  • @Momo-qr3rd
    @Momo-qr3rd Před 2 lety

    you are an agel, you are a genie 😌thank you very much for your efforts 🙏 I am proud of such smart women like you, my wish is to become like you. keep it up 💪

  • @bhavyasingh7595
    @bhavyasingh7595 Před 3 lety +1

    At first I was not so sure.
    But maam you're an awesome teacher.

  • @suthararvindjlr
    @suthararvindjlr Před rokem

    love the way of your teaching ,Better than our university faculty.❤❤❤❤

  • @srikanthsrinivasan3843
    @srikanthsrinivasan3843 Před 4 lety +13

    Your lecture was very easy to understand. #between# my mother would look like you in your age. And of course you would look like my mother after years.😁(don't worry my mother is super pretty 😂😅)

  • @moizmusic9242
    @moizmusic9242 Před 4 lety +1

    Awesome explantation......ur lectures helps me alot mam. Luv frm Pakistan ❤️

  • @skittles234567
    @skittles234567 Před 3 lety +1

    thank you for being a lifesaver! you're so clear in your explanations and I'm so grateful!!

  • @HarshYadav-cj3yu
    @HarshYadav-cj3yu Před 4 lety +5

    please make a video on career options using computer skills. Lots of us come from unpleasant environment to study, please help shaping our mind.

  • @TheFailGuy01
    @TheFailGuy01 Před 3 lety +1

    Thank you so much mam .you made me understand for tomorrows exam.thank you so much once again 🙏🙏

  • @vivek-rathod
    @vivek-rathod Před 3 lety +1

    Thank you mam for amazing explanation
    You are awesome teacher
    Please make full series of DBMS

  • @subhankarsingharoy9822
    @subhankarsingharoy9822 Před 3 lety +1

    Hii maam ur explanation r wonderful...it makes the subject very clear to me....maam i have a request please make videos on COA

  • @sarojneupane7008
    @sarojneupane7008 Před měsícem

    Thanks !! best lecture

  • @Amitakd2023
    @Amitakd2023 Před 2 lety

    thank you jenny mam for excellent explanations..👍👍❤❤👌👌👌

  • @vishaknayanajith9051
    @vishaknayanajith9051 Před rokem

    Best tutor in my uni life ❤

  • @blessingajayi9457
    @blessingajayi9457 Před rokem +1

    You’re a great teacher ❤

  • @AdiCode_Hub
    @AdiCode_Hub Před 2 dny

    thanks for the amazing lecture.

  • @madhuraamarajeewa78
    @madhuraamarajeewa78 Před 3 lety +2

    Your lectures are very clear, teaching methodology(s) are also very good, I ll recommend for my students

    • @jirehag5140
      @jirehag5140 Před 2 lety

      No, don't! Endeavor to help your students to understand just as she is helping us here. That's why your students are paying fees. She doesn't take fee from us. Do your job the best way as you are paid for. Good luck to you...

    • @sriramkrishnamurthy4473
      @sriramkrishnamurthy4473 Před 2 lety

      @@jirehag5140 kya baat kahi hai bhai sahab !! Wah Bhai Wah janabe ALi !

  • @mkhits1260
    @mkhits1260 Před 3 lety +1

    Thank you so much for excellent explanation

  • @gowntobuild
    @gowntobuild Před 2 lety

    Such a beautiful educating queen♥️

  • @preetianeja6232
    @preetianeja6232 Před rokem

    You are a great teacher

  • @hayetchekired462
    @hayetchekired462 Před rokem

    Thanks !! awesome explanation!

  • @JayPatel-ou2ud
    @JayPatel-ou2ud Před rokem

    GREAT explanation 🙏🏻

  • @278xyzsonal
    @278xyzsonal Před 3 lety

    You are the best ma'am 👍👍

  • @barkatulislam4639
    @barkatulislam4639 Před 4 lety +12

    Ma'am being ur student on CZcams , I think there is no need to attend the class in college. # THANKSMAAM.

  • @jennikakahui
    @jennikakahui Před měsícem

    Thank you Jenny :D

  • @gaudok3281
    @gaudok3281 Před rokem

    good video, I learnt a lot about c++

  • @narendrapalsingh5891
    @narendrapalsingh5891 Před 9 měsíci

    Infinite thanks

  • @anuragsharma5736
    @anuragsharma5736 Před 3 lety

    Very well explained mam.... Thanku you so much mam we all love you

  • @kumarayush9499
    @kumarayush9499 Před rokem

    Thank you maam very good lecture on the axioms.

  • @ahmadhussain8760
    @ahmadhussain8760 Před 9 měsíci

    TYSM

  • @priyanshramnani1751
    @priyanshramnani1751 Před 3 lety

    Thank You!

  • @FezziTalib
    @FezziTalib Před 3 lety

    the 2way of explaining is quite humble

  • @nithishkumarb9622
    @nithishkumarb9622 Před rokem

    Thank so much your lecture mam is very useful for me🙂🙂🙂🙂

  • @anandms7537
    @anandms7537 Před 3 lety +1

    Your lecture is very nice, I got just 5 marks out of 75 in dbms in sem ,
    Now I think I can score above 70 marks on dbms in ATKT exams
    Thank you mam😘

  • @jamshedraza3928
    @jamshedraza3928 Před 7 měsíci

    I like ur lectures

  • @silverkobo
    @silverkobo Před 4 lety +12

    Thank you! This is the best explanation out there! Greetings from Israel :-)

  • @RitikKumar-km5io
    @RitikKumar-km5io Před 6 měsíci

    Thank You Mam❤!

  • @1nt3rnetz
    @1nt3rnetz Před 2 lety

    Hello, in a real world context, should we only be able to say that we have a functional dependency when the fd is valid from time n to infinity? - Thank you for your videos, they have helped me so much.

  • @thekiwisqu33z34
    @thekiwisqu33z34 Před 9 měsíci

    Amazing!!!

  • @abhishekroushan3307
    @abhishekroushan3307 Před 4 lety +1

    I'm an electrical engineering student. I have watched all your computer science videos. Nothing understand but enjoyed you !! Love you 💗

  • @subasrisr2074
    @subasrisr2074 Před rokem

    Really helpful💯💯💯....

  • @Mandeepsingh-jo5cf
    @Mandeepsingh-jo5cf Před 3 lety

    Thank you very much mam!

  • @basavadinesh6240
    @basavadinesh6240 Před rokem

    Thank you very much mam

  • @BroncoC206
    @BroncoC206 Před 2 lety +1

    Love your stuff, saved my homework.

  • @eagle_shadow6665
    @eagle_shadow6665 Před 2 lety

    Thanks a lot mam 💫

  • @sanas.193
    @sanas.193 Před 2 lety

    Thank you very much Madam ♥️♥️♥️

  • @HsTag77
    @HsTag77 Před 4 lety +1

    Nice explanation mam

  • @user-kb9sn5dk7s
    @user-kb9sn5dk7s Před 4 měsíci

    thanks mam insem exam cleared because of you

  • @tpedimotika3273
    @tpedimotika3273 Před rokem +1

    Ευχαριστούμε!

  • @AmanSingh082
    @AmanSingh082 Před rokem +2

    Mam, In Argumentation I think if x determine y and this is not valid then always xa determine ya is not valid.if i'm wrong then please give me an example for this problem.

  • @theflyingfamily2521
    @theflyingfamily2521 Před 2 lety

    thank you so much mam !!!

  • @eclass7145
    @eclass7145 Před 4 lety +3

    Good Teaching method maam. I request maam Python tutorial maam ..

  • @shivam.tejyan8683
    @shivam.tejyan8683 Před 4 lety

    thank u miss

  • @aarthyvenkat7868
    @aarthyvenkat7868 Před 3 lety

    Mam...please post theory of computation videos...please mam....ur teaching s awesome...

  • @Jagriti_Shukla
    @Jagriti_Shukla Před 2 měsíci

    MY PROFESSOR WATCH YOUR VIDEOS AND TEACH EXACTLY SAME IN THE CLASSROOM LECTURE
    😅😅😄😄

  • @aamishanwer8084
    @aamishanwer8084 Před 4 lety +1

    wow before watching I fall in love with you 're video

  • @gopalbhagat9528
    @gopalbhagat9528 Před 4 lety +2

    Mam please make a video on query language
    And Topic like DAC MAC RBAC AND SQL INJECTION AND INTRUSION DETECTION ETC

  • @anishjoshi1999
    @anishjoshi1999 Před 3 lety

    love from nepal

  • @rushikeshjadhav1414
    @rushikeshjadhav1414 Před 4 lety +5

    Studied DBMS and ready for Exam !
    Now just here to for the ...
    "To say something in a geeky way !"
    mysql> create database myheart;
    Query OK, 1 row affected (0.00 sec)
    mysql> use myheart;
    Database changed
    mysql> CREATE TABLE Jenny (Myfeeling varchar(255));
    Query OK, 0 rows affected (0.02 sec)
    mysql> insert into Jenny values ("I love You");
    Query OK, 1 row affected (0.03 sec)
    mysql> select * from Jenny ;
    +------------+
    | Myfeeling |
    +------------+
    | I love You |
    +------------+
    1 row in set (0.00 sec)

  • @surajkushwah3221
    @surajkushwah3221 Před 4 lety

    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.

  • @dhakshinamurthy51
    @dhakshinamurthy51 Před 4 lety

    Tq

  • @saivikasjaladi1663
    @saivikasjaladi1663 Před 4 lety

    mam In transitivity rule if x -> y is functional dependency and y -> z not functional dependency then x->z is functional dependency in this case it is transitivity rule or not

  • @user-ow1ls9jk4l
    @user-ow1ls9jk4l Před 9 měsíci

    composition example:
    R.no (X )----> marks ( Y)
    Name (A)--------> dept(B)
    then
    R.no, Name (XA) ---------> Marks, dept (YB)

  • @shivcharanbattabyal2951

    You & your teaching is very sweet and cute mam❤️

  • @yashmishra9603
    @yashmishra9603 Před 4 lety +1

    First video with open hairs 😍😍 looking so beautiful madam

  • @md.ashikulalam9903
    @md.ashikulalam9903 Před 3 lety

    Love how she says false!

  • @neelampirwani4866
    @neelampirwani4866 Před 2 lety

    Is fully non-trivial functional dependency and fully functional dependency (Used to achieve 2nd normal form) same thing?
    likewise semi non-trivial and partial functional dependency same?

  • @devirajagopal6456
    @devirajagopal6456 Před 4 lety

    Is data structures series tutorial is completed mam?

  • @AbhishekSingh-fc2rx
    @AbhishekSingh-fc2rx Před 4 lety

    what if r.no determines the names, course, dept what kind of FD is this ?? x is not a subset their intersection is also not null

  • @abdallaosama86
    @abdallaosama86 Před měsícem

    جامد يافنانه

  • @abdallaosama86
    @abdallaosama86 Před měsícem

    اللي هتنجحنا❤❤