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

0:00 - Introduction
0:34 - Example 1
5:55 - Example 2
9:15 - Example 3

► Database Management System(Complete Playlist):

Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
►Computer Architecture (Complete Playlist):
► Theory of Computation
►Artificial Intelligence:
►Computer Networks (Complete Playlist):
►Operating System:
►Structured Query Language (SQL):
►Discrete Mathematics:
►Compiler Design:
►Number System:
►Cloud Computing & BIG Data:
►Software Engineering:
►Data Structure:
►Graph Theory:
►Programming in C:
►Digital Logic:

---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
#findingClosure#Normalization#GateNet#freecoaching

[aqdasak]

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

[abhipatel]

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

[shivanshmalviya]

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

[ankitmehta]

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

[perisetlasatwik]

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

[sumitsinghachowdhury]

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 !

[madhavnandan]

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.

[sarahqureshi]

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

[Mathematics_concepts]

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

[bloom]

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.

[mukulrajora]

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

[prolaypc]

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

[bharatbhushan]

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

[ayankhana-]

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

[shivangsingh]

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.

[AbhishekKumar-kdbp]

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

[datascience]

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

[maybepriyansh]

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.

[leonatavares]

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

[priyankaghanghas]

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