3.4 Armstrong's Axioms and Inference Rules in Functional Dependency

[@KNOWLEDGEGATE_kg]

For complete DBMS, check out this video: kzbin.info/www/bejne/j4PRm3qbhsemfrM

[@skittles6486]

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]

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]

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

[@selfhelpguy5589]

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!

[@ritikeshsharma9953]

Why are we lacking teachers like you in our college.....

[@RohIt_bhopali]

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

[@kmanish2528]

Best playlist on KZbin🔥🔥❤❤

[@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

[@SDE_M.sameem]

wonderful series of DBMS.❤

[@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

[@kartiksaini135]

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!!!

[@souravkumarcode]

1:25 if you have exams tomorrow

[@chinmaysisodia2571]

Me : 2:0

[@yashgandhi9698]

@@chinmaysisodia2571 me at 3x using an extension..

[@yashsakalley8121]

@@yashgandhi9698 Can you tell the name of that extension?

[@ardhyakumar2539]

@@yashsakalley8121 KZbin playback speed controller

[@rohanm2793]

I have not much words to admire for you, you are brilliant

[@RamanSingh-lq2xb]

This guy deserves my tuition.

[@nikhilsoni470]

composition & pseudo transitivity mujhe kahne samjh nahe aye the way you explain thank you so much.

[@KNOWLEDGEGATE_kg]

Thanks Nikhil.. keep learning and supporting !

[@ParthVikani]

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.

[@shashanksaxena6189]

thank you sir for teachng in very easy manner.I always score good marks because of you

[@aradhanasaxena8561]

U r really very awsam.... I didn't attend the lecture in colleges but I attend ur all lectures really very helpful

[@KNOWLEDGEGATE_kg]

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.

[@ayushiydvKG]

best faculty of DBMS on yt

[@KNOWLEDGEGATE_kg]

Glad you think so! Keep learning & following for more content😊

[@tilakdharisingh969]

Nice explation sir 👍 👌 👏 😀 🙌

[@KNOWLEDGEGATE_kg]

Thanks a lot dear! Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@kartickchandramanna267]

Good lecture 👍 Thank you sir 🙏

[@KNOWLEDGEGATE_kg]

Most welcome dear 😍Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@vivekmittal1454]

A very easy and intuitive explanation!

[@kanchanlatakulshrestha472]

Thank you so much for such a great explanation sir....😊

[@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👍😊

[@blessythomas8778]

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]

Learn Hindi

[@Alonkete]

Saali tu apne desh ja america

[@shubhaagarwal8041]

awesome learning

[@KNOWLEDGEGATE_kg]

Thank you Shubha.. Keep learning and supporting. For more courses and contents, you can visit our website www.knowledgegate.in.

[@pritambala4471]

R(ABCDEF), A---B, C--DF, AC--F, D--AF, E--CF. Anyone Please Explain Me This..............?

[@rudrakshrajvyas6656]

Amazing

[@KNOWLEDGEGATE_kg]

Thank you! Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@kaisemuhmmad3909]

wao.kmaal k sr app smjatay h.amazong.your lecture is so much nice as you are good looking from pakistan

[@karamchauhan7860]

Thanks sir

[@punnyabhatnagar6346]

Amazing explanation

[@roshanpandey5357]

Hi Sir, I want to say something ... you are great, JUETians hit like

[@raheelfida899]

Great Lectures Sir

[@syedmohdgulambaquer3577]

Sir please upload the videos on time stamp protocol

[@shree2710]

S.m.g. baquer exactly and locking too!

[@AnkitSingh-vp7mj]

Sir in composition we can also do augmentation by adding z in first and adding y in second. Hope I'm correct!!

[@mdasadahmed2769]

Thank You Very Much sir sir please 1 video banalijiya "" Microkernal Architecture in OS "" par

[@epicclips8881]

Awesome Explanation Sir ❤️❤️❤️❤️

[@K21-e2h]

You're the best sir

[@rameshpatil9148]

Thanks sir very helpful

[@ranjitkumar4]

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?

[@milanjain.2564]

Super teacher u r sir

[@OmitA25]

great explanation........

[@mdmozammilraza3215]

Nice Explation Sir

[@KNOWLEDGEGATE_kg]

Thanks a lot..keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses and contents !!

[@faizejafri1014]

Unbelievable... U r awsm..♥️

[@RoshanKumar-xu3nw]

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]

same question. Sir please help!

[@nelsonchacko2086]

Ty for this ..

[@yashkumardhawan6961]

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.

[@simrank9437]

sir please make more vedios on PDA and NPDA...

[@sagesy9774]

sir fees kidhar bheju ?

[@akshatanand5804]

Sanchit sir OP! in chat bois

[@deepakmathew2161]

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.......

[@jitendrapatel1110]

thanks for your help sir

[@sourabhnayak2753]

sir please also upload SQL lectures

[@arjunkhanna1803]

14:26 sir please explain about decomposition with real life example

[@narendraparmar1631]

Thanks sir ji😆

[@Healthylifestyle924]

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?

[@lekshmymayagopakumar1428]

Sir can u plz upload the videos of query optimization explaining algorithms.

[@PreetiSingh-ko7dm]

plz...give n example of augmentation......

[@sahrunakhan4522]

U r really awesome

[@fahimahmedshojib3701]

Best Video

[@KNOWLEDGEGATE_kg]

🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg 🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg

[@sarithaammu641]

Superb

[@simpalsingh5600]

suprb...video

[@shivanimalgotra2975]

Sir plz cursor control in dbms in hindi and example or trigger bhi samjayoo

[@parvadave1379]

Ty☺

[@satyam_krishna]

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]

Have u found the answer.. If yes then tell me..I hv Same confusion

[@preetmehta1008]

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

[@komalprajapati3243]

Sir please upload the video on the DAA.

[@withtheflow7526]

kzbin.info/www/bejne/ZnqkgY2wfLiVg6c

[@withtheflow7526]

Check here Very easy DAA lectures you get here..which must clear your Idea

[@kmpriyanka1223]

Sir Thanks you so much

[@junaidshaikh3597]

Really thank s

[@agranshuaggarwal1333]

Awesome

[@mosibkhan7903]

Thanks😎

[@pjjish]

Are your 64 videos sufficient for gate 2019? Please reply

[@AnjaliSingh-vt1yq]

Sir can u provide notes. In pdf

[@inderraj9263]

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 ....

[@prof_as]

sir if a->b and a->c is invalid statement than in composition rule why zx->zy and zx->wx is valid

[@9.5mviews74]

Bhay w and y are in the same tupple...i mean two attributes...not two tuples

[@jaihindpratap3901]

why u are writing DE ->ADEF while we have to write like this DE->ADFE because D->AF.

[@nabinbist1220]

relational model to nahi hey

[@bhaicodekaro]

thanks m textless

[@deogharplaces5843]

Don't able to capture screen shoot sir

[@tusharchadha1120]

Hey won't we have a C+ as a primary key cause all attributes are dependent on C

[@epicclips8881]

Fnatic Ftw ❤️ ❤️❤️❤️❤️❤️❤️❤️

[@rupammedhi9943]

Sir.. Are u an ex infosys employee?...

[@avinashkr5980]

ZX ---> ZY ZY --->WY Then we can find ZX ---> WY

[@parvadave1379]

Yes

[@gateeasycse]

sir please teach English language also

[@himanshusingh5118]

3-Nov-2021 ⛳

[@shubhampatel5576]

legend

[@KhanEditLabs]

B for bangru pta ni kia prha rha najma kay husband ho?

[@HamzaKhan-wy3ds]

😂😂

[@bikramchatterjee8296]

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.

[@SHASHANKRUSTAGII]

I dont think this is not important for gate

[@vlogwithankit6546]

🤩🤗🤩🤗

[@amanali9501]

Hello

[@unseenworld4325]

Thora km bola karye sir g.. Short m Vide

[@saurabhsaini5890]

may i go to washroom sir! please

[@prabhu-h7755]

2x

[@roshanpandey5357]

JUETians hit like here so that I can see how many of you are there with me, watching this awesome video.

[@AMANKUMAR-mh6vc]

LOL

[@iLochBolt]

talk in english

[@navroze92]

Play at 1.25x speed

[@rajatgupta6043]

Video time duration is more

[@praisonjoshua7755]

RAJAT GUPTA loser,

[@NishaSharma-nd1dk]

Thanks sir g

[@KNOWLEDGEGATE_kg]

Welcome, visit www.knowledgegate.in for more courses and content

[@shammibhullar1033]

Thanks a lot sir

[@AmandeepSingh-sx9ke]

Thank you sir

[@agranshuaggarwal1333]

Awesome

[@soniasmelodiousland]

Thanks sir