Lec-22: Finding Closure of Functional dependency in DBMS | Easiest & Simplest way

Подписаться 1,9 млн

Просмотров 1,3 млн

50% 1

👉Subscribe to our new channel: / @varunainashots
0:00 - Introduction
0:34 - Example 1
5:55 - Example 2
9:15 - Example 3
► Database Management System(Complete Playlist):
• DBMS (Database Managem...
Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
• Design and Analysis of...
►Computer Architecture (Complete Playlist):
• Computer Organization ...
► Theory of Computation
• TOC(Theory of Computat...
►Artificial Intelligence:
• Artificial Intelligenc...
►Computer Networks (Complete Playlist):
• Computer Networks (Com...
►Operating System:
• Operating System (Comp...
►Structured Query Language (SQL):
• Structured Query Langu...
►Discrete Mathematics:
• Discrete Mathematics
►Compiler Design:
• Compiler Design (Compl...
►Number System:
• Number system
►Cloud Computing & BIG Data:
• Cloud Computing & BIG ...
►Software Engineering:
• Software Engineering
►Data Structure:
• Data Structure
►Graph Theory:
• Graph Theory
►Programming in C:
• C Programming
►Digital Logic:
• Digital Logic (Complet...
---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
► Subscribe to us on RU-vid: / gatesmashers
►Subscribe to our new channel: / @varunainashots
► Like our page on Facebook: / gatesmashers
► Follow us on Instagram: / gate.smashers
► Follow us on Instagram: / varunainashots
► Follow us on Telegram: t.me/gatesmashersofficial
► Follow us on Threads: www.threads.net/@gate.smashers
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Email us at: gatesmashers2018@gmail.com
#findingClosure#Normalization#GateNet#freecoaching

Опубликовано:

28 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 705

@aqdasak 3 года назад

Jo pdha rha h wo salary nhi le rha, jo salary le rha h wo pdha nhi rha. Thank you a lot

@mihirkumarsrivastava9389 3 года назад

exactly 😑

@vishnusudarsanam5375 3 года назад

Whole Indian education system in one sentence.

@RealZephyro 3 года назад

you just summed up the story of tier 2&3 institutes in one sentence

@tanish5231 3 года назад

@@RealZephyro tier 1 ke bhi yehi haal hai vai 😩

@ammanagrawal762 2 года назад

@@vishnusudarsanam5375 Sahi kaha bhai teachers ka boora haal hai coaching centers mein and clgs mein bhi

@abhipatel342 2 года назад

My dad is paying lakhs of fees to my college institute but they can't teach us the way you are teaching us. Whom we are paying fees are not teaching and here god sent you who is teaching us at free of cost. ❤️❤️

@rahuldodiya1456 2 года назад

Same brother

@HKSWAG_99 Год назад

TRUE

@pranoysaha150 Год назад

True 👍🏽

@dude_69____80 8 месяцев назад

Fun fact - institute/University takes lakhs of rupee only for a degree.

@lekhchhabra8385 7 месяцев назад

tho rooh le

@shivanshmalviya831 3 года назад

Insaan ke roop mein sakshaat CS/IT ke avatar 😂❤️🙏🏻🙏🏻

@Asha0224 2 года назад

😁🙏

@rishavchaddha324 2 года назад

😭😭😭😭😭😭😭

@rishavchaddha324 2 года назад

Mara Sara mjak bnata ha Muja Sara maarta ha Mara saath koi dosti nahi karta Ma bhut akaala hu 😭😭😭😭😭

@missjoshi7686 2 года назад

Right bro 😂❤️

@sunirmalsasmal7885 Год назад

Exactly

@ankitmehta4133 3 года назад

Brother, god send you on the earth to helps the millions of students. How can you be so perfect. Your explanation is amazing. You are a messenger of god. God listen our prayers and send you. Love you bhai. 😍

@GateSmashers 3 года назад

Thank you so much for your true wishes...

@madhavnandan9515 5 лет назад

I have seen so many lectures on this closure topic but the way this guy explained man! I'm blessed that I did solidified my concept. this guy should get more subscribers.

@sumitsinghachowdhury3521 4 года назад

For real Learner if u watching this video and unable to understand or having some doubt then please watch next video(Lec-22) then this .. it may be fruitfull to u,... but sir lots of Love from my side . you are great !

@amishbhat3560 3 года назад

That's why I was not able to understand. Thanks man !!

@codewithharshit7 2 года назад

Same problem..I was in panic 😅😅😅 Why I'm understanding anything.

@learnitallbyteacherali1075 Год назад

Thanks , now I am getting this one👍

@Fizzerrr 2 месяца назад

@@codewithharshit7 lol

@perisetlasatwik8139 2 года назад

I think the order of lectures in the playlist is a little bit jumbled here , the next video and this video should be swapped ig

@Mathematics_concepts 3 года назад

No words to say for your dedication. You have cleared lots off doubts with in 10 minutes.

@bloom6874 2 года назад

you never ask to refer the previous video while covering the previous topic in the next video. However, you explain that previous topic again in brief. This actually helped me to understand normalization and closure method, though I check your this closure video while I was watching your normalization practice questions video. Before visiting your channel, I had checked other channel's videos also but I was unable to understand any topic as they were asking to visit the previous video. Obviously you can't expect a new visitor to check all videos your at once if visitor is not a student but a professional. I am glad that I found your channel.

@shivangsingh1227 8 месяцев назад

15:06 The FD is BC-->D, which means you need B and C to get D. But you have splitted the FD as B-->D and C-->D which is wrong. The splitting property doesn't work like that, eg: if A-->BC then you can split it to A-->B and A-->C, not like the way you did.

@digantamoulik8468 5 месяцев назад

Yes bro.. I have confusion on that part also.. if you get any solution please update

@shripadkhandare Месяц назад

Yes. Your Observation is correct.

@parinav10 Месяц назад

Please pin this comment, will help people

@sam-pe7uy 22 дня назад

My same observation

@prolaypc4479 4 года назад

WOW! CLEARLY CONCEPTUAL SKILL OF TEACHING. DBMS PLAYLIST IS MOST VALUABLE FOR ME IN BCA. LOVE YOU VARUN SIR.

@anjneykumarsingh4461 3 года назад

Same bro

@Bimal_moharana 6 месяцев назад

Also MCA 😅😅

@bharatbhushan2197 3 года назад

This one video is sufficient and best to learn how to find candidate key. Must watch. Thanks a lot sir ji

@ayankhana-5321 2 года назад

Your way of teaching is really amazing when I was studying by books I always thought that DBMS is very hard but after watching your videos each and every concept got clear for me thank you so much sir for making such priceless videos

@sarahqureshi5026 9 месяцев назад

CE will also be candidate key if we find its closure in the same way as we did of AE.

@tayyabsami258 2 месяца назад

yes as BC->D so D will be included from D we get A from A we get B

@priyankaghanghas2237 4 года назад

You are simply amazing.. no one can explain it better than you.

@itworldnote 4 года назад

You are great sir. All the concepts are clear in just one video. Love you sir..

@maybepriyansh9193 2 года назад

Great lecture sir but you should reorder lecture 22 and lecture 23 in the playlist. They should be swapped as lecture 23 (functional dependency) info is prerequisite to understand this lecture properly.

@Hope_for_life Год назад

yes you are right i also had a problem with understanding but now its alright anyways thank you !

@sumitsingh-pc4ul Год назад

They should be interchanged rest these are excellent lectures

@akki692 Год назад

Uhh aree simplyyyy amazing..... No wrds to discribe.... Cmplt pack of knowledge.... Bestestt teacher ever......... So soooooo thankful sir....

@leonatavares799 5 лет назад

Sir thankyou very much for these vidoes. May God bless you abundantly. Your explanation is the best!!!

@86madhurigupta 4 года назад

Very easy explaination! Understood difficult concepts very easily through your videos. Thank u sir!

@sangeetamukherjee7413 3 года назад

THANK YOU SIR FOR GIVING US THESE PLAYLISTS. IT HELPS US A LOT. THANKS A LOT SIR. REALLY YOU ARE GREAT..

@sushilpatankar488 8 месяцев назад

I didn't know the difference between candidate and super key but now it is crystal clear.

@divyachoudhary5938 4 года назад

Sir, you are really amazing and your way of teaching is awesome.... One word :WOW

@AbhishekKumar-kd7bp 4 года назад

mai pagl tha jo NPTEL se DBMS sikhne k kosis kr rha tha..

@abcdeftanutanu2187 3 года назад

ho drag rubber band hai

@AbhishekKumar-kk6qs 3 года назад

I use NPTEL for sleeping purpose.

@saurabhpandey2018 2 года назад

Nptel pe teachers to knowledgeable rhte but boring padhte 😒😒

@mdaaweshpatanwala8542 2 года назад

lol

@hiaryan Год назад

Our kya , bahaut bade chutiya the tum , ab chup chap gate Smasher se padho bus 👍👍

@mukulrajora9335 3 года назад

Kl Rahul ka side profession teaching h 🙄🙄 I hope u got my joke😂😅

@GateSmashers 3 года назад

Test match me nahi tha to part time teaching shuru kiya😄😂

@projectwork1408 2 года назад

@@GateSmashers varun sir ❤️🔥

@kukustats 2 года назад

i didn't get your point

@68vishaldhampalwar45 Год назад

One of the best teacher I have ever seen ....

@piyushramteke2421 2 года назад

Thank You so much sir for Delivering this Quality Courses 🔥👏👏🔥

@dilsetak 2 года назад

sir I 'm in 3rd yead and i am your students from 1st year....you are real teacher tq sir from bottom of my heart❤ IT student

@dipayansengupta5197 2 года назад

Thank god for all those bollywood movies that i watched growing up, i can understand closure in DBMS now. Thanks from Bangladesh

@meghanagudi7842 3 года назад

Sir your teaching is exceptionally well. I see my subject related videos and those are really understandable. Subjects are getting very easy to solve after seeing your videos Thank You so much sir you're the best teacher I wished to have 💕😁🙏

@mamtakumari8768 2 года назад

thank you so much sir your lecture is always more than better to 1-hour lecture to college.

@A_LEARNER27 6 месяцев назад

Thank you so much, means you are doing a wonderful job! Far far far better than our college professors!!!!!

@AbhinavKumar-fv7qx 2 года назад

Hats off to u sir U r not just teacher.. 😀 U r genuine GOD MADE TEACHER.. 😍 Simplified nd most important... Minimised Contents with maximum coverage 😀

@profitjourneywithsk2136 4 года назад

You are awesome sir.A lot of love and respect for you.

@deepshikhatiwary37 3 года назад

really amazing no words for your explanation crystal clear and simple

@manognakachiraju5993 Год назад

Thank you for explaining this concept so perfectly! This video really helped me.

@thakkudubala4456 4 года назад

Sir excellent class.. 3 rd example is a new info for me... Thanku so much.

@mandiradevkota1610 Год назад

thank you so much dear stranger load of love from nepal today i had exam of dbms and through your video i did it so well ❤️❤️❤️❤️

@Khanarmaanrokz 3 года назад

Great explanation Thank You Sir . much respect.

@pritishamukherjee7084 Год назад

Sir , you are a God level teacher. Thank you for saving my dbms paper. 🙂

@kokilagoel2714 3 года назад

Thanks a lot sir ....u cleared all my doubts about finding candidate key.....u are like my elder brother......so thank u bhaiya .....and mam ko and apke father ko bhi bhut sara thanks ...aap hum students ki bhut help krte ho .....All the best for ur bright future👍👍😊👏👏

@farahsultana1988 3 года назад

Hello Mr. Varun. As an online study we are very happy with all your lectures and your presentations . Please Keep up with all your services. All the best wishes from Bangladesh. In your DBMS class in lecture : 22 (Finding Closure of Functional dependency in DBMS ).... in the time interval 15.18/17.46 you lectured that. .... DE+ = B i.e you only replace the D with only B ... but BC->D...then why didn't you replace it as DE+ = BC...and then find the closure BCE+????And in lecture 23(Functional dependencies and its properties) you already marked as if xy->z than x->z and y->z never be occurred ... Moreover, if x-> yz then we can write .. x->y and x->z individually. ... So please help me to eliminate my confusion.. again love & respect & deep support for you from Bangladesh for your contribution. Thanks a lot.

@souravmalik6120 Год назад

Basically it is trick that he used in this video to find Candidate key and it has no relation with rule mentioned in lecture 23 bcz it is a trick. Okiee

@farahsultana1988 Год назад

@@souravmalik6120 thanks for help

@souravmalik6120 Год назад

@@farahsultana1988 not expecting the reply though. Bcz my reply is one year late. ROFL . Cheers !!

@amanbudhraja9121 10 месяцев назад

@farahsultana1988 Same Doubt

@nikitabiyani8111 2 года назад

Thank you Sir.... you made computer science very easy for us.....💗💗💗💗💗

@epicclips8881 4 года назад

Awesome Explanation Sir 👍👍👍👍👍

@SamsungJPro-qo2cn 4 года назад

Sis your explanation method is simply great. Just awesome

@mohammadpervezhussain5742 4 года назад

Wow sir ... Just amazing... It helped me in exams... ☺️☺️☺️ Thank you sir...😊😊😊

@ShivAdiShakti108 5 лет назад

Superlike! Amazing explanation Sir 👍

@tubeljohn6717 2 года назад

Thank you for these excellent videos, sir. I did notice a slight error at 8:30 though. The null set and the set containing the null set are not the same.

@VimalKumar-ly7gw Год назад

Thank you 😊 so much sir to explain everything without any confusion.

@golamarumahesh5648 4 года назад

The way you are explaining concepts are simply amazing sir👌👌

@GateSmashers 4 года назад

Thank you so much..Bless you

@arnabadak5751 3 года назад

brother this playlist helps me a lot....

@ompatel8621 3 года назад

sir you are greatest. khass mai appse live mai pad pata but anyways thanks for your video lecture for free. thanks a lot sir

@user-kz6qi7nn2h 9 дней назад

whenever I face any problems in questions every solution I can get from your video. thank you sir 🙏

@shrutijaiswal2487 3 года назад

Thnku sir u are great sir.... phele 2 video kisi aur ki dekhi smj m nhi aaya but aapki video dekhne k baad sb smj m aa gya thanks sir

@deboshreedey2333 3 года назад

thank you so much sir for your easy and detailed explanation.

@abelabraham8074 4 года назад

Thank you, Sir!

@delowarmia1331 5 лет назад

Great lecture Vai-a.

@roshnihinduja5850 Год назад

I was finding it so difficult!! But you made it too easy for me😊

@AnjaliGupta-op1hr 2 года назад

thank you sir for your wonderful channel 🤗

@legasrielumalai8043 3 года назад

Thanks a lot sir, your way of teaching is really awesomee.

@shrinivas5857 Год назад

amazing teaching and easy explain. very good brother keep it up.

@divyasharma9040 4 года назад

Thanks sir ..ur teaching is best to understand

@naimul8381 2 года назад

simple & gorgeous explanation🔥

@publicstudio66 3 года назад

LOVE AND RESPECT FROM PAKISTAN ...DEAR SIR.

@CrazyManbypuspendra 5 месяцев назад

sir aap bahut badhiya padhte hai ek baar main hi sab samajh aa jata hai(you are a genius person) No words to say for your dedication.

@vanidasan9792 5 лет назад

Very effective lecture sir tq so much............

@geetanjalibiswal7233 2 года назад

Really u r a good teacher 🙏

@bhaveshmakwana5596 2 года назад

Gr8 method for explain. Thanks a lot sir 🙏

@Ravikumar-en9ub 3 года назад

Your teaching methodology is amazing..!!

@udipto100 6 лет назад

Nice explaination sir.

@arjunvashishtha767 4 месяца назад

Sir you made dbms very simple for me ....thank you

@neelamminhas2484 4 года назад

Sir g u r great really u r study way is amazing

@heyyyy28 3 года назад

Wahh.. super sir Thank you so much... 🥰😍❤

@Ajinkya_Chirde_07 6 месяцев назад

Great explanation ✨🙂

@lorewithmaitryeegupta9887 5 лет назад

Hello sir, firstly thanks to you so much just because of your explanation now I can solve these type of questions surely. ... otherwise my anwers are sometimes wrong and sometimes right... your explanation skill is mind blowing. .. can you please share more vedio on other net subject.... sir please...

@sunshinelady415 3 года назад

You are the best ❤️ sir ...

@thundertech4025 10 месяцев назад

No words sir thank you so much❤️

@parthverma4396 Год назад

It is highly reccommended to watch lecture 23 video before this one, the concept will be much more clear.

@prernaarora2746 2 года назад

Thanks a lot sir for this helpful vdo ❤️

@datascience5758 8 месяцев назад

Sir example 3 mai CE+ ke attributes hai and it can be the candidate key BC->D so C->D and D-> A ,A-> B

@deepanshusharma9454 2 года назад

Bhaiya you look like KL RAHUL

@muralisvn8914 Месяц назад

super sir you are awesome ,big fan for your awesome teaching

@Status_katta18 10 месяцев назад

Sir you are so great 👍🏻

@JEE-nf1cv 5 месяцев назад

Great Explanation

@KajalKumari-cr8ee 4 года назад

Sir as u say candidate key are minimal so how we can combine AE or DE as candidate key

@legasrielumalai8043 3 года назад

I think, he said candidate key is minimal, this doesn't mean that candidate key should be a single attribute. In that example if we take closure for a single attribute it doesn't form candidate key. So we can take combination of attributes such as AE which will become our candidate key. Here AE is minimal not A.

@amit058 3 года назад

@@legasrielumalai8043 same question but I didn't get your explanation ☹️👀

@Skyvastern 3 года назад

@@amit058 In the example shown in the video, there's no attribute in the table which can be a candidate key alone. So that's why we are going with a combination of two attributes. But if there was a candidate key possible with only one single attribute, then we would have simply ignored keys with a combination of two or more attributes.

@amit058 3 года назад

@@Skyvastern oh okay thanks i got it👍

@legasrielumalai8043 3 года назад

@@Skyvastern yeah. I too tried to tell the same thing😁👍

@kchavan67 4 года назад

Worth Understanding

@avinnachakraborty7531 3 года назад

Great explanation ❤️

@yashwantbade543 2 года назад

Actually I m not interested in comment section bt watching ur videos I m not stop my self for appriciating you

@seeker_sb 3 года назад

Thank you very much Sir..... You explained it so simply and with Tricks P.S. I have final exam tomorrow

@muralinarayan610 3 года назад

Sir in the first example, A is determined as a minimal candidate key. But in any other example if we don't get a single attribute candidate key but we get a composite key, then in that case will it be considered as a candidate key?