3.4 Armstrong's Axioms and Inference Rules in Functional Dependency

  Рет қаралды 377,375

KnowledgeGATE by Sanchit Sir

KnowledgeGATE by Sanchit Sir

Күн бұрын

Пікірлер: 131
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
For complete DBMS, check out this video: kzbin.info/www/bejne/j4PRm3qbhsemfrM
@skittles6486
@skittles6486 6 жыл бұрын
Best ever lecture series on DBMS. Learn complete DBMS by watching just several hours of these video lectures. I really don't know how to thank you for your effort. infinite thanks to you sir,
@minecraftcookie2929
@minecraftcookie2929 Жыл бұрын
Sir, that is one of the best teaching i've ever recieved ! Every concept is as clear as a crystal ! Thank you soo much
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
Glad to know dear, thank you for the feedback❤ Keep learning & stay connected for more amazing videos & upcoming contents! You can also check out our complete course on all computer science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
@ritikeshsharma9953
@ritikeshsharma9953 5 жыл бұрын
Why are we lacking teachers like you in our college.....
@kmanish2528
@kmanish2528 Жыл бұрын
Best playlist on KZbin🔥🔥❤❤
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
Thanks a lot dear ❤Keep following & stay connected for more amazing contents👍😊 You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
@souravkumarcode
@souravkumarcode 6 жыл бұрын
1:25 if you have exams tomorrow
@chinmays2571
@chinmays2571 5 жыл бұрын
Me : 2:0
@yashgandhi9698
@yashgandhi9698 4 жыл бұрын
@@chinmays2571 me at 3x using an extension..
@yashsakalley8121
@yashsakalley8121 4 жыл бұрын
@@yashgandhi9698 Can you tell the name of that extension?
@ardhyakumar2539
@ardhyakumar2539 4 жыл бұрын
@@yashsakalley8121 KZbin playback speed controller
@SDE_M.sameem
@SDE_M.sameem Жыл бұрын
wonderful series of DBMS.❤
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
Thanks a lot dear❤ Keep supporting & stay connected for more amazing contents👍😊 You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
@RohIt_bhopali
@RohIt_bhopali 6 жыл бұрын
need Conversion of ER to relational model, B & B+ trees concepts too. Thank you! Hope you are enjoying the tour as shared on your channel :) Pranaam
@selfhelpguy5589
@selfhelpguy5589 5 жыл бұрын
Massive respect for you, sir! You are shaping the future of this country. Also, I'm grateful for KZbin as it is enabling amazing people like you to help others through monetizing your videos and showing us ads, which enables everyone to access this amazing content for free. Thank you so much for your work, Sanchit Sir! Eager to learn more and more subjects from wonderful teachers like you!
@rohanm2793
@rohanm2793 5 жыл бұрын
I have not much words to admire for you, you are brilliant
@ParthVikani
@ParthVikani 6 жыл бұрын
Hi Sir, Can you please put videos in order for DATABASE series? it's confusing for all and not able to find which next video I should have to check... Like Part -1 | Functional Dependency in DBMS in HINDI | DATE BASE MANAGEMENT SYSTEM Part - 2 | Functional Dependency Practice Problems with solutions in HINDI example exercise solution Part -2.5 | Practice Problems on Functional Dependency in DBMS with example in HINDI | example Part - 2.7 | Armstrong's Axioms in DBMS in HINDI | Armstrong rules database | Closure of Attributes Part - 3 | Closure Set of Attributes in DBMS in HINDI | How to find Closure Of Attributes algorithm 2.5 & 2.7 where is 2.6? Thanks.
@RamanSingh-lq2xb
@RamanSingh-lq2xb 4 жыл бұрын
This guy deserves my tuition.
@nikhilsoni470
@nikhilsoni470 3 жыл бұрын
composition & pseudo transitivity mujhe kahne samjh nahe aye the way you explain thank you so much.
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 3 жыл бұрын
Thanks Nikhil.. keep learning and supporting !
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg 🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg
@shashanksaxena6189
@shashanksaxena6189 6 жыл бұрын
thank you sir for teachng in very easy manner.I always score good marks because of you
@kartiksaini135
@kartiksaini135 5 жыл бұрын
Sir I respect u & ur style of explaining...but COMPOSITION can also be proved more easily by the AUGMENTATION AXIOM by adding Z to 1st statement & Y to 2nd statement!!!
@tilakdharisingh969
@tilakdharisingh969 2 жыл бұрын
Nice explation sir 👍 👌 👏 😀 🙌
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
Thanks a lot dear! Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊
@vivekmittal1454
@vivekmittal1454 4 жыл бұрын
A very easy and intuitive explanation!
@aradhanasaxena8561
@aradhanasaxena8561 6 жыл бұрын
U r really very awsam.... I didn't attend the lecture in colleges but I attend ur all lectures really very helpful
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 6 жыл бұрын
Thank you so much Aradhana for your kind words.. Knowledge should be welcomed from which ever source who feel is fine with you.. Keep learning and following all the series.. Provide your feedback too.
@kartickchandramanna267
@kartickchandramanna267 2 жыл бұрын
Good lecture 👍 Thank you sir 🙏
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
Most welcome dear 😍Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊
@syedmohdgulambaquer3577
@syedmohdgulambaquer3577 6 жыл бұрын
Sir please upload the videos on time stamp protocol
@shree2710
@shree2710 6 жыл бұрын
S.m.g. baquer exactly and locking too!
@kanchanlatakulshrestha472
@kanchanlatakulshrestha472 Жыл бұрын
Thank you so much for such a great explanation sir....😊
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
Most welcome dear @kanchan❤ Do like, subscribe & share the video, you can also visit our website www.knowledgegate.in for more amazing videos & contents👍😊
@rudrakshrajvyas6656
@rudrakshrajvyas6656 2 жыл бұрын
Amazing
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
Thank you! Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊
@kaisemuhmmad3909
@kaisemuhmmad3909 5 жыл бұрын
wao.kmaal k sr app smjatay h.amazong.your lecture is so much nice as you are good looking from pakistan
@shubhaagarwal8041
@shubhaagarwal8041 3 жыл бұрын
awesome learning
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 3 жыл бұрын
Thank you Shubha.. Keep learning and supporting. For more courses and contents, you can visit our website www.knowledgegate.in.
@mdasadahmed2769
@mdasadahmed2769 6 жыл бұрын
Thank You Very Much sir sir please 1 video banalijiya "" Microkernal Architecture in OS "" par
@AnkitSingh-vp7mj
@AnkitSingh-vp7mj 5 жыл бұрын
Sir in composition we can also do augmentation by adding z in first and adding y in second. Hope I'm correct!!
@ayushiydvKG
@ayushiydvKG 7 ай бұрын
best faculty of DBMS on yt
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 7 ай бұрын
Glad you think so! Keep learning & following for more content😊
@epicclips8881
@epicclips8881 4 жыл бұрын
Awesome Explanation Sir ❤️❤️❤️❤️
@punnyabhatnagar6346
@punnyabhatnagar6346 4 жыл бұрын
Amazing explanation
@raheelfida899
@raheelfida899 5 жыл бұрын
Great Lectures Sir
@OmitA25
@OmitA25 6 жыл бұрын
great explanation........
@milanjain.2564
@milanjain.2564 6 жыл бұрын
Super teacher u r sir
@arjunkhanna1803
@arjunkhanna1803 4 жыл бұрын
14:26 sir please explain about decomposition with real life example
@blessythomas8778
@blessythomas8778 6 жыл бұрын
sir your class is awesome.. i want to say something that i don't know hindi so please add english subtitles it will be helpful for many sir.
@RohitSharma-cd5bs
@RohitSharma-cd5bs 4 жыл бұрын
Learn Hindi
@Alonkete
@Alonkete 10 ай бұрын
Saali tu apne desh ja america
@nelsonchacko2086
@nelsonchacko2086 6 жыл бұрын
Ty for this ..
@K21-e2h
@K21-e2h 4 жыл бұрын
You're the best sir
@ranjitkumar4
@ranjitkumar4 6 жыл бұрын
Sir thank you so much for your efforts...Just have one query ..does direct jump from part 4 to part 4.5 means some video are missing in between ? Or It's just a mistake in naming conventions within video series? Or any other reason?
@faizejafri1014
@faizejafri1014 6 жыл бұрын
Unbelievable... U r awsm..♥️
@rameshpatil9148
@rameshpatil9148 4 жыл бұрын
Thanks sir very helpful
@narendraparmar1631
@narendraparmar1631 6 жыл бұрын
Thanks sir ji😆
@simrank9437
@simrank9437 6 жыл бұрын
sir please make more vedios on PDA and NPDA...
@pritambala4471
@pritambala4471 2 жыл бұрын
R(ABCDEF), A---B, C--DF, AC--F, D--AF, E--CF. Anyone Please Explain Me This..............?
@roshanpandey5357
@roshanpandey5357 6 жыл бұрын
Hi Sir, I want to say something ... you are great, JUETians hit like
@lekshmymayagopakumar1428
@lekshmymayagopakumar1428 6 жыл бұрын
Sir can u plz upload the videos of query optimization explaining algorithms.
@yashkumardhawan6961
@yashkumardhawan6961 5 жыл бұрын
Dear sir, In the reflexivity condition, you said that 'y' is a subset of 'x' but according to the conditions 'y' is the proper set of 'x'. Kindly clarify.
@jitendrapatel1110
@jitendrapatel1110 6 жыл бұрын
thanks for your help sir
@mdmozammilraza3215
@mdmozammilraza3215 3 жыл бұрын
Nice Explation Sir
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 3 жыл бұрын
Thanks a lot..keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses and contents !!
@PreetiSingh-ko7dm
@PreetiSingh-ko7dm 6 жыл бұрын
plz...give n example of augmentation......
@shivanimalgotra2975
@shivanimalgotra2975 6 жыл бұрын
Sir plz cursor control in dbms in hindi and example or trigger bhi samjayoo
@satyam_krishna
@satyam_krishna 6 жыл бұрын
In union operation x->y and x->z But according to fd rules x cannot Have different values.can you please tell me why.
@rm764
@rm764 5 жыл бұрын
Have u found the answer.. If yes then tell me..I hv Same confusion
@preetmehta1008
@preetmehta1008 5 жыл бұрын
Fd rules basically says that if x->y holds true...then with help of x, unique y can be found..hence x->z means that with help of x, unique z can be found...therefore, x->yz basically means that with x, unique values of y and z can be found... there's no violation in fd rules
@Healthylifestyle924
@Healthylifestyle924 5 жыл бұрын
In transitive rule a to b and b to c then a to bc is hold not a to c sir because we get two different values on the same value of a?
@parvadave1379
@parvadave1379 5 жыл бұрын
Ty☺
@RoshanKumar-xu3nw
@RoshanKumar-xu3nw 3 жыл бұрын
Union --If x->y && x->z then x->yz How here in case of union x has two value before u said f(x) =y , x can't have two different value ?
@focus5533
@focus5533 2 жыл бұрын
same question. Sir please help!
@mosibkhan7903
@mosibkhan7903 6 жыл бұрын
Thanks😎
@sagesy9774
@sagesy9774 4 жыл бұрын
sir fees kidhar bheju ?
@AmandeepSingh-sx9ke
@AmandeepSingh-sx9ke 6 жыл бұрын
Thank you sir
@sarithaammu641
@sarithaammu641 6 жыл бұрын
Superb
@sourabhnayak2753
@sourabhnayak2753 5 жыл бұрын
sir please also upload SQL lectures
@junaidshaikh3597
@junaidshaikh3597 6 жыл бұрын
Really thank s
@sahrunakhan4522
@sahrunakhan4522 6 жыл бұрын
U r really awesome
@kmpriyanka1223
@kmpriyanka1223 6 жыл бұрын
Sir Thanks you so much
@simpalsingh5600
@simpalsingh5600 6 жыл бұрын
suprb...video
@fahimahmedshojib3701
@fahimahmedshojib3701 6 жыл бұрын
Best Video
@himanshusingh5118
@himanshusingh5118 3 жыл бұрын
3-Nov-2021 ⛳
@deepakmathew2161
@deepakmathew2161 5 жыл бұрын
In Armstrong-s Axioms Secondary Rule for union X->Y && X->Z THEN X->YZ OK ITS FINE.....BUT HOW IT POSSIBLE X->Y && X->Z BECAUSE ITS THE VIOLATION OF FUNCTIONAL DEPENDENCY.......
@komalprajapati3243
@komalprajapati3243 6 жыл бұрын
Sir please upload the video on the DAA.
@withtheflow7526
@withtheflow7526 5 жыл бұрын
kzbin.info/www/bejne/ZnqkgY2wfLiVg6c
@withtheflow7526
@withtheflow7526 5 жыл бұрын
Check here Very easy DAA lectures you get here..which must clear your Idea
@akshatanand5804
@akshatanand5804 4 жыл бұрын
Sanchit sir OP! in chat bois
@agranshuaggarwal1333
@agranshuaggarwal1333 6 жыл бұрын
Awesome
@epicclips8881
@epicclips8881 4 жыл бұрын
Fnatic Ftw ❤️ ❤️❤️❤️❤️❤️❤️❤️
@prof_as
@prof_as 6 жыл бұрын
sir if a->b and a->c is invalid statement than in composition rule why zx->zy and zx->wx is valid
@9.5mviews74
@9.5mviews74 5 жыл бұрын
Bhay w and y are in the same tupple...i mean two attributes...not two tuples
@pjjish
@pjjish 6 жыл бұрын
Are your 64 videos sufficient for gate 2019? Please reply
@deogharplaces5843
@deogharplaces5843 4 жыл бұрын
Don't able to capture screen shoot sir
@inderraj9263
@inderraj9263 3 жыл бұрын
Suppose in decomposition rule y have repeated values and z have also repeated values but there pair don't have repeated values then decomposition faileddddd ....
@AnjaliSingh-vt1yq
@AnjaliSingh-vt1yq 4 жыл бұрын
Sir can u provide notes. In pdf
@tusharchadha1120
@tusharchadha1120 5 жыл бұрын
Hey won't we have a C+ as a primary key cause all attributes are dependent on C
@nabinbist1220
@nabinbist1220 Жыл бұрын
relational model to nahi hey
@KhanEditLabs
@KhanEditLabs 10 ай бұрын
B for bangru pta ni kia prha rha najma kay husband ho?
@HamzaKhan-wy3ds
@HamzaKhan-wy3ds 10 ай бұрын
😂😂
@rupammedhi9943
@rupammedhi9943 6 жыл бұрын
Sir.. Are u an ex infosys employee?...
@avinashkr5980
@avinashkr5980 6 жыл бұрын
ZX ---> ZY ZY --->WY Then we can find ZX ---> WY
@parvadave1379
@parvadave1379 5 жыл бұрын
Yes
@bhaicodekaro
@bhaicodekaro 4 жыл бұрын
thanks m textless
@jaihindpratap3901
@jaihindpratap3901 4 жыл бұрын
why u are writing DE ->ADEF while we have to write like this DE->ADFE because D->AF.
@gateeasycse
@gateeasycse 6 жыл бұрын
sir please teach English language also
@shubhampatel5576
@shubhampatel5576 6 жыл бұрын
legend
@bikramchatterjee8296
@bikramchatterjee8296 5 жыл бұрын
Sir is functional dependency from "A" to "B", implies that we can find every value of B from A, and is it mandatory that every value of A cantains a corresponding value or result in B? please help me sir.
@vlogwithankit6546
@vlogwithankit6546 3 жыл бұрын
🤩🤗🤩🤗
@prabhu-h7755
@prabhu-h7755 6 жыл бұрын
2x
@amanali9501
@amanali9501 3 жыл бұрын
Hello
@navroze92
@navroze92 6 жыл бұрын
Play at 1.25x speed
@kausartalks
@kausartalks 5 жыл бұрын
Thora km bola karye sir g.. Short m Vide
@SHASHANKRUSTAGII
@SHASHANKRUSTAGII 4 жыл бұрын
I dont think this is not important for gate
@roshanpandey5357
@roshanpandey5357 6 жыл бұрын
JUETians hit like here so that I can see how many of you are there with me, watching this awesome video.
@AMANKUMAR-mh6vc
@AMANKUMAR-mh6vc 4 жыл бұрын
LOL
@saurabhsaini5890
@saurabhsaini5890 5 жыл бұрын
may i go to washroom sir! please
@iLochBolt
@iLochBolt 5 жыл бұрын
talk in english
@rajatgupta6043
@rajatgupta6043 6 жыл бұрын
Video time duration is more
@praisonjoshua7755
@praisonjoshua7755 6 жыл бұрын
RAJAT GUPTA loser,
@shammibhullar1033
@shammibhullar1033 6 жыл бұрын
Thanks a lot sir
@DILIPKUMAR-ws7td
@DILIPKUMAR-ws7td 6 жыл бұрын
Thanks sir
@agranshuaggarwal1333
@agranshuaggarwal1333 6 жыл бұрын
Awesome
@soniasmelodiousland
@soniasmelodiousland 5 жыл бұрын
Thanks sir
@karamchauhan7860
@karamchauhan7860 5 жыл бұрын
Thanks sir
3.5 Closure Set Of Attributes With Examples
17:56
KnowledgeGATE by Sanchit Sir
Рет қаралды 561 М.
3.10 Keys In DBMS
16:38
KnowledgeGATE by Sanchit Sir
Рет қаралды 431 М.
Beat Ronaldo, Win $1,000,000
22:45
MrBeast
Рет қаралды 151 МЛН
UFC 310 : Рахмонов VS Мачадо Гэрри
05:00
Setanta Sports UFC
Рет қаралды 1,2 МЛН
Support each other🤝
00:31
ISSEI / いっせい
Рет қаралды 60 МЛН
3.1 Functional Dependency in DBMS | Functional Dependency explained
15:03
KnowledgeGATE by Sanchit Sir
Рет қаралды 1,5 МЛН
3.9 Practice questions on Minimal Cover or Canonical Cover or Irreducible set
21:49
KnowledgeGATE by Sanchit Sir
Рет қаралды 234 М.
3.8 Minimal Cover or Canonical Cover or Irreducible set of Functional Dependencies
14:33
KnowledgeGATE by Sanchit Sir
Рет қаралды 568 М.
Lec 5: Armstrong's axioms in DBMS | Inference rules of Functional Dependency
25:05
Jenny's Lectures CS IT
Рет қаралды 412 М.
Armstrong Axiom or Inference Rule Of Functional Dependency in DBMS
8:17
A'square Academy
Рет қаралды 21 М.
3.11 Super Key, Candidate Key and Primary Key
21:49
KnowledgeGATE by Sanchit Sir
Рет қаралды 416 М.
Lec-23: Functional Dependency & its properties in DBMS in HINDI
17:09
Gate Smashers
Рет қаралды 1,7 МЛН