5th Normal Form (5NF) | Join Dependency | Database Normalization

[@shivanidas9676]

You are amazing! 😄😄Thanks for making me laugh while studying.. Cuz I was so in stress 😁

[@anushree4681]

Please make a video with more examples. 5NF is very confusing. The previous normal form videos are excellent.Thank you!

[@avishekgazmere6868]

Epic memes. I've never laughed during a ed video. Good job!!

[@RahulSharma-sb3uv]

seriously

[@aadjxx]

I don't know any of those memes! And that's how one realizes s/he's getting old... :O

[@lukemeir2630]

Never understood 5nf, until this video - this was explained super cleanly ty v much!

[@apurba_debnath]

Roses are red, Violets are blue, Our professor teaches us from KZbin, What about you?

[@user-iu3fy1qn4p]

😝

[@twig_e9425]

How to: Easy way to teach student

[@aadjxx]

Red is the rose, Blue the violet If we table this prose, It all forms fulfilleth. | Plant | Color | |-----|-----| | Rose | Red | | Violet | Blue | Doesn't it? 😏

[@ishaansrivastava4627]

Thanks, I'm confused.

[@DDtwerty]

🤣🤣

[@ujefmalek77]

Why ?

[@explorer2375]

🤣🤣🤣🤣🤣my god... Then y u r thanking him dude🤭😅😅😅🤣🤣

[@jababababbaba]

@@explorer2375 r/whooosh

[@alrodarnold]

Confused or confuse

[@Kumkum_2006]

STUDYING PROPERLY WITH OUT GETTING BORING.THANK YOU FOR MAKING THESE KIND OF EDUCATIONAL VIDOES.

[@farshad-hasanpour]

So as I understand: - If the main table can not be recreated (i.e. join dependency does not exist) it is in 5nf and should not be decomposed. - And if the main table can be recreated (i.e. join dependency exists) we should decompose it to be in 5nf. am I correct?

[@Studytonight]

Yes absolutely. But that did confused a lot of viewers. Fifth Normal form is very use-case specific. And if you have never designed any database for any app/website, it can become a bit difficult to grasp. Merry Christmas :)

[@lekshmig8322]

Thanks a lot😊

[@brahamaggarwal1800]

Thanks man

[@russeldebbarma457]

Thankyou bud;)

[@ishikabaliyan41]

in short it should not have join dependency and if it has decopose the table in loseless decompostion way so no join dependency and loseless join decompostion

[@sheetaljain4288]

Thanks sir, really I got the 5NF as well as one more thing why it is important to study each concept from each and every corner. While Studying ER diagram theory I never expect that it would help me in such a way .

[@kumarakantirava429]

Hey Master Blaster... It was both Illuminating and fun watching these normalization videos !! I am more confident in my DBMS now.

[@yudianantha4549]

Guys just focus on this. there is a join tables. if we break that join tables and there is a lost information, then it was a join dependency. then we have to do 5NF. You sir are the best at explaining the concept, thank you

[@habibbialikafe339]

nah man, that's when join dependency DOESNT exist

[@aydict]

The truth is exact opposite of this

[@adityamandal2560]

@@aydict Does it mean that when we break the table it cant cover all the fields because there was join dependency. until we break it was right

[@jeeveshsingale3569]

Your content is really very good. I saw all the Normal Forms from your channel and literally understood everything but 5NF was really a bit confusing.

[@Studytonight]

Ok, will work more on this video then. Thanks for your input and Merry Christmas :)

[@kunalgupta116]

Engineers are in need of, such kind of to the point videos.

[@ResolveX11]

Just finished the series, great work ! although these videos are almost 2 years old the memes are still alive. These videos were very helpful thanks for making them.

[@Studytonight]

Glad you enjoy it!

[@paulsnehasish5830]

this type of education we need...where teachers are being funny while teaching :D

[@sarthakvarshney9726]

Amazed by this extra-ordinary explanation....well done💯💯

[@Studytonight]

Thanks for the comment.

[@fightforfitness2256]

This was hard to understand but after watching it two times finally I got it. Thanks.

[@neerajmahapatra5239]

The way u edit is awesome yaar😂😂

[@tasmimferdous7051]

Thank you for all of your videos. It's helpful. Is it possible to show us an example where aTable has join dependency and should be decomposed? That will be very helpful.

[@arjunapple7454]

Thank you 👏. I am able to understand the Normalization concept ✌. I have created the DB tables to learn SQL and T-SQL. However, I am not able to fetch few records even-though data present in it also query is satisfying the conditions 😒😒. Post observing this video I altered the table with the help of ER diagram. I recommend viewers to practice and think practically to understand the Normalization concept.

[@tanisharao0704]

loved the series😍😍😍😍

[@ShwetaSingh-gz9ds]

Awesome... Never knew study material can make me laugh

[@NathanArant-f6l]

This was clearly taught. Thank you! How does one quickly discover whether breaking down tables will result in a loss of data?

[@BalajiGanesh-zr3ny]

Saw all the Normalisation videos. You are fantastic. You teach better than my college profs. 5th NF you explained negative case of when not to decompose the table. Can you explain positive case, of when you can decompose the table?

[@Studytonight]

Ok, let me come up with an example and share.

[@yashvigajera8648]

The vedios are so easy to understand than lectures!!!

[@Studytonight]

You should check our website too, studytonight.com

[@ashthorat9649]

It literally saved my exams, Thankyou soo much!👍

[@mimis.5139]

Got to say this... the humour in every content really calms down the exam stress....😁

[@GiDaOne]

Great series about the normal forms. First time I really understood them clearly. Thanks for your service to humanity :) Subscribed

[@Studytonight]

Glad you like them!

[@colorfastimages6186]

Thank you so much Sir. Your videos are really helpful

[@JakeShuf]

Very nice explaination of the topic. My textbook is far too formal and precise in definition to make understanding of the normal form concepts.

[@Studytonight]

Thank you 😊

[@MohdRashid-hi7cp]

Awesome explanation which I have ever seen on youtube about 5NF, thanks bro....

[@akashpurushotham2278]

Great Explaination, Thank You So much Brother

[@wittyskitty]

I think this helps to understand better: Let's say both sellers S1, S2 sell products P1, P2 and user U1 uses P1, P2 and U1 buys from S1, U1 buys from S2 also. Now to Join the tables(recreate the big one) we can't say whether user U1 bought product P1 from S1 or S2, since both sell P1 and U1 buys from both S1 and S2. Hope it helps, thank you.

[@KollaBabu05]

You are awesome.. Never felt better.. Please don't stop making videos!

[@rohitk9221]

For all other NFs, I have made notes from your videos. But for 5NF, I have mentioned "watch studytonight video" in my notes.

[@srilekha2231]

Hello sir... Please make a video on Lossless join and Dependency preserving decomposition.

[@sajidfaruki8054]

This normal form makes me more confusion 🙄 and previous normal form is good and better explanation thanks u

[@abdulazeez3924]

True learning with enjoyment 👍👌

[@Studytonight]

Thank you :) Checkout our other videos too and please Subscribe :)

[@zerosolution115]

Amazing lecture ,thanks a lot Pls make video on other topic as well That would be so helpful for students

[@Studytonight]

Other topics like? Please share, and I will definitely try to make videos on them.

[@zerosolution115]

@@Studytonight all dbms topics

[@Studytonight]

@@zerosolution115 Ok then! I will get started with it :)

[@ShashankSingh-lc6qc]

I was waiting for this, today is my exam 😊.

[@super13ASHU]

Studying in CU?

[@ShashankSingh-lc6qc]

Bro RU

[@three-eyed6328]

back aayi ? :P

[@GurleenKaur-vs5jw]

Thank you🙏

[@rashmiag800]

Lol..memes between the actual educational content! AMAZING :)

[@skmasudreja6620]

Love the way u teach, its fun

[@ahadilyas1950]

How to decompose? Is there a specific method or constraint?

[@sreekanthrgunishetty3778]

BGM at 4:57 So Emotional but I laughed like hell🤣🤣

[@dalskiBo]

Thank you, the best tut's on this subject

[@devikareddy7720]

Great explanation 🙂 thank u sir..

[@pravinnikure1372]

Explain in detain and simple form sir. Thanks

[@AD-hb6zl]

Very well explained! Loved watching this! 🤣🤣♥♥

[@harikalakshmisainannapanen181]

You r amazing. Thanks a lot🙏🙏🙏

[@Studytonight]

Most welcome 😊

[@littlethings2250]

So finally I understood db normalization. Can you please create video for db joins as well?

[@prudhvi4921]

Hi!! I really loved your explanation👍👍 but can you do a video of 5NF a more little detailed with some more examples

[@Studytonight]

I will try!

[@s-w]

In fact, using only the data you provided, you CAN imply that ACME sells the 72X SW to Ford, but as soon as Ford purchases a 72X SW from another supplier, you can no longer imply this. You cannot, however, imply which supplier provides an OBD II to Mercedes.

[@5warag]

This is like watching a web series and having a cliff hanger for second season.

[@dhaneshpt8641]

Thank you sir.

[@krishnabala8403]

Good example. Thank you.

[@parthpandya7565]

nice teaching

[@tapaskumarnandi507]

Can u bring question on determining the highest norml form of a given database

[@khushaloli9700]

Thnku for confusion

[@midhunrajr372]

bro you are epic.

[@thanujakollipara3887]

Thanku so much sir,ur videos are really amazing and helpful

[@ranganakumar2129]

Lossy dependency and loss less dependency are two divided stages from join dependency.in lossy dependency ,if we join both table a and b we get some redundancy or may data losses but in case loss less dependency the data can't be lossed and redundancy occurred.

[@furqanabdulkhadarramadurg4201]

Best way to teach especially with memes XD

[@sankalpchandalia1740]

Awesome content👌🏻

[@anshu893]

So, when my decomposed table cannot standlone can provide some info of the attributes that are in the table but requires to join together to make sense is join dependency. ( Did i make any sense here) so they needed to be joined to draw conclusions. Did i get it right or missed something. Please reply sir Thank you, love your videos.

[@rouslanngouyamsa9055]

I am very thankful for your explanations. But i am a bit confused. I understand that if breaking the table leads to information loss, we shouldn't do that. But in the case of information creation ? Logically it's the same but can you please confirm it ?

[@saiharikrishnansitb4049]

how these qns will appear in exam? like directly "do a table for all nfs?" or like any twisted way?.. if asked what to write and how much should we write for 16marks(i get it for 16m)?

[@abirhasan1620]

then what about 4NF condition? Multivalued Redundancy is not preserved then :/ ; can you elaborate please ?

[@Soumen110]

Can you please explain "Inclusion Dependency" and "DKNF", your teaching is awesome, Thanks

[@riverlance9647]

ye konsa naya normal form nikla bhai

[@prashantsharma6870]

Definition of Normalisation in hindi Meri Ek taang nakli hai, Mai hockey ka bohoth bada khiladi tha. Ek din Uday bhai ko meri kisi baat pe gussa aagaya aur mere he hockey se meri taang ke do tukde kar diye. Lekin dil ke bohot ache hai, Fauran mujhe hospital le gaye aur ye nakli taang lagwayi.

[@rupikasrivatsav8232]

Awesome.❤

[@MrRoubleh]

thanks a lot

[@MrJREX-vk9dm]

Dear Sir, Yor are explained first class. I have a doubt, What is the problem we have in the original table? If we have any problem only we can decompose. And give the example for no losing information after decomposing in 5th normal form.

[@thibautmartinet6197]

Could we summarize the 5NF by the following : "The table should be in 4NF, and only candidate keys of the table should have independant dependencies to more than one column." ?

[@fb_a]

which software did you used for making the video sir!

[@tianafad4808]

Thank u sir. Please can you do a video on crash recovery?

[@raunakgupta5528]

Is there any 6NF or 7NF also exists?

[@Studytonight]

Nope. Ain't 5 more than enough :D

[@qhubbles]

Ok. So, I have a big table that should comply with the 5NF. If I want to go this far, should I redesign it for each normal form until I reach the fifth?

[@nasratt]

I think so because each higher normal form builds upon the lower normal form.

[@adithyankrishnamoorthy6129]

Can you upload another video for 5NF with new example?

[@subhashkumarranjan8492]

Confused weather studying by a very good teacher or watching comedy video.

[@Studytonight]

Why is that so?

[@arshanjada2985]

Best video

[@vaishudolly5916]

I am totally confused on watching 5 NF

[@lenin_26_b]

Lol they didn't replied

[@therishabhdhiman]

@@lenin_26_b And the best part was that she didn't even bothered you.

[@ssswayzzz]

cant we create a table for supplier to customer such that includes financial information related to debit and credit using business adminstration methods ?

[@zorojuro5106]

thanks

[@ChadWeaver]

What about an example that is 4NF but not 5NF?

[@SK-qm5py]

I understood all the other normal forms but this one. 5NF is complex.

[@vrashankraom]

ACME is related to 72x sw and Gear L . The table has 3 columns. then why is it in 4th normal form?

[@2.0-o7p]

how to check whether division is lossy or lossless

[@babythedude]

so. Why we need a 5NF? Is there some problem 4NF cannot solve?

[@travelbloggers9592]

A->B B->C A->C should this hold good for 5NF

[@anishagoyal8342]

I am confused 😃so I can't explain in exam 5nf 😇

[@soonapaana24]

YOU ARE TEACHING ME, YOU AREN'T SUPPOSED TO MAKE ME LAUGH LIKE THAT!!!....or can you...looks like teachers also have a good sense of humor, we just haven't seen a lot of em' yet.

[@raindeca111]

Ok, let me give this straight....(correct me if it's wrong) If there is a 4NF table which is actually can be decomposed into separated tables and while we try recomposed it again into one (by using join operation), the joining table and the original table are same (true) that's mean the table (The 4NF table) doesn;t meet 5NF criteria ? So: If 4nf > can be separated that's already violate 5NF rules ?

[@saramanaf715]

Did you get it. After one week

[@raindeca111]

@@saramanaf715 I've been searching on Google and this is my current answer for now

[@saramanaf715]

@@raindeca111 it is just so confusing

[@Anagha_VK]

Plz upload videos on transaction..

[@padaderaju8907]

Sir can you explain 5NF with join dependency

[@sophanithphon]

Is there 6th normal form in the database ?

[@Studytonight]

I don't think so.

[@madhushibandara3869]

Best

[@chai166]

Subscribed at 4:58 ahahahahah thank you sso much for the video please make more!! :D

[@sravyahadassaanakari7034]

Can I know how data was lost in the example you have taken in a lecture video

[@pranavmandala1465]

Im confused , I dont think the given table is in 4NF before moving to 5NF as it has multivalued dependancy example: 1 supplier can have more than one customers and more than one products Your explaination so far was very nice..this alone is not understandable please help me out

[@sabyasachinanda366]

In the given table with 3 attributes there is no multi-valued dependencies. Please recollect, for a table with 3 attributes (say X, Y, Z) multi-valued dependency arises if X->-> Y, X->-> Z and Y& Z should be independent. However, in the above relation, all 3 attributes are inter-related (i.e. dependent on one another)...Supplier selling Products, Supplier selling to customers and Customer buying products. However if suppose we have some relation like Roll no, courses_enlisted and hobbies for a group of students, then there is no relationship between course_enlisted and hobbies adopted by students. In such case multi-valued dependency would exist and the table can be further decomposed into 2 discrete tables to achieve 4th NF. The table above however has no MVD.