Lec 16: Dependency preserving decomposition in DBMS | with example | DBMS Tutorials for beginners

[@koraykara6270]

Candidate keys are AE,DE,CE and BE. Prime attributes are A,B,C,D,E So, the relation is 3 NF but not BCNF.

[@novicecoder5753]

Same answer brother

[@ujithadharshana7397]

All keys are prime attributes, so we can blindly say this relation is in 3rd nf

[@drumilakhenia4747]

@@ujithadharshana7397 but we must check for BCNF , if All keys are prime attributes

[@kumarvaibhav7203]

Yeah it should be 3NF.

[@adityabikramarandhara9477]

Same answer

[@eddiechen6389]

very detailed and well explained, thats what i call a high quality stuff

[@soumyamitra7831]

The Candidate keys are AE, then BE, then CE, then DE. So, all the attributes in the relation are prime attributes. Hence, it can be said that the relation is in 3NF. We have to check only for BCNF. None of the Functional Dependencies have super keys at its Left Hand Side, so, clearly the relation is not in BCNF. Hence, the highest Normal Form of this relation R(A,B,C,D,E) is 3NF.

[@shivampatel8850]

I really appreciate your hardworking towards us , you explained it in very well and convenient manner even I never found such a great video as well as teacher on KZbin and even in my college.

[@singanapallibhanu3844]

Thank you Madam...Because of your classes I have cleared my dbms exam

[@vijaychoudhary8864]

Very good way of teaching. Keep posting your knowledgable videos as they are helping us a lot. Thanks

[@balasubramaniantk4863]

Love your lectures, like lots of your fans, you are my Secret potion of power, Really makes the lectures more easy❤️Thank you sooo much

[@nabeelnajeeb8]

simp

[@abhishriram9211]

Thank you Soo much for ur lecture's mam ...... 😊Really you are genius mam 👍 .... Aap jaisi lecturer mere clg hona chahiye tha mam

[@khushbookumari-so8dt]

Candidate key are AE, DE, CE, BE and prime attribute are A, B, C, D, E. If all attribute of a relation are in prime attribute then it would be in 3NF. so the highest normal form is 3NF.

[@yuzo9331]

Your so smart madame I like your lectures and thanks a lot because your videos are very helpful to me👋

[@SAURAVVISHNUGITTE]

This time u taught better than Gate Smasher! , he did not cover decomposition neatly .

[@shobhitkumarpatkar5468]

Ma'am you teach so naturally that I feels like I am sitting in front of you to learn DBMS.

[@reshmateenu]

Thank u so much❤️...Really catching the clear ideas behind every topic

[@BaskarMCA-ig3ec]

For the Relation R(A, B, C, D, E) and Functional Dependencies are FD = {A->B, B->C, C->D, D->A} the highest normal form in 3NF , and the prime attributes are {A, E, D, C, B}

[@adityabikramarandhara9477]

Same answer

[@ALLT-kz5zz]

yes

[@lakshaykapoor4830]

mam your teaching skills are very good.

[@shubhambansal1495]

Mam you teach very well. So, please apply for data structures in nit delhi.

[@swapniltayade1006]

Mam You teach very well👌👏😍

[@piyushkurve457]

How did she wrote/derived the F.D from the table? Can anyone plz tell me in which video she had explained about this because i'm continuous at watching her video from the very first video of this topic. I'm talking about 2:51

[@farmygaming9609]

candidate keys are AE,DE,CE,BE and prime attributes are A,E,D,C,B . and highest normal forms is 3NF.

[@pankajmohansahu958]

Thanks Mam for explaining such a Tough concept in a well Simplified & Clear manner.

[@priyankamanna4550]

Detailed explanation of the topic🔥🔥😀

[@srinivasukurapati8778]

Thanks mam😌, your the best

[@eagle_shadow6665]

Thank you mam for making this video,you are the best 👌😊

[@dinkarmehta1445]

Really very very helpful lectures

[@udayabhi185]

Thanku mam . Mam answer is 3NF

[@dineshchanwariya9956]

Very good video for cheching preserv fd thanku mam

[@manikanthpalled2274]

Excellent teaching mam...!!

[@henimehta4927]

Awesome explanation mam!!

[@priyankapaul7077]

Ck--》 AE,CE,BE,DE AND PRIME ATTRIBUTES ARE A,B,C,D,E AND THE HIGHEST NORMAL FORM IS 3NF.✅

[@heithemdhib4709]

Thank you for carrying us the 4CHIF!

[@peppi44]

ois oke heisem?

[@heithemdhib4709]

@@peppi44 Fühl mich gecarried

[@Bickysahoo-vo5ru]

i dont have an words to appreciate you🥰🥰🥰🥰

[@ShivamKendre-fc3su]

Great explanation

[@rishikumarvirenkumarmehta9635]

Thank you Ma'am 😊

[@momentswithjireh3921]

Great lectures mam! I read in a text that a decomposition is dependency preserving if we can compute all FDs without joining R1 and R2, but here it is not possible, we cannot compute D --> A without joining R1 and R2.

[@collinseromosele8938]

the second one is also not Dependency Preserving. Good notice

[@AbdulBasit-2003]

Your vedios are excellent with full concept but it is a humble request to make short length vedios as it is quite difficult to watch whole content in exam days

[@maitridharmajumder9635]

Ck-AE,BE,CE,DE It is in 3NF

[@alrabbi6194]

The Relation is in 1NF.

[@anshuraj6455]

You are the best...

[@mohsinimam2048]

Thank you.

[@anishjoshi1999]

Thank you mam

[@shivalikagupta3433]

Highest normal form is 3NF, because NPA is null , and condition for transitive dependency is NPA->NPA . For 3NF it should not be in transitive dependency.

[@productivityaccount8274]

Nice now I can cross check my ans

[@mathsview11]

Thank u ma'am

[@milonpaul720]

The highest NF is 3NF in the relation .

[@junaidahamad3725]

ma'am please also teach ER diagram with example that topic is very important for interview.

[@adharsh7703]

should we need to understand all deeper concepts in DBMS??

[@khanaurangzeb1789]

Mam how would u divide this realtion

[@arbazzaman5090]

Respect from pakistan

[@sarathmaheshk]

luv u vadhinA

[@sanchitdeepsingh9663]

thanks mam

[@utube_int2075]

THanks a lot for the lecture. Suppose I have a dataset that has more than 20 columns. How can I decompose the dataset?

[@sowbhagyanagayasamy1782]

Thank you !

[@sureshtech2696]

ck DE,CE,BE,AE .All attribute is prime attribute then direcktly we say this is in 3NF no need to check

[@sinirajesh14]

Thanks from kerala🥰

[@tiliksew_mulugeta]

i'from ETHIOPIA...i'm here not to attend this lecture,but because of missing u my love jenny.......lov u forever

[@shumayalasabbag2052]

Ma'am how did you write F.D.(BC->A ) ....i couldn't understand , Can you plz tell me in which video you explained about this.

[@dhwaniupadhyay4727]

Mam what is the answer of this question: R(ABCDEG) F:{AB->C , AC->B ,AD->E,B->D,BC->A,E->G} R1(ABC) R2(ABDE) R3(EG) Dependency is preserved or not?

[@AmarKumar-vo2bv]

yes preserved bro

[@shyamsundar-vh9me]

Yes 👍

[@bhargavkartik7476]

The highest normal form of R is 3NF.

[@govindchavan7689]

Given example answer is Candidate key : AE BE CE DE ITS NOT IN BCNF ITS IN 3NF , 2NF , 1NF HIGEST FORM IS 3NF

[@prathmeshsharma7628]

Please make videos on Linux os

[@saakib6513]

Have you ever thought about home tutions??

[@worlddream3704]

What is that previous video that mam told in this video to derive dependency from given relation.I didn't find that video

[@piyushkurve457]

Did you? Bcoz i'm still at search. Plz share it.

[@popeyetech9634]

Just checkout the ibutton

[@Sgoose105]

pretty and teach so well

[@arpitmangal4038]

mam plz make more video on DBMS

[@BooHeeee]

this lady is CRAZY

[@anuska8513]

Hello ma'am I have one doubt..Tomorrow have my exam, please solve my doubt. Ma'am for R1 why we are not take (AC) clouser..!?? But at R2 we take (CD) (DE) (CE) clouser... But R1 we only take (AB) clouser and (BC) clouser... If I take (AC) clouser then any problem..!??

[@deepankargolait5121]

Mam please make videos on 4nf 5nf

[@sparrow_harsh]

at 4:52 why didn't you take BC->A and AC->B in functional dependency

[@sensen9235]

dude ur outfits are fire

[@Santoo2207]

It is in 3NF

[@kdineshkumar7763]

Mam why you can't find the AC+ closure

[@rohitahuja999]

highets normal form is 3NF.

[@engineering5584]

3NF

[@SHASHANKRUSTAGII]

Smile❤️

[@StevenSteel7]

Watch lecture 4 is anyone is confused in deriving functional dep from tables

[@KrishnaPandit1999]

3nf is the answer.

[@explorer3401]

What are those numbers?

[@madhupadayeswanth1865]

3rd nf

[@ahsanalikhan5704]

Tabah deya g

[@tanushrees1340]

First 😌🤭

[@nayanakb3654]

AE, DE, CE, BE ARE CK SO HIGHEST NORMAL FORM IS 3NF

[@mylavarapulokesh6472]

3rd normal form

[@dhonisingh4094]

SQL database video

[@FINANCIALYOGI]

R(ABCDE). FD(A-B,B-C,C-D,D-A). CK(as E not determined by any of attributes, AE,BE,CE,DE are CK. All attribute are Prime, therefore in 2NF. As all attributes are Primary, the RHS of SK-PA is PA for deciding 3NF, so R is in 3NF. BCNF requires SK-PA or NPA but none FD HV SK as determinants, not in BCNF. HNF is 3NF. Jesus bless U.

[@virendrapatel775]

💛💛💛💛💛

[@ravikiran8135]

Mam cutie 💓

[@tejassharma3212]

It is 3nf

[@sagarchaurasiya1324]

H.N.F.=>3NF

[@bharatletstalk]

😘

[@vasilijchenkov8856]

I love you

[@abdussamad0347]

Amazing video but you looks like Jerry from Tom and Jerry

[@crazydheeru2095]

nice to listen the class mam mam are u got married

[@Rohit_kuhar]

Khatri + lamba ? Omg you are married 😣😣😣😣

[@saibalam7852]

3nf

[@vivekpaliwal1876]

mam lgta hai aaj ap nahaaye nhi... ya fir winters me glow kam ho gaya?

[@ahsanalikhan5704]

Sedkay

[@raghavshukla344]

SPECIAL PLACE IN HELL RESERVED FOR THOSE WHO HAVE DISLIKED THIS VIDEO😡🤬

[@sasi.s.sinthu8957]

P.A(A,E,C,D,B)... no N.P.A..and the C.K (AE,DE,CE and BE) this relation in a 3rd NF bcoz, if no any N.P.A then definitely that relation it's in a 3rd NF and that left side of FD's not contained any S.K so BCNF is not possible.

[@rajneshrana6571]

😍😍😍😍😍😘😘😘😘😘😘😘😘😘

[@4subhashom]

CK:AE,BE,CE,DE ; Highest NF: BCNF, Please reply

[@subhashsandhar2018]

No it isn't BCNF bcoz A,B,C,D are not super keys (i.e) they can't determine E.

[@nikhilsindiri8497]

Don't promote white hat jr