Lec 4: Functional dependency in DBMS | What is functional dependency | Database Management System

In this lecture I have explained functional dependency in DBMS with proper example. Here you will find simplest explanation of functional dependency in DBMS.

See Complete Playlists:

Connect & Contact Me:

#whatisfunctionaldependencyindbms
#dbmsnotes
#ugcnetcomputerscience
#gatecslectures

[johnkevin]

I've had 2 three hour lectures so far on this topic and didnt understand anything there. And after 25 mins here I basically grasped everything. Thank you very much for this video!

[shyamaharihar]

Wow, could not understand anything in college but here just 20 mins and the concept is very clear great effort :) Thanks ma'am

[billkabb]

Just started watching DBMS and since im from greece im very glad you are doing all this great work in english . I wish you the best .

[c.danielpremkumar]

Excellent ! I have never seen a video so far which explains "Functional Dependency" in such a simple way. I wish I had this facility 30 years ago.

[jeanrioux]

1. OK, all x different.
2. OK, all x (combination of Dept, Course) are different.
3. OK, all x (combination of R. No, Marks) are different.
4. No, Name a can correspond to 2 different courses (C1, C2) and name b can correspond to C1 or C3.
5. No, combination of (a, 78, CS) which is x can correspond to R. No. = 1 or 3, and (b, 60, EE) can correspond to R.No. = 2 or 4.
Be sure to understand that at the left of the arrow represents x. Do not decompose the combination when analyzing a F. D.

[achinS]

I'm from Mechanical Branch, but the way you explain DBMS is outstanding. I mean, it's really easy for me to get those things in my head, when you explain.
Thank you so much Ma'm !!!
I really appreciate your way of teaching !!! 🤟

[Uzair_Anwar]

1 Roll no --> Yes
2 Dept, Course --> Yes
3 Roll no, Marks -->Yes
4 Name --> No
5 Name, marks, dept -->No

[saranyas]

1. RNo ->Name, marks✔️
2. Dept, course -> name ✔️
3. Rno market -> Dept ✔️
4. Name -> course ❌
5. Name, marks, dept ->Rno ❌

Thank you mam ❤

[collinkruger]

I very much appreciate these lectures. I am currently going through graduate school, and this is far easier to understand than my database book while also covering the exact same concepts. Thank you.

[yeus]

Literally the only video on youtube that explains functional dependency consisely. Thank you.

[abhinavsharma]

Brilliant.
I recently joined my job after campus placement as dwh engineer. I am from ece and not cs, your videos are extremely helpful before i get on learning about data warehousing.
Thanks a lot for spreading knowledge in clear and concise manner!!

[samsons]

For the exercise in 25:34

The answers are :
1) Is a Functional Dependency (FD)
2) FD
3) FD
4) Not a Functional dependency (NFD)
5) NFD

Remember 1 thing :

For 2 tuples t1 & t2 in R
If t1.x = t2.x
Then t1.y = t2.y

For an FD,
▪︎ If first condition for FD holds, then second condition must & should be true..
▪︎ If first condition itself is false (as is the case for exercise probs 2 & 3 above), then by default it's a Functional dependency.(Check example in 14:52 for this)

[zul_afluz]

Your technique of bringing out the explanation in a simpler and an understandable way is incredible Mam. Keep the good in you 🔥

[reemaborashed]

This is the simplest and most understandable vid I've seen about functional dependency!! Thank u for this great explanation

[muhitshakir]

Hello Mam, I'm a CS student From Bangladesh.Your Explanation is really amazing.Properly understand this topics only in 20-22 mins.God Bless Mam.Stay Home, Stay Safe.Love from Bangladesh

[amitavbapi]

Great lecture. Pls keep posting like this tutorial. your way of teaching and your presentation skills are far better than many professors in USA.

[sergejnorski]

Its clear now that im functionally depending on these videos to pass my exam, thank you 🙏

[milandorjee]

Mem please make the complete video of DBMS, I really want to take this blessings from you ❤🙏

[deepeshnair]

Thanku so much mam u have started with dbms, it's my project time, aap hamesha correct time par aate ho!!😁😁

[kohlmethven]

Thank you! I'm only half way through the video but it's already making way more sense then how my online course was teaching it. They were teaching X -> Y should be read as Y is dependent on X, which is true but for someone learning the concept reading it as X determines Y makes it much more clear.