Normalization Lecture 6A - Full, Partial Functional Dependency | Transitive FD |DBMS | Deepak Poonia

[@GOClassesforGATECS]

Annotated Notes PDF of this lecture: d2s2mc5mfsrgxi.cloudfront.net/spees/w/o/60e975430cf20278db21ff30/v/654a83cee4b02e6900eff10d/u/60f992c50cf2de5e291c3afd/p/assets/pdfs/2023/11/07/654a83cee4b02e6900eff10d/654a83cee4b02e6900eff10d_original.pdf?Expires=1699467608&Signature=lht-FLvHYkYmRfoK6-Fqr8QpRUaxBU7Z2wofxNUXKGUS44XWejfJ3F9~heMVgY19zcDreJLfK30aKwu72GK7C8eVGHX9NP4aefNo6wZubBmp8~TRqz1~y4cJ1d~b61KqfnZH1skRQD74QYs4Dh5oKSNEMscJthH1jpPMDWcFs9lBgCg2fdLQjIZCT72ezTqb2XWsvEQ5YCMSxe~Lygrl3xwJrPgk9-dUCfFstgbMW3-ORkIjpB9Q212ymXORZR2-A-7uoNIi-TvlRRlaibP8YBpVJLbnbHAi4lW4upoJf0xpKr8kNP3VpD0CLZs1TElzdp1eeVQs9XxGgK-XeffsMQ__&Key-Pair-Id=APKAJOZ4DDU7J2AXJMJA

[@krishnakumar-kh5vo]

literally today i got to know whatever i read about partial functional dependency was completely wrong... till now what i was knowing is consider FD, Y -> Z i, where Y is any subset of C.K and Z is Non prime attribute, then Y -> Z is partial dependency, which is completely wrong and it was taught by famous educator of xyz institue............Thanks a lot sir for clearing the concept in such a easy manner...

[@GOClassesforGATECS]

Glad to hear that. Please share with all GATE CSE aspirants.

[@gauravrajpurohit882]

Going with trend ... I must say... sir you are explaining like a "WOW" 😁😁😁..... You are great sir... I had done this topic in my college but never thought this can be learnt in this way. Because of you, now anything without proof is like food without swaad anusaar namak .God bless you sir.

[@GOClassesforGATECS]

Your comments & feedback always make our mood go Woww.

[@GOClassesforGATECS]

00:10:38 - Prime Attribute & Nonprime Attribute 01:08:55 - Transitive Dependency Definition in Normal Forms

[@seronic2001]

00:50:48 - can be seen as alpha is the candidate key in the relation containing only alpha and beta as attributes for fully dependent FDs, also partial FDs can be seen as super-key that is not candidate key in the relation containing only alpha and beta as attributes.

[@junaidaj7450]

Thank u so much for clearing out the misconceptions of pfd and ffd. I don't get how those misconceptions arrive in some coaching teachers when concepts are clearly written in standard textbooks.

[@gsdwiwedi6950]

Just wanna say , thank you.

[@americanSlayer]

27:40 PW sir ne bola tha, ki The left-hand side (LHS) and right-hand side (RHS) should not have common attributes in a non-trivial dependency. If they do, it is called a semi-non-trivial dependency. Please verify For example: AB->BC, AB->BCD are semi according to i have studied earlier

[@GOClassesforGATECS]

Standard Books & Resources don't have such concepts. These are Misconceptions. Must Watch this: kzbin.info/www/bejne/iYeulWyoYpiLb9Efeature=shared

[@americanSlayer]

@@GOClassesforGATECS okay sir thanks for clarification

[@sunstarstech2291]

1:10:28 idher se idher or idher se idher so idher se udher.... ☺ ☺

[@RawleyAccetta]

Just Wow. Notes PDFs of atleast uploaded videos in this playlist would be great addition.

[@GOClassesforGATECS]

Notes are uploaded in the pinned comment.

[@chandrashekarr1977]

Many thanks for this video. I have the following doubt. @15:16 non prime attributes are B and C; The following example has all LHS attributes (A, B and C) are categorized as prime attributes. How? Please clarify. Thank you.

[@lakshyarajsingh8781]

is this the first lecture of the dbms series??

[@GOClassesforGATECS]

No. This is the first lecture of "Normalization" topic. In the GO Classes DBMS course, this is Lecture number 6. Complete Normalization Playlist is here: kzbin.info/aero/PLIPZ2_p3RNHhJjQGnZB2jORa0JxLdMp4X

[@MadhavaCharya-q5r]

Pls keep lecture no 1 of dbms link pls

[@faizurrahaman377]

can I watch these videos serialwise

[@GOClassesforGATECS]

Yes, these are in a sequence.

[@बिहारीभायजी]

kzbin.info/www/bejne/iX-Ud5RnmJp-nZo I came here after test series question as someone shared the link. At the given timestamp you said, AB -> C is partial FD as A->C exists. Lets convert FD set to minimal cover new FD will be { A->C }. now there is no partial FD? candidate key is AB. We have removed partial FD then why it not in 2NF? Why it still has partial dependency?