Lec 22: How to Decompose a Relation into 2NF (Second Normal Form) | DBMS

[@ritheshs5537]

Ma'am you deserve more subscribers! I appreciate the hardwork that you put in your videos

[@sriramkrishnamurthy4473]

bhai tu bas padhai kar

[@basharTheSoftwareEngineer]

BEST EVER VIDEO SEEN IN MY LIFE THANKS ALOT

[@adityabopardekar575]

Ty so much maam for clearing my concepts in normalization ur videos are too good and very easy to understand

[@NaveenKumar-zp4sy]

I was searching ur playlist for this topic 😅 few days back..... luckily I was popped up notification .... chance less....after watching videos I am fully on love with DBMS.... every thing is clear now.... thanks mam for making it crystal clear☺️🤠...I suppose due to this coincidence I guess I have some thing to do with DBMS(research or something 😁) Any way thank you lots mam

[@mayankorigins25]

I found this channel when i was searching for implement of queue using two stack

[@ProgrammingCradle]

Hey Mam you are a phenomenal teacher... You teach concepts in really easy way... I have learnt so much from your videos... And most importantly... You inspired me to help others too... That's the reason I started my channel #programmingcradle to help people in need and contribute to the data science community. All the best to you mam and keep up the great work... ☺️

[@kamappajh3872]

At 11.52 u said R2 is in BCNF,how is it in BCNF as it doesn't have any FD to check LHS have Super key r not?plz explain mam

[@keshavchhapolia3832]

its in 3nf not bcnf coz all attributes are prime attributes

[@yoriichi7626]

​@@keshavchhapolia3832 but that prime attributes is for the main given realtion not for R2 then how can you say that all attributes of R2 are in Prime attributes shouldn't R2 have its own prime attributes???

[@naveenbabu9831]

correct me if iam wrong ...r2 is not in BCNF since determinants are not SKeys ..But R2 is in 3NF since AD - candidate key then prime attributes wud be A,D and since all attributes are PA it is in 3NF

[@amrithsebastin827]

Note: Every binary relation is in BCNF form.

[@Aakash-p7x]

R2 is in BCNF coz there's a property of rdbms that EVERY RELATION WITH JUST 2 COLUMNS/ATTRIBUTES ARE ALWAYS IN BCNF

[@NITISHKUMAR-hi5oh]

This channel is the reason I passed DBMS

[@abbaschy.9723]

11:53 Why is R2 in BCNF although there are no functional dependencies?

[@KaUsTuBh_Dwivedi]

becoz it is in prime attribute

[@Payal_Ojha]

​@@KaUsTuBh_Dwivedi I don't understand this actually, can you clarify this more?

[@Payal_Ojha]

​​@@KaUsTuBh_DwivediI need your response by today itself please respond 🙏

[@eagle_shadow6665]

I understood this lecture very well only cause of you 💫🤗

[@anveshagupta7512]

great explanation sir

[@alv1947]

Jenny you are the King 💪

[@ARPITJAIN-md3ls]

queen*

[@Sam-vl3er]

Finally here comes the prettiest lady to teach 2NF

[@domzzolanski6417]

wow jenny has improved , she now smilessss

[@pragyashrivastava8796]

Hello mam.i have a doubt in 2nd example that when u decomposed it into R1 and R2 then y u again decomposed into R3. But in ur previous example u decomposed into only R1 and R2

[@arutce6573]

To decompose the relation, you should have the common attribute between the decomposed relation to satisfy the lossless join decomposition condition.

[@sunitha2743]

in 1st one D was the only element in R2 .

[@karthick2523]

@@arutce6573 good

[@bajrangijha]

23:14 yes mam getting the same three relations after decomposing like that...but the decomposition went one more level longer.

[@60_v36]

can u explain why do we need to decompose into 3 relations instead of 2?

[@bajrangijha]

We can solve by decomposing it into two relations also but eventually the answer will be same becuase after decomposing it into two relations one of the relation is still not in 2nf. So we have to decompose that relation again and as a result we ll get 3 relations at the end.

[@60_v36]

@@bajrangijha is the 2nd relation R2(A,C,D) not in 2nf bcoz there is no candidate key? or any other reason?

[@bajrangijha]

There is a candidate key AC in the relation R(A,C,D) and this relation is not in 2nf because the proper subset of tha candidate key AC which is C is deriving a non-prime attribute D. Clearly, this is a case of partial dependency. So the relation is not in 2nf and we should split it more.

[@60_v36]

@@bajrangijha oh that was really helpful. Thanks a lot

[@anshubajaj2842]

maam you are a great help to us college students so thank you so much and can you please upload transaction and concurrency control lectures as well

[@Nishant12375]

Mam your teaching style is good . Firstly I watching dbms series by one of best teacher sanchit Jain sir, after complete sanchit sir dbms series. I still watching your dbms series and your cuteee impression 😘

[@theonlyeve28]

Good explanation. Really helpful in understanding the concept.

[@kedricktitima8146]

Excellent lecture now try to decompose a table with more attributes and tuples such as names

[@kannucool1421]

Best video for 2NF❤️

[@020jesintha6]

How did u say that R2(A,D) is in BCNF

[@pritam-kunduu]

Functional dependency set was found empty

[@godhaninisarg1570]

@@pritam-kunduu so can we say it is in BCNF ?? if iti is empty

[@pritam-kunduu]

@@godhaninisarg1570 yes

[@godhaninisarg1570]

@@pritam-kunduu ok thanks and are you from which college

[@pritam-kunduu]

@@godhaninisarg1570 iit kgp

[@shiaamganesh7819]

Great teaching🎉

[@Harshita_singh2]

hey i like ur all videos.....really helpful....n thanku mam...please also make videos on visual basic in programming....u r really great n awsome teacher

[@ghumakkad_yogi]

mam you are my lifeline for data structure and other subject also. aur pata nahi kyo jab aap padati hai to man apne aap hi lag jata hai.

[@shivanshgoyal310]

Hello mam.. Thankyou very much mam for the dbms videos.. 😃😃

[@anngrahdhar7400]

Thank you so much for such a great explanation

[@aditprabhu9601]

Thank u ✌ i understood the concept very well

[@devanshshrivastava4488]

OMG mam you are reallly brilliant , cleared all my doubts . Thank you so much. Please complete DBMS before my endsem,.

[@SaravaniJawahar]

mam please upload 4NF,5NF and more videos.......

[@sachingoel3095]

In the first example shouldn't we have (ACD) and (AB) as a decomposition, as we should separate the FD creating the problem.

[@arvindersingh9863]

I have a question madam, In subrelation R2(A,D) there is no dependency and no super key eventually. Is it even possible for a relation that it doesn't has a super key or functional dependency??

[@hardikmaind9833]

it has a ck which is AD itself . and also it has functional dependecies which are trivial. if you try to calculate the ck of the relation u will get AD as ck. since AD is ck it is also a superkey. And maam has told that if a relation has all prime attribute then it is already in 3NF and so by this fact we can aslo prove that R2 is in BCNF

[@vikranthbandi2458]

mam ,In the First Question with B and C we Cannot form a lossless join Decomposition because there is a condition what had you said that is it should be prime attribute in the following b and c there are not prime attributes

[@trickyenglish1221]

Mam really your smile is awasome I m biggest fan of Ur smile 🙏

[@KavadiHarika]

Mam how R2(A,D) is in BCNF on what condition.

[@DXRAJ07]

How R2 is in BCNF ? yeah it has two attributes but how can we say that it is in BCNF

[@lakviruperera1202]

Your explanations are simply awesome as well as your presentation

[@sruthimajhi5610]

11:52 WHY IN BCNF?

[@tanbirirfan8463]

Very informative series

[@deesubainsla7821]

mam can't we add a in r2 in second example 19:30 time frame

[@zangel_]

If i didnt see this video series before the finals I was most likely to fail. Thanks a lot :)

[@shankar1050]

can anyone say at 11:53 why the relation R2 is in BCNF.

[@deepa-nethra112]

Same question hitting my mind too

[@amaretarekegn6516]

Hello jenny🙏🥰 Why not do a vidio on Advanced Database system????

[@srikrishnabejawada3126]

I also got the same dbt bro!?🤔

[@gauravmahajan9572]

mam how R2 is in BCNF?neither R2 have its Functional Dependency nor they have any super key,so how R2 is is BCNF?

[@SaiprasadMurakonda-e9n]

The issue comes in BCNF if you have some non trivial functional dependencies and determinant is not a super key. But here as there are no functional dependencies at all(Except Trivial), there are no dependencies violating BCNF rule. So we say it is directly in BCNF.

[@yoriichi7626]

At 11:56 how can you say that its in bcnf ?? Please explain someone pls explain tomorrow i have exam end sem ??

[@naveenbabu9831]

@naveenbabu9831 no it is not in BCNF since determinants are not SKeys ..But R2 is in 3NF since AD - candidate key then prime attributes wud be A,D and since all attributes are PA it is in 3NF

[@60_v36]

Mam your videos are very helpful. Please make more videos of this playlist

[@Versa_Tube.]

Thankyou mam❤

[@anandkanil2854]

Hello Jenny. We can form r3 by prime attributes,I have seen this common factor in many tables.Is that always true?

[@Gulshankumar-yb3qb]

Ma'am you are so sweet. And your teaching way is excellent. And i also want to make KZbin channel so what i have to do. How can i grow my channel. Your suggestion means a lot for me.

[@Mandeepsingh-jo5cf]

i suggest all budies to this channel for study cs and it subjects.

[@ramyashreek8235]

In first example, to find fd for relation R1 after finding the closer set for each individual attributes, whether it is necessary find closer for pair of attributes,, if in R1 more then 3 attributes exist then how we can find closer set.

[@deepa-nethra112]

Mam how can you say R=A, D is in bcnf @12:03

[@deepa-nethra112]

@jenny mam please answer

[@mohammadshakeelahamad5367]

If a relation contain only two columns,then relation is automatically in bcnf

[@palakbhardwaj6775]

ma'am are all the concepts related to DBMS covered in this playlist??

[@ramharish4098]

Mam do you teach SQL queries?

[@gmaingwithsharif1473]

mam i have found from FD is: AB, CD, AC. plz tell me it is correct or not

[@chatterjeeishika]

what is the camera that you are using for shooting can you pls tell me the model?

[@rajninegi903]

Hello ma'am, i have a doubt in second example that how decomposition(R1,R2,R3) is Lossless as R1 and R2 don't have any common attribute. Please explain ma'am if i am missing anything here :)

[@tirtharajsapkota3149]

Hello mam. You are a fantastic teacher. But one thing "After decomposing a relation into sub relations, one of the sub-relation must contain the candidate key of the original relation. SO in the second example you have discussed, can't we directly put (AC) in R3 ?"

[@ruchiramuchhal4120]

Ok

[@healthyshorts8601]

Thanks Mam. I passed my Exams!

[@anuskakuila4177]

mam 1st example why R2 is BCNF

[@020jesintha6]

I can't understand please say how it is in bcnf

[@anngrahdhar7400]

Hello Ma'am, it is not dependency preserving

[@Local_Nerd]

Thanks

[@quinnajodanti]

yes it's lossy decomposition

[@rupalikumari5763]

Gud ma'am actually I want to know about jenny's silver and gold please reply me asap.

[@KathyD96]

in the last question, R3(A,C) results in empty set, the hypothetical R(A,D), R(B,C), R(B,D) also results in empty set. R(AD), R(BC) would be lossless since they contain A, C which are superkey for R1 & R2, respectively; while R(BD) would be lossy since it does not contain A or C. Is that correct? Any explanation/correction would be appreciated!

[@rohitahuja999]

how in first example R2 is in bcnf? for bcnf LHS must be SK

[@SHASHANKRUSTAGII]

Hi my mam. You are amazing.

[@prathmeshsharma7628]

Please mam make some videos on 8086 Microprocessor and computer graphics and stay safe at home #stayhome

[@christianoronaldo1662]

when are the videos of 4th and 5th normal form coming?

[@Mr_Suchen]

Mam how to write an algorithm of this.

[@ajaynani4079]

Madan your look iss soo good

[@sachingoel3095]

Maam, in the first example, A can determine C also thru transitivity.

[@manu-singh]

Mam space and time complexity videos please

[@jishnun.m9421]

11.56 how r2 relation is in BCNF

[@Uniquevibers944]

Same doubt

[@arvindersingh9863]

@Jineth.C Hettiarachchi but is it possible for a relation to not have any dependency and super key??

[@anshuraj6455]

SQL queries mam 🤔🤔🤔

[@harinath_mishra]

Mam pls make video on how to convert er diagram into table

[@sonukimummyrandihai966]

mam ap bartan dhulo ye koi aur karva dega mam apne jo 2 relations break karvaye hai unme bhi too PD hai ....

[@qazishahzad8774]

lovely dear

[@prabhavathib871]

Kindly upload more videos in dbms

[@suyashheera792]

Mam plz teach python

[@lalitkumarsoren5392]

Can someone say me,is this DBMS playlist sufficient for gate exam?? Please reply somebody

[@suvrojitkumarsaha8857]

No, this series covers the Relational DBMS part only. There are many more topics left which we need to study for Gate CS Paper.

[@krsh8803]

U know termux or Kalilinux or kalinethunter

[@vishalv3031]

Mam what about bcnf

[@maitridharmajumder9635]

R{B.D} R{C,D} R NOT LOSS LESS

[@AmritaKumari-fj5mo]

can someone please tell how in first example R2 is in BCNF

[@yashagarwal9067]

Ck and SK of R2( A,D) is AD so it will be in bcnf

[@anuskakuila4177]

@@yashagarwal9067 why ck is ad

[@sahil_0]

What is dbms it is related to IT

[@vanshikamehrotra8420]

Mam could you please make video by taking some mca ignou questions perspective...i m not doing gate or net and after watching your dbms videos my concepts are very clear but in ignou mca dbms questions paper.. questions are different..nd i m having difficulty in it

[@ninja-gh]

Please make Tutorials on how to design database schema for large scale project from scratch

[@pratikgupta6474]

3:30

[@indrajitpourel6507]

Mam addition two polynomials ka vedio upload kijia please

[@anshuraj6455]

🙏🙏🙏🙏

[@ShivamKendre-fc3su]

C,D and B,D are easy

[@mehedihassansarat]

I love you mam

[@rajghosh217]

Apni ma ko bhi ese hi bolta hoga👻👻

[@artgaming4271]

@@rajghosh217 I love you ek teacher ko bol Skte hain yeh UN ki teaching SE mutasir hain AP Kon hain aisa bolne wale AP apni ammi SE love nhi krte Kya?

[@rajghosh217]

@@artgaming4271 okay, but ek bar comments padh kr dekh, adhe se zyada thrki hi hain yahan. Aur bhai teachers ko I love you nhi bolta koi, cringe hota hai bohot...

[@tanzirratul9623]

R(A,B,C,D) FD:{AB->CD, B->C} can anyone solve this decompose into 2NF.

[@karthick2523]

ya it's possible in abcd+=(abcd), then cancel cd , ab+{ abcd) , ab- is super key , a+={ a} it not possible , b+={bc} b---->c then , ab+={abcd) ,then answer ab----> cd , question FD:{AB->CD, B->C} =(b---->c ,ab----> cd)

[@chakrisneelam1393]

Are you married mam??

[@whiskyvodka6564]

mam i want to meet you

[@neiljohn2637]

Doneeeeeeeeeeeeeeeeeee

[@whiskyvodka6564]

super cute

[@s2gamerzzz570]

Ap bot cute ho babu