Functional Dependency - Complete Summary & GATE PYQs | ALL In One | DBMS | With NOTES |Deepak Poonia

[@SK-qn5ry]

aspirants, LIKE it and make this comment visible to top,so it can be useful for many 19:34 imp note 46:37 Types of FD 1:10:15 rules for F.D 1:38:02 ANS : c 1:38:20 DEFINING KEys in terms of FDs 2:34:25 Inferred FDs( Inference ) 2:44:15 solution not provided 2:44:23 Closure of a FD set 2:56:46 covering 3:06:33 equivalence of FD sets 3:13:47 minimal Cover of FD set 3:23:44 extraneous attr. on LHS of a FD 3:39:48 removing a redundant FD 3:49:37 finding minimal cover of FDs 4:14:00 vvvimp words

[@Indian45528]

Sir a request you to please continue to upload complete summary of dbms nd toc like this on youtube, it is helping me a lot, I'll come to meet you after securing a good rank ❤❤

[@nintendoit-tik]

at 1:09:43 The ans should be:27 explanation: Relation: R(A, B, C, D, E) Functional dependencies: AB → C CD → E Maximum number of values for A, B, and D: Each can take at most 3 values. Functional dependency AB → C: The combination of attributes A and B determines C. Since A and B can each take at most 3 different values, there are 3 × 3 = 9 maximum different combinations of A and B. Therefore, C can take at most 9 distinct values (one for each combination of A and B). Functional dependency CD → E: The combination of attributes C and D determines E. D can take at most 3 different values, and C can take at most 9 values (from the previous step). Thus, there are 9 × 3 = 27 different combinations of C and D. Hence, E can have at most 27 different values.

[@ujjwalsingh3415]

you are legend. 4 hrs ka video kab khtm hua pata nhi chala . Sir the way you attract the students by your teaching is phenomenal. sch bata rha agar kisi aur ka video dekh rha hota 4hrs ka 4 din lag jaate aur boriyat alag hoti , but sir aap apne lectures me ek hi cheej ko itna baar repeat kr dete ki koi insaan chah kr bhi bhul nhi pata.

[@GOClassesforGATECS]

Thank you so much! 😊 Aapka pyaar hi motivation hai. ❤ Bas aise hi connected raho aur mehnat karte raho. Aapke success se hi meri teaching ka asli reward milega! 🌟

[@ArunimaMandal15]

2:44:17 option c a, b, d all follow from s1

[@tryingnaspiring]

Sir, you are a blessing for us who started preparing late. Please continue posting these summary lectures sir, we will be very grateful to you. 🙏

[@prachiarya9853]

Thanks to you sir Sir this summary video helping me alot I totally rely on this. Sir please continue uploading summary videos on each topics subject wise.

[@arjunob]

Loved this lecture! To Deepak Sir: [salute]

[@TanujaDeshpande-m3m]

thank you so much sir, your lectures are awesome,....

[@mr_anonymous123]

Thanks a lot sir these lectures are life saver 🙏

[@shashank_0807]

Note to self: We can combine FDs on LHS We can Split as well as Combine FDs on RHS

[@prafuljha9692]

Thank you sir awesome summary

[@chat-bot-s]

1:09:35 Ans: 27

[@anju-s9f6w]

answer of equivalent question will be yes they are equivelent

[@rahulpakhira2311]

deepak sir with another banger

[@SK-qn5ry]

sir, upload solutions for these timestamps 1:38:02 2:44:17

[@My-Codeword]

Hello sir, Can you also add a summary on of Normalization with PYQ .

[@faizannaseem3384]

Make a Similar Video on Indexing I will always thankful for that

[@GOClassesforGATECS]

Will do it soon. Stay connected on Goclasses KZbin channel.

[@Doitcprogrammer]

Sir 27 October se pahle DBMS ke dono topic karwa dena plz

[@DineshAgarwal-i9u]

Sir plz complete this playlist as fast as possible

[@sumaya77365]

Sir should I watch the complete Playlist of dbms or can I go with the summary lectures only for dbms what would be the best strategy possible please guide me I am bit confused what to do thank you sir ❤

[@GOClassesforGATECS]

Summary Lectures are Enough. They cover Everything, concepts, examples & many GATE PYQs.. Summary + GATE PYQs are Enough.. If you do Summary+GATE PTQs then You can skip the DBMS main course to save time.

[@sumaya77365]

@@GOClassesforGATECS ok thank you so much sir will do the same 😊 ❤️

[@biophilic-vishalkumarnisha856]

Does AB, BC both can be candidate keys in a relation R(ABCDE)

[@GOClassesforGATECS]

Yes, both AB, BC can be candidate keys in relation R.... Because none of them is a subset of another.

[@prafuljha9692]

Sir please upload normalization, transaction,indexing summary also

[@bhuvanraj630]

Please upload the solution links

[@cptn698]

Sir pls File organization for GATE DA , i never touched that topic always fear indexing and B+tree💀💀

[@GeoWatchtower]

CFBR

[@AbhishekYadav-qf2vd]

sir for transaction in dbms also

[@Utkarsh_grid]

sir when will the next summary lecture be uploaded ?

[@Ganesh_reddy99]

sir, when will go classes 2026 lectures will start

[@prachiarya9853]

Sir plz attached annotated note

[@GOClassesforGATECS]

Annotated Notes of this session: shorturl.at/fZH8q

[@229_yashbagde5]

1:09:35 solution link ?

[@ujjwalsingh3415]

27 is coming ?

[@SK-qn5ry]

@@ujjwalsingh3415 yes

[@sunstarstech2291]

after tought us fd sir be like : i am not a person i am an institution

[@My-Codeword]

Hello sir, Can you also add a summary on of Normalization with PYQ.