3.1 Functional Dependency in DBMS | Functional Dependency explained

[@KNOWLEDGEGATE_kg]

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

[@nitai2222]

You had saved our semesters million of times , please we request you to update whole intensive course videos for every gate cs subjects as it would be effective and easy to many engineering students who are unprivileged , please support and promote digital education.

[@SHEETALSHARMA-tz7sm]

2:53 - Functional Dependency 8:52 - Formal definition of functional dependency 11:28 - Types of functional dependency

[@ayushthakur733]

Tnx

[@nbledits3199]

Sukriya

[@fann8935]

Thanks😁👍

[@69clouds]

kzbin.info/aero/PLfVk7-ggg0-pN3_p5I_NX5uzfGBMJ6O9W

[@dipaloksen2680]

Thanks chad

[@laxyasharma7535]

I think his brain works 4 times faster than average. My favorite teacher

[@muskaan4591]

sir videos in playlist after 2.7-Participation constraints are missing. Please upload the missing videos.

[@KNOWLEDGEGATE_kg]

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

[@mohit87jain87]

part 2.8 is missing. weak and strong entity set. discriminator attribute. if available then please upload videos. thank you

[@techsupport6666]

missing videos in playlist after 2.7-Participation constraints . Please upload the missing videos.

[@sasirekhamsvl9504]

Yeah they are missing.

[@vishichaurasiya4427]

Please upload videos in a hierarchy

[@anubhav1020]

yeah he said he would discuss Strong and Weak entity set & Discriminator Attribute.

[@vishakasaxena5019]

Sir you are too good. Whenever I've any confusions, I just watch your tutorials and every concept become crystal clear. Thank you Sir for always helping me out. 🙇‍♀️

[@KNOWLEDGEGATE_kg]

You're most welcome dear Vishakha, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@ankitaroy2911]

sir i watched all your videos on dbms. i really liked your style of teaching and it helped me alot. just going through your video and the style in which you taught to solve the problem really helped me in my btech exam. just a one day watch on all the topic and going through books cleared my concept. thanks alot sir

[@swaritthakare3081]

the most reliable place for me, because even i tried to read these topics in a book for more than 5 or 6 hours they havent make me understand and not really helped in solving problems.

[@ditexamcell7358]

Sir my self sandip bose from kolkata........lecture given by you nt gst good it is superbbbbbbb........the way ur communicate and teach its jst awesom.............i m lucky enough to learn ur valuable concept about DBMS...........thank you so much.......sir.............

[@shailendrajain2219]

Sir, First of all I want to say you thanks. I qualified NET NOV 2017 Exam in computer Science and Application subject by watching your video lecture. You are great trainer.......

[@jerrylacefield774]

I have absolutely no experience speaking or understanding Hindi and I must admit that your video is quite possibly the most clear explanation for helping me to understanding functional dependencies. Your example of providing the business accountant with your name, id number, father's name, etc. to be used to search the database only for them to come back and tell you your name after searching with those key values ... that made me laugh but you provided me a breakthrough for understanding what it means to be trivial vs non-trivial. For that I thank you.

[@rishuuup]

Beautiful people i request you all to please share this channel and know about that because he is great teacher and today students need teacher like him he is not my relative , not a college teacher whatever , just today watche his videos and its very amazing and understanding video so please support him❣️❣️

[@KNOWLEDGEGATE_kg]

Thanks a lot dear for your valuable feedback & kind words❤ Stay blessed & keep supporting! Stay connected for more amazing contents & videos 👍😊 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

[@kaneezfatima9535]

i'm thank ful to you sir .....ur the super and bst indian teacher .....in ur knowledge Gide tutorial....i'm learn so many topic...from ur lecture 70 %question i attempt in th my final exam ...thanks ur so much sir for uplod a lecture ...

[@jazzsjo6323]

SIR YOU'RE AWESOME... The way you explained ! I'm absolutely never going to forget this.

[@prasadnarode3477]

agar har college ka teacher aisa ho...to students hi badal jaye...amazing teaching technique sanchit sir

[@prasenjitsen4111]

Thank u so much Sir...

[@dhirendratiwari7338]

Sir ..one thing I want to express ur concept is just awesome ...one thing which is special that is ur way to explain ....

[@vineetkumar9371]

Hello sir aapne data structures kaafi accha padaya gateforum coaching centre mein and aapki saari videos dekh kar mera placment ho gaya hai . Thanks

[@shreshtha100]

Good noon sir, we are preparing for NET/JRF and we were looking for a Perfect guide mean while i seen your channel and watch your videos which have fulfill our concepts .Sir you have done a INCREDIBLE job at here. We want to learn my whole NET subject by you. Its my good luck if you will provide videos as concern covering my CS syllabus.

[@tusharkoli8515]

Best DBMS teacher on KZbin. Sir your support is priceless.

[@abhisheksemwal1997]

Sir, this is great. Hindi you use in between is a way greater help then anything.

[@asadsiddiq4084]

ja bey pagal

[@enriquebenedicto9429]

For those who understand it. For the remaining ones (I suspect), it makes it harder. Nevertheless, I do enjoy his lectures.

[@enriquebenedicto9429]

In fact. After viewing his series on DFA and learning quite a bit from them, I decided to come here and watch this series. I'm now giving up because the constant switching is just annoying and demands way too much effort to follow. Unfortunate he simply didn't create different versions, instead. Not that he owes me and others like me, anything.

[@initiator0016]

@@asadsiddiq4084 dumbass

[@Anagha_VK]

@@enriquebenedicto9429 yes..i dont know hindi 😕

[@rajatjyotishi7193]

The best Teaching Channel I have seen so far!

[@aliahmad8224]

Great teacher of my life

[@thefrustratedboyy]

u are far better than many youtube tutorials

[@KNOWLEDGEGATE_kg]

Thank you so much brother 😀We are glad you liked our work !! Please review our new app tiny.cc/yt_KgApp . Your review will help new audience to trust us 😄

[@mahimachitkara3111]

The way u teach is really good . . I have a question below please provide me an answer for the same with explanation as I have a doubt in it please Identify the minimal key for R(A,B,C,D,E) with functional dependencies F={ A->B, B->C, AC->D}

[@vivek1990100]

please complete all subject completely ...your explanation is very nice sir ji

[@yogeshsharma7269]

grt sir ----------------- now u hv made us to clr gate n net

[@pakeezafatima6559]

kal mera database ka exam ha and i am very thankful to you for these informative videos.. you are much better then my university tachers😁👍

[@shivam_0002]

Thank you, Sir. Tomorrow is theory Exam of DBMS and you saved my exam. I am very thankful to you for these videos and i wish we can see more videos from you side on other topics also.

[@rohankhante2149]

Excellent explanation sir!!!!! Appreciate you.

[@vaishaliranjan4862]

You are my fav teacher

[@KNOWLEDGEGATE_kg]

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

[@adithyakvc2510]

great explanation sir ,truly loved ur way of teaching

[@prathameshmestry9482]

awsum lecture sir..........just as the thumbnail says, concept was clear in no time...Thumbs Up

[@yashverma6032]

You are very good at explaining various topics and I very easily understood all the topics. But I would like to suggest that you can add English subtitles for the part where you use Hindi. That would be very helpful for people that have problem with Hindi. Also, please make videos on trees like B tree and B+ tree, etc.

[@shibobrotadas5858]

Sir, please don't put ads in between your video explainations, it's disturbing the concentration into the subject. I've understood each and every point you've explained. Thanks for bringing out such great videos. These videos are of great help to students struggling to understand concepts.

[@prabuddhbharat2934]

nic video sir ....it is not only cs but ece people also who r preparing for competitive exams

[@kaneezfatima9535]

thanks you sir ......I liked the your lecture .......when u use hindi in between lecture...your teaching method is very good sir ....

[@KNOWLEDGEGATE_kg]

Thanks Kaneez Fatima for showing gratitude, your comment is valuable to us. :)

[@computersciencealgorithms6196]

You have made DBMS so easy...thank you ....

[@ashutoshbang8812]

You should use real life examples instead of alpha or beta

[@dhruvthakkar4350]

Best teaching..need a teacher for android like u..i am ready to pay!

[@supratimnag7844]

Sanchit bro, I thought I would leave this subject in GATE. But, the way you taught, I'm thinking of making this as one of my strong subjects to attempt!👍👌

[@anurag9110]

बहुत खूब समझाया सर आपने

[@Abhishek-jc8bi]

your videos are awesome sir,i am preparing for gate without coaching and relying on your videos.

[@chiranjitpal8485]

Sir please kindly upload relational tuple calculs with some of the problems asked in gate exam.. Sir you are my hero. You have done really a great job for us

[@reenathomas7936]

Sir super lectures. I don't know Y some people are unliking this videos....!!!!!!

[@nehamiglani1000]

hello sir. I was preparing for net and have cleared the exam dis year. your contribution is really appreciable. I followed ur dbms and os lectures and were proved very helpful to me. thanks really. keep up​ the gud work.god bless you:)

[@theavenger1289]

Thank you very much sir!! It's great to listen you...So, Well explained...☺☺☺

[@tanmaypriyadarshi865]

Very very thanks sir..... I'm very grateful to you for these videos

[@gulrezeqbal3048]

Very clear explanation sir Thanks !

[@shazifabbas3769]

Awesome sir g what a teaching technique used by u ...

[@akhilmaxy6068]

bhai aaaap bhagvan ho...! i m scoring gud marks in all subjects coz of ur videos please cover all topics of each subject!!

[@saubhagyamandal8220]

so easily I understand the concept..great work sir...thank you so much for helping us🙏

[@KNOWLEDGEGATE_kg]

Hello Saubhagya, Thanks for showing gratitude, we are glad that we could help you. :)

[@kamranwaheedsiddiqui7681]

Bhai lush kardiya aap ne kabh se eik acha lecture dhoundh raha tha abh mil gaya Thanks for sharing your knowledge!

[@shubhankarpaul2740]

very good video !!! i like this teacher very much !!

[@legend7890]

this is the only lecture where I have seen more then 1 million + views .

[@shubhamchourasia2265]

Thanks a lot for these tutorials... Also, can u put a tutorial on relational algebra in DBMS?

[@IRSHADALI-ph7iy]

Sir apne bahut achha samjhaya.....sir plz gate k sare syllabus ka lecture depth me upload kijiye...plz sir

[@ShivamGupta-nz7dy]

thank you so much sir. You are a legend and my super hero. I never knew dbms could me so much interesting, thanks a lot.

[@jaychoudhary695]

Awesome videos Sir.. these videos cleared all things which couldnt in my class. Thanks a lot..!!!! keep it up..

[@KNOWLEDGEGATE_kg]

Hi Jay, we truly appreciate your kind words for our efforts, and we are glad that we could help you. :)

[@jaychoudhary695]

Its great.. Hats off Team :)

[@i_m_shankar]

Ur explanation is wow wow wow...

[@meghasharma6114]

Very nice explanation sir.. Thanku so much!!

[@mayanktripathi1383]

Sir, I have been your student in GATE classes. You have taught Operating system there. I was terrible at OS and the mere mention of terms like synchronisation and process used to haunted me (probably because of they way it had been taught in the college), but those classes by you have changed everything. Everyone in the class was so excited to attend your lectures. And for the same reason, the day you have announced that you will take Dbms lectures too, the whole class went like hurraaaaay! You were a silent rocket star and universally loved teacher in the class. And you know what, why one is so good at teaching and someone is not? Because this happens when your passion is teaching and you love to teach. Later I got a good rank in gate, and admitted to a good college. I still miss your classes.

[@KNOWLEDGEGATE_kg]

Best of Luck for your future Mayank

[@rishabhmishra1113]

what are u doing mayank

[@ManishKumar-zt5sk]

best DBMS material on internet

[@masteradvisor594]

Better than my college professor for sure thanks sir

[@KNOWLEDGEGATE_kg]

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

[@lalitasethi8372]

best teacher everrrrrr

[@aryamaansingh1894]

Sir very nice video and giving explanations in Hindi makes it even easier to understand

[@bhandbhandari1306]

Sir u r the best teacher..... ☺😊

[@Arjun8BPCracker]

sir great ........sab samaj aagya dun dun dun dun dun ......

[@devanshanhal3336]

lame

[@anuragC819]

bhag ke samajh aya kya? xD

[@gaurijare695]

@@anuragC819 ha bhopal se dun dun dun dun

[@adrshhyadav2505]

had a long time to worry towards the subject, now it seems to be attractive just because u made it so :)

[@KNOWLEDGEGATE_kg]

Thanx yadav ji for delightful and encouraging words and we are glad that we could be helpful. :) :)

[@TheRaviKr]

@@KNOWLEDGEGATE_kg sir videos in playlist after 2.7-Participation constraints are missing. Please upload the missing videos.

[@sahilmishra8270]

great explanation sir.no one can teach like u

[@ayushsharma1309]

nice sirr i realllyyyy atracked youurrr motivation

[@KNOWLEDGEGATE_kg]

Hi Ayush, we truly appreciate your kind words for our efforts. :)

[@juhiagarwal4700]

Kindly upload videos on paging and segmentation...highly motivated

[@vivekpatel2116]

Its Always a cakewalk with a subject with u sanchit sir.

[@rachnapatel8343]

Bht acha samjhaya bhai👏👏

[@bharadwajyash]

Thank for sir for making it so understandable

[@prashreetiwasti7264]

Topic starts at 2:55 . Thank me later

[@Great_one1]

thanks

[@vikalchoudhary484]

cool

[@yasminshaikh8583]

Thankuu soo muchhh

[@ShaliniSingh-xc5rn]

Thank u

[@yasminshaikh8583]

@@ShaliniSingh-xc5rn ap yaha kese??

[@rajkamalchoudhary290]

SIR, I am software engg having 10 year exp working in MNC first time in life normalisation and different type of keys concept clear. your videos are not only supporting student but also working professional also.

[@ashishraigame]

Thank you so much! if you were not there it would have been difficult to pass the exam! again thanks alot!

[@ankurprakash2244]

You are great teacher.

[@engineershub5932]

one of the best tutorials I have ever seen...thank you so much for helping us.

[@KNOWLEDGEGATE_kg]

Hi Buddy, we truly appreciate your kind words for our efforts, we are glad that we could be helpful :)

[@TheRaviKr]

@@KNOWLEDGEGATE_kg sir videos in playlist after 2.7-Participation constraints are missing. Please upload the missing videos. and keep going sir

[@shubhampodhade7653]

Thank you sir. Nice explanation

[@rishabhpandey9614]

and your English is very impressive

[@riddhigupta3371]

Great sir. Thanks a lot.

[@KNOWLEDGEGATE_kg]

Hi Ridhi, Thank you so much, would like to hear more from you. We upload more topics every week, Please subscribe this channel for best GATE tutorials. :)

[@gavindias7]

very well explained. Thanks

[@kiransagar5076]

Very helpful lectures. Thanks a ton.

[@PravinJanjal92]

So many thanks cleared trivial and non trivial

[@PamiLife]

Fabulous sir......it's very easy.....

[@CRAZYGAMERFun]

sir apke videos dekh ke TOC ka paper clear kr liya thanku sir 😊😊😊

[@Chessqueencoach9]

thnxyou for explaining in hindi..

[@sid_mod]

hats off SIR... waiting for the full playlist of DBMS....

[@tusharchhabra5522]

yes sir plz upload transaction videos... there is no series except this tht I am completely dependent on..

[@mizzzile]

Great explanation. Loved it.💛

[@prabhattyagi]

Tum bhot mast kaam karta hai ...sanchit bhai

[@kumarsarthi232]

Please upload video on converting ER diagram,Crash Recover,4NF,Querries related problem. Sir you are the best teacher in INDIA and teaches very well not like an engineering teacher of IIT

[@Ising34]

sir ,all lectures are awesome..the way u teach is very much appreciable..all d best sir,keep up your work!!

[@priyankasvlog399]

want more videos for gate exm...u r doing a great job sir

[@Chessqueencoach9]

Sir ur explanation helped me alot.. thnxyou so much stay blessed live long

[@sindhus97]

Sir... U deserve to be a Lecturer..!... Thank you for ur help.... It's a great and easy help to me..!... Keep going!

[@kanwalpreet8310]

You nailed it....