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

[@souravkumarcode]

1:25 if you have exams tomorrow

[@chinmays2571]

Me : 2:0

[@yashgandhi9698]

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

[@yashsakalley8121]

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

[@ardhyakumar2539]

@@yashsakalley8121 KZbin playback speed controller

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

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

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

[@rohanm2793]

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

[@shashanksaxena6189]

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

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

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

[@RamanSingh-lq2xb]

This guy deserves my tuition.

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

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

[@kaisemuhmmad3909]

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

[@vivekmittal1454]

A very easy and intuitive explanation!

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

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

[@mdasadahmed2769]

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

[@epicclips8881]

Awesome Explanation Sir ❤️❤️❤️❤️

[@ayushiydvKG]

best faculty of DBMS on yt

[@KNOWLEDGEGATE_kg]

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

[@punnyabhatnagar6346]

Amazing explanation

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

[@syedmohdgulambaquer3577]

Sir please upload the videos on time stamp protocol

[@shree2710]

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

[@raheelfida899]

Great Lectures Sir

[@AnkitSingh-vp7mj]

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

[@faizejafri1014]

Unbelievable... U r awsm..♥️

[@OmitA25]

great explanation........

[@KNOWLEDGEGATE_kg]

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

[@rudrakshrajvyas6656]

Amazing

[@KNOWLEDGEGATE_kg]

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

[@roshanpandey5357]

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

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

[@K21-e2h]

You're the best sir

[@milanjain.2564]

Super teacher u r sir

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

[@rameshpatil9148]

Thanks sir very helpful

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

[@simrank9437]

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

[@nelsonchacko2086]

Ty for this ..

[@PreetiSingh-ko7dm]

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

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

[@pritambala4471]

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

[@arjunkhanna1803]

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

[@lekshmymayagopakumar1428]

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

[@shivanimalgotra2975]

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

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

[@narendraparmar1631]

Thanks sir ji😆

[@jitendrapatel1110]

thanks for your help sir

[@sourabhnayak2753]

sir please also upload SQL lectures

[@sagesy9774]

sir fees kidhar bheju ?

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

[@sahrunakhan4522]

U r really awesome

[@parvadave1379]

Ty☺

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

[@deogharplaces5843]

Don't able to capture screen shoot sir

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

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

[@mosibkhan7903]

Thanks😎

[@junaidshaikh3597]

Really thank s

[@sarithaammu641]

Superb

[@simpalsingh5600]

suprb...video

[@tusharchadha1120]

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

[@fahimahmedshojib3701]

Best Video

[@AmandeepSingh-sx9ke]

Thank you sir

[@AnjaliSingh-vt1yq]

Sir can u provide notes. In pdf

[@kmpriyanka1223]

Sir Thanks you so much

[@akshatanand5804]

Sanchit sir OP! in chat bois

[@agranshuaggarwal1333]

Awesome

[@nabinbist1220]

relational model to nahi hey

[@pjjish]

Are your 64 videos sufficient for gate 2019? Please reply

[@epicclips8881]

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

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

[@himanshusingh5118]

3-Nov-2021 ⛳

[@jaiveerrana5691]

sir how questions comes in exam

[@rupammedhi9943]

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

[@gateeasycse]

sir please teach English language also

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

[@bhaicodekaro]

thanks m textless

[@shubhampatel5576]

legend

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

[@avinashkr5980]

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

[@parvadave1379]

Yes

[@KhanEditLabs]

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

[@HamzaKhan-wy3ds]

😂😂

[@SHASHANKRUSTAGII]

I dont think this is not important for gate

[@vlogwithankit6546]

🤩🤗🤩🤗

[@amanali9501]

Hello

[@kausartalks]

Thora km bola karye sir g.. Short m Vide

[@navroze92]

Play at 1.25x speed

[@saurabhsaini5890]

may i go to washroom sir! please

[@prabhu-h7755]

2x

[@iLochBolt]

talk in english

[@rajatgupta6043]

Video time duration is more

[@praisonjoshua7755]

RAJAT GUPTA loser,

[@shammibhullar1033]

Thanks a lot sir

[@DILIPKUMAR-ws7td]

Thanks sir

[@agranshuaggarwal1333]

Awesome

[@soniasmelodiousland]

Thanks sir