Fully Functional Dependency, Partial FD, Transitive FD and Trivial FD | Database Management System

To ask your doubts on this topic and much more, click on this Direct Link: www.techtud.com...
IMPORTANT LINKS:
1) Official Website: www.techtud.com/
2) Virtual GATE: virtualgate.in/...
Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share!
Our Social Media Links:
Facebook Page: / techtuduniversity
Facebook Group: / virtualgate
Google+ Page: plus.google.co...
Last but not the least, SUBSCRIBE our CZcams channel to stay updated about the regularly uploaded new videos.

[@emilyreed4586]

Taking an online class and it helped to hear this explained in different words. Thank you!

[@dixingxu]

You explain better than my school teacher! Thank you!

[@Forestadash]

I have a database exam tomorrow, your videos are really helpful, wish me luck!

[@pinkinandi7677]

Had you passed or failed in that?

[@Forestadash]

@@pinkinandi7677 Passed, thanks! Now I'm a happy full time developer :)

[@_raj_preet_choudhary7193]

@@Forestadash 😁😄

[@RafayKhanfy]

Please give examples on real life scenarios.
Thanks

[@LaKillingFrenzyy]

No.

[@bhaskarjat6160]

@@LaKillingFrenzyy LOL

[@dead7709]

short, concise and clear

[@collegestudy5977]

One of the best explanations as always..

[@naharulhayat]

you are a hero techtud....thank you for this

[@Bryan-eg7si]

Thank you , you explained this very well

[@shivamsrivastava1646]

confusion in fd nd pd, in the first example for fd, ABC→D, meant that D cant be determined by any of A B C, and then in second example, AC→P; Then A→P, how? As u told earlier tht A C cant be determined by P, according to first example of FD

[@satishkumar-wf7ml]

A->D and D->P so in this case A->P ..... Here A is a subset of AC , So in this case it will be "pd"...

[@hemanegikhatri6075]

Shivam Srivastava # it means, D only determined if all three set ABC will present( thats why he said, A cant individual determine D, B cant individual determine D, C cant individual determine D) that is fully dependent, all three should be present.
In second example P is not fully dependent on AC, here P determined by A individually bcz there is transitive FD A->D, D->P so A->P

[@yarmuhammadhafizy8559]

thank u brother .... i perfectly understood

[@RahulKumar-zj9qk]

Really helpful

[@mohammadabubakarali8882]

Amazing 👌

[@czy5111]

That's why i love youtube Indian guys

[@gokulnaathbaskar9808]

Thank you so much!

[@akhilvishal331]

I really understood clearly bro.........gud job....

[@prernaarora2746]

Thanks a lot for this helpful vdo ❤️

[@loganbala1450]

Thank you bro.Keep upload more videos.

[@priyasharma7107]

thank you you explain it very easily

[@nashcx4202]

Thank you for saving my final.

[@bobino4646]

Helpful. Thanks man.

[@mausamikumari7505]

Thank you

[@muhammadsafiullah8428]

Nicely explained!

[@I-believe-in-humanity]

Good JOB Bro

[@deleteaman]

I am having troubles figuring out what kind of dependency this is
B exists only if A = special
B does not exist if A = nonspecial

[@shaurabhbhatt3768]

thanks thank you sooo much.............

[@swatisingh7687]

in 3 example A determines p which is the subset of AC then how is it a fully FD .explain plz?

[@mayukhbal1944]

P is NOT fully FD ... he said "NOT"...

[@shabinakaifi2742]

nice lecture...........

[@myfirstchannel9396]

plz post a video of Inclusion Dependencies and Template Dependencies...

[@swpanilyeole8477]

nice explain

[@aditi-ind]

thanks!!

[@how2tech403]

In trival FD A->A can't be trivial .

[@dkdheena8188]

why?

[@Dpanwar100]

Why

[@nikkimehar842]

can anyone explain.... what is A+(A closure)?

[@srishtisingla2105]

u spoke opposite sentences for partially and fully dependent functional dependencies

[@MuhammadAurangZebkhan-cx1ez]

great

[@NitinKumar-sq1wp]

Nice Lecture. (y)

[@pranavdeshpande9675]

pls make it understand properly about fully functional dependancy

[@akashkanteti6964]

did he said about partial fd

[@mansoobali7369]

plz use comman example

[@ervikrantyadav]

good

[@vyshnavib8023]

Tqq sir

[@anandchandaluri4664]

Not understanding Trivial FD, X subset of Y means it is Purely Relflexive property but you once again telling same as Tivial FD

[@MrDavidFitzgerald]

Lifesaver

[@sharifukitori239]

4:54 incorrect definition of subsets...the sign and whats you are saying are irrelevant

[@dishendra.]

yes, he is using the symbol of subsets and calling it proper subset.

[@SonuSingh-ip6qe]

Partial FD explanation required

[@fluorescent_axolotl]

Thanks for not mixing English with Hindi

[@abdullahalmatin1175]

What is A closure?

[@harikrishnanr4808]

Closure of A means the set of attributes determined by A.
Here, the attributes determined by A are A, D, P.

[@madhavsolanki8499]

gajabbbbbbbbbbbbbbbbbbbbbbbb

[@comp_codercode_it7020]

+Madhavsingh Solanki ganduuuuuuuuuuuuuuu

[@satishkumar-wf7ml]

anyone explain Trivial FD??????????

[@hunterburk9402]

This guy has the nicest nails.

[@Nazirov1991]

Please buy a better microphone!! Voice quality is terrible. Content is good though

[@mohammadfahad9102]

sorry to say but you just made a very simple topic look much typical , try to make it easy to understand for a layman using real world scenario , bookish language is available every where

[@rukhsunaraparvin8589]

Don't understand

[@shahrahul5872]

Okay boshda coooll

[@victoriaatasie5730]

shave the hair on your fingers so that your video becomes more presentable..........just advising

[@ankita3320]

explain properly by taking some real examples of relations

[@yashgupta2394]

+Ankita Sharma why don't you do that instead of talking only . if someone has put a effort appreciate it !!!

[@koustubhubhegaonker1306]

+yash gupta That is called a feedback instead of just blabbering about the video. Get your social etiquettes first.

[@deepankarsingh7230]

@KOUSTUBH UBHEGAONKER This not a feedback or request. It looks like an order. Please learn what all things come under social etiquettes then respond without being biased.

[@VONisHope]

@Deepankar Singh The definition of feedback: " information about reactions to a product, a person's performance of a task, etc. which is used as a basis for improvement." Ankita's comment is a valid feedback idiot.