Functional Dependency in DBMS | Normalization| Candidate key |Minimal Cover | UGC NET PYQs on DBMS

[@anilaala5080]

Thank you so much mam for this type of precious videos.

[@jitenderyadav871]

Thanks mam for explaining complex topic in such an easy way.

[@babuanshid2782]

Question no 40 how it will be in 3NF keys are AEF ,BEF and DEF which means it can derive all attributes AEF->AEFBCD now in FD A alone gives B so there is a partial FD right?

[@MrSumanhalder]

I have question, we can also remove BC->D; by using F: {A->BC, D->E, A->D}, closure of A will be {A,B,C,D,E}

[@sasisathiya4155]

A -> D . Prime attribute -> non prime attribute. How it is 2 NF

[@unifystudy.Priyanka.Chatterjee]

Tell me with video timestamp

[@unifystudy.Priyanka.Chatterjee]

A is the candidate key itself. It's not a part of CK. Prime means the part of CK. So A to D mean left side is CK don't be confused as prime.

[@unknowndragon2008]

@@unifystudy.Priyanka.Chatterjee Thank you ma’am 🎉

[@sastrymatam5268]

Thank you madam

[@DhivyaprabhaTT]

thank you so much mam

[@jyotibajaj5748]

25:19 a->bc prime to non prime is given, then how in 2nf?

[@Ruby..R]

Nice explanation mam..

[@sharma7352]

Thanks a lot for the useful session mam. 🙏🏻🙏🏻

[@pushpabtech]

Super mam

[@nidhiverma6056]

Nice explanation ma'am 👍

[@bhuvanavinodh3498]

Very nice and easy way.... thank you so much mam....SQL short video pl

[@unifystudy.Priyanka.Chatterjee]

Please check th-cam.com/users/liveipFUZFTKv6U?feature=share

[@ashwinibhoyar9225]

Very well explained mam... Thank u ❤

[@ramyak-zc1fv]

Thank you mam. Very clear explanation

[@unknowndragon2008]

Superb ma’am. Keep rocking

[@sherilys8992]

Tq mam

[@indumathikarthikeyan7708]

Thank u mam,it's very clear

[@dr.s.arumugadevi417]

Thank you mam

[@sapamdushanta9244]

good

[@a.christyselvi7733]

Thank u mam .

[@malitadeka2520]

Thanks mam

[@gdpraveenkumar823]

If possible to provide the cheat sheet for normal forms with lhs and rhs all normal forms .from questions to questions your explanations aren't clear. ...

[@babuanshid2782]

LHS super key cannot prime attribute so E->C not in 3NF in question 40

[@Tulika-id4hv]

Yaa I 2 hv same doubt....it Sud b 1nf

[@Tamil21siva]

Thank u mam ❤

[@anithamurugesan32]

Mam 4th que u told not in 3NF ....d to e.....but in bcnf 29:46 ....

[@anithamurugesan32]

If in bcnf then it must be in 3nf also.....u told not in 3nf..d to e...confusing

[@cropcatalyst396]

How to find prime nd non prime

[@sasisathiya4155]

Mam I have one doubt

[@unifystudy.Priyanka.Chatterjee]

Yes tell me

[@unifystudy.Priyanka.Chatterjee]

A is the candidate key itself. It's not a part of CK. Prime means the part of CK. So A to D mean left side is CK don't be confused as prime.

[@elavarasim2711]

Thank you mam