Functional Dependency | How to find Canonical Cover| DBMS MCQs | NET|GATE|PGT|ISRO

Sdílet
Vložit
  • čas přidán 5. 08. 2020
  • #ComputerShashtra
    This video covers previous year MCQs from NET,GATE and other competitive exams in computer science on Functional Dependency in DBMS and finding canonical cover in very easy steps. Very important for those who are preparing for NET,JRF,GATE,ISRO ,PGT in computer science.
    Please subscribe our channel #ComputerShashtra to watch more videos .

Komentáře • 18

  • @pawandiwan3464
    @pawandiwan3464 Před 4 lety

    🙏

  • @ImranHussain-xe6qx
    @ImranHussain-xe6qx Před 3 lety +2

    Great work no here and there, to the point... very Helpfull... please make more videos over Automata /compiler /network please....

    • @computershastra
      @computershastra  Před 3 lety

      Thank you :) We will soon upload videos on computer network.

  • @kamalpreet678
    @kamalpreet678 Před 3 lety

    very helpful .....mam CN mcq ki series start kro na plz

  • @manugupta4262
    @manugupta4262 Před 4 lety

    Mam in ques u hv taken from gate 2014 containing statements S1 and S2 ...in S2 AB--C is essential FD in cover as it is not determing all the attributes of relation ....but u hv said it will be not be included in cover

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

      Hey Manu, in S2, AB -> C is not an essential FD as we can infer it from AB -> E and E -> C (Transitivity rule). That is why, we will not include it in our cover. Sometimes we may not be able to decide which one is essential. There you can use method described in previous question to find canonical cover (by taking two closures of AB with and without including FD AB->C).

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

      And regarding video quality, we have checked and found that it may take few hours to get 144p resolution. so whenever you find higher quality, just wait for few hours as youtube may take some time to get all resolutions.

  • @prashantkumarpandey2141

    Is it helpful for IBPS so it