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

Best DBMS Tutorials : • DBMS (Database Managem...
In this lecture We will learn
What is Dependency Preserving Decomposition in DBMS
How to find/check/test that a given Decomposition is Dependency Preserving or Not with suitable example.
*******************************************
Connect & Contact Me:
My Second Channel Link: bit.ly/354n7C7
Facebook: / jennys-lectures-csit-n...
Quora: www.quora.com/profile/Jayanti...
Instagram: / jayantikhatrilamba
Twitter: / khatrijenny
*********************************************
More Playlists:
C Programming Tutorials: • Programming in C
C++ Programming Tutorials: • Lec 1: How to Install ...
Placement Series: • Placements Series
Data Structures and Algorithms: https: • Data Structures and Al...
Design and Analysis of Algorithms(DAA): • Design and Analysis of...
Python Full Course: • Python - Basic to Advance
Printing Pattern in C: • Printing Pattern Progr...
Dynamic Programming: • Dynamic Programming
Operating Systems: // • Operating Systems
#dbms #dbmstutorials #normalization #jennyslectures
#dependencypreservingindbms
#whatisdependencypreserving
#dependencypreservingdecomposition
#jennyslectures

[@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

[@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 CZcams and even in my college.

[@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.

[@vijaychoudhary8864]

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

[@abhishriram9211]

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

[@reshmateenu]

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

[@pankajmohansahu958]

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

[@yuzo9331]

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

[@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

[@singanapallibhanu3844]

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

[@priyankamanna4550]

Detailed explanation of the topic🔥🔥😀

[@shobhitkumarpatkar5468]

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

[@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.

[@SAURAVVISHNUGITTE]

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

[@eagle_shadow6665]

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

[@lakshaykapoor4830]

mam your teaching skills are very good.

[@swapniltayade1006]

Mam You teach very well👌👏😍

[@shubhambansal1495]

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

[@manikanthpalled2274]

Excellent teaching mam...!!

[@anshuraj6455]

You are the best...

[@dinkarmehta1445]

Really very very helpful lectures

[@srinivasukurapati8778]

Thanks mam😌, your the best

[@henimehta4927]

Awesome explanation mam!!

[@farmygaming9609]

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

[@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

[@ShivamKendre-fc3su]

Great explanation

[@sinirajesh14]

Thanks from kerala🥰

[@rishikumarvirenkumarmehta9635]

Thank you Ma'am 😊

[@priyankapaul7077]

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

[@mathsview11]

Thank u ma'am

[@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

[@sowbhagyanagayasamy1782]

Thank you !

[@alrabbi6194]

The Relation is in 1NF.

[@udayabhi185]

Thanku mam . Mam answer is 3NF

[@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

[@mohsinimam2048]

Thank you.

[@Bickysahoo-vo5ru]

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

[@heithemdhib4709]

Thank you for carrying us the 4CHIF!

[@peppi44]

ois oke heisem?

[@heithemdhib4709]

@@peppi44 Fühl mich gecarried

[@anishjoshi1999]

Thank you mam

[@maitridharmajumder9635]

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

[@oshadhaedirisinghe1455]

Thank you

[@Sgoose105]

pretty and teach so well

[@khanaurangzeb9606]

Mam how would u divide this realtion

[@saakib6513]

Have you ever thought about home tutions??

[@milonpaul720]

The highest NF is 3NF in the relation .

[@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

[@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

[@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?

[@junaidahamad3725]

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

[@sanchitdeepsingh9663]

thanks mam

[@adharsh7703]

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

[@arbazzaman5090]

Respect from pakistan

[@sarathmaheshk]

luv u vadhinA

[@arpitmangal4038]

mam plz make more video on DBMS

[@prathmeshsharma7628]

Please make videos on Linux os

[@deepankargolait5121]

Mam please make videos on 4nf 5nf

[@tiliksew_mulugeta]

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

[@bhargavkartik7476]

The highest normal form of R is 3NF.

[@SHASHANKRUSTAGII]

Smile❤️

[@virendrapatel775]

💛💛💛💛💛

[@sureshtech2696]

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

[@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.

[@sparrow_harsh]

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

[@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

[@ahsanalikhan5704]

Tabah deya g

[@Santoo2207]

It is in 3NF

[@BooHeeee]

this lady is CRAZY

[@tanushrees1340]

First 😌🤭

[@kdineshkumar7763]

Mam why you can't find the AC+ closure

[@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..!??

[@govindchavan7689]

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

[@mylavarapulokesh6472]

3rd normal form

[@sensen9235]

dude ur outfits are fire

[@bharatletstalk]

😘

[@engineering5584]

3NF

[@explorer3401]

What are those numbers?

[@nayanakb3654]

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

[@madhupadayeswanth1865]

3rd nf

[@rohitahuja999]

highets normal form is 3NF.

[@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 👍

[@krishnakantbhardwaj6250]

3nf is the answer.

[@dhonisingh4094]

SQL database video

[@ravikiran8135]

Mam cutie 💓

[@StevenSteel7]

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

[@rajneshrana6571]

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

[@tejassharma3212]

It is 3nf

[@vasilijchenkov8856]

I love you

[@saibalam7852]

3nf

[@sagarchaurasiya1324]

H.N.F.=>3NF

[@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.

[@vivekpaliwal1876]

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

[@ahsanalikhan5704]

Sedkay

[@crazydheeru2095]

nice to listen the class mam
mam are u got married

[@raghavshukla344]

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

[@Rohit_kuhar]

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

[@abdussamad0347]

Amazing video but you looks like Jerry from Tom and Jerry

[@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.

[@nikhilsindiri8497]

Don't promote white hat jr

[@raghavshukla344]

KUCH SAMAJH NAHI AAYA MUJHE, VIDEO DUBARA DEKHNI PADEGI🤦‍♂️,AAP ITNI SUNDAR KYON HO?????