4th Normal Form (4NF) | Multi-Valued Dependency | Database Normalization

[@ojuswi]

It's like a superhero movie series, wherein each movie we defeat a dependency-villain and a new dependency-villain is introduced in the sequel

[@nishantnepal4927]

11/10 imdb rating, definitely recommend to watch. Can't wait for the sequel and prequel.

[@shatabdeebala8606]

🤣🤣

[@VolatileGuy103]

dayum

[@shravanideshpande2058]

Nice one

[@rykar428]

You should stop watching too many movies

[@Metachief_X]

best normal form series in the entire youtube database...!!

[@ashwanikumar4288]

I like how they do a little recap of previous concepts. It helped me in concreting the concepts in my mind.

[@joshanderson7880]

"This isn't even my final form"

[@nicklowe_]

Nooooooooo comment of the year

[@NicksterNOC]

LETS GOOOOO

[@mainmanlobo_]

Let the Cell games begin!!

[@aymensekhri]

"And this... Is... to go... even further beyond!... uaaaaaaaaah"

[@udaykiran2427]

​@@mainmanlobo_bro it's frieza not cell

[@yasrabali2821]

After spending days for searching the right content. Finally understood what it is. Thank You so much!

[@kingcrayon195]

Its so much fun to learn with meme songs and memes and this video was made 4 yrs ago... Kudos to u sur 😀

[@Studytonight]

Thanks Akash :D

[@darwinyadav2531]

Those emoticons and images are so funny. Well Done, Thanks

[@jop2612]

Thanks for the Video, it helped me a lot 😊 I wrote a short summary for my fellow german speaking people: 4.NF: BCNF + darf keine multivalued (mehrwertige) Abhängigkeiten haben. (mehrwertige Abhängigkeit ist, wenn für einen Wert A mehrere Werte B (B1,B2 existieren) Bsp: Tabelle mit StudentID, Kurs, Hobby. Ein Student hat mehrere Kurse und Hobbys. Problem: kein Zusammenhang zwischen Kurs und Hobby. Lösung: aufteilen in mehrere Tabellen → CourseOpted Table (StundentID & Kurs) + Hobbies Table (StudentID & Hobby)

[@Irshadgbl]

great

[@jenifferdayanepereyraprinc9474]

Dankeeee

[@aldrinseanpereira140]

hey guys your videos are very well designed and i cant thank you enough for your help but id really suggest you change each slide a little slower because the slide changes really fast in your videos . its not the speed during each slide (thats manageable) but the change between slides thats a bit too fast. Thanks again

[@ghastha]

these videos are very helpfull! they help me prepare for my exam so much! thank you!

[@penze_]

this video has just saved my life - thank you!

[@madagiurgiu6951]

i need the 5th normal form for my exam. Please upload it fast. You so good with it. Thanks for information

[@estebine1609]

Succes colegu, toate cele bune

[@geoistalking]

bafta! te pwp

[@nimragauhar4838]

Did you find a good video of 5NF?

[@sourajitmitra4651]

the best video on mvd and 4nf on youtube...

[@mosa36]

Great jobs! Can't wait to get the 5th normal form video :)

[@eben9233]

You know they haven't uploaded the 5nf video since 9 months, do you?

[@vaishalinakkiran3389]

Amazing sir.. really useful for the beginners ..easy understanding with simple logics ...

[@saurabhyadav1056]

Very good presentation Doesn't get viewers bored

[@VIMALKUMARS-lo3wx]

man , I love the way you explain 👌👌👌

[@bdstech_sa]

You can explain to a two-year-old and he/she will understand you. Good Job!!!!👍

[@voxeledphoton]

I concur, I am 2.

[@ഇല്ലുമണവാട്ടി]

Let them have some fun during this age...

[@_EddyG]

Such an entertaining explanation thank you soo much : )

[@WaddupBoi]

This has been very helpful!!

[@Studytonight]

Glad it was helpful!

[@laxmiwodeyar3113]

Thank you sir I understood all these normal forms... But if you posted 5th NF that will be best thing for me bcz I have tmr exam...

[@tzahtheking]

Amazing video, Thank you very much!

[@Studytonight]

My pleasure :)

[@rosalsaini4352]

Such a great explaination, thanks!

[@kansraj877]

I am fan of youuuu . 👩‍🏫👩‍🏫👩‍🏫👩‍🏫

[@presentlymine]

this video saved me. thanks for making it!

[@jesperbergquist5383]

VERY GOOD I LIKE

[@shreyashachoudhary480]

Simply amazing.

[@Studytonight]

Thank you 🥰

[@GauravSingh-ku5xy]

Good explanation.

[@TheXBoy5]

Excellent explanation.

[@naveennaidu9768]

Awesome video!! Simple clear and precise :)

[@tanisharao0704]

loved it 😍😍😍😍😍😍

[@saivamshi7182]

sir can you explain all normal forms with one example

[@bharatigogoi2779]

How does the two rows of student ID 1 gives rise to 2 more rows?? Please explain. I didn't understand.

[@redrose5950]

Very well explained in an easier way

[@rajeshmalik3145]

Best for 4nf🙌

[@DevenderKumar-tl6qs]

When you will upload video of 5th normal form

[@urmadhu6367]

Request needed for uploading

[@mohitclassessirmohitgayabi6889]

Hello and first thanks for making this helpful video for students like us all watched all ur videos on normalisation waiting for the next 5th normal form. I also request you to pls help me with relation algebra

[@rohitmadas1300]

Thank you professor ❤️

[@max_k6209]

AMAZING VID

[@muskansharma6772]

clear understanding video ever

[@swapnilundirwade7761]

Nice Video..very clear understanding with example..thanks for making video

[@gaetanherry]

Thanks a lot

[@KiranKumar-cn7pm]

Great video!

[@theodoraroseti6429]

very good videos, thx

[@pranayghosh7912]

thank you sir

[@utsavaggarwal_ds]

like the way you teach ...good work..

[@saurabhchetthewar4521]

what about 5NF ?

[@mohammedshaikh8343]

Thanks

[@Studytonight]

Welcome

[@user-fv8im]

Good explanation 👏👏👏

[@Studytonight]

Glad you liked it

[@iamshishir.24]

Be confident enough to be superior

[@harshith_takkala]

emojis are perfectly suited😂 Thanks for the clear explaination !!

[@sangameshshavinal3940]

Super video sir this has helped me lot but you should do more videos on this

[@tonylee7797]

終於搞明白了！謝謝

[@lilianavoicu1102]

Will you also upload 5NF?

[@NIKHILVERMA-xr7lc]

can you make videos on database administration???

[@ramztech4599]

the example you have wrote is handling in 1NF multiple values for one pk is oppsite of 1NF than why we remove this in 1NF? according to 1NF the columns should be atomic if you we remove the multiple copies of data it will solve in 1NF and the S_id is pk how its possible to have two rows on same pk?

[@rahulnegi456]

I wanna know too someone reply me

[@rahulnegi456]

I think i have got it now, if this is correct In 1NF only the multivalued Dependency which are dependent to Our Prime attributes are removed such as Addresses, email etc They are dependent on each prime attributes and as well as non prime attributes too But in 4NF the independent Multivalued Dependency will get removed like in the video The hobby of any student_id doesn't depends on the course of that student course Its bit confusing damn!

[@dattatrayashinde7012]

Thnks a ton.well explained.

[@rajathongal7744]

Please come up with django tutorials and also ML model deployment in django web framework and scalability for it

[@shivam_nitian179]

ok

[@amandaram122]

Is every functional dependency a multi valued dependency? I read in a textbook about it, because I am confused how that can be? Thanks

[@anishsahu-r7t]

too good

[@DevenderKumar-tl6qs]

Sir Please make a separate video of function dependency and its types.

[@emjwey]

waiting for the 5NF :D

[@kanikasingh7340]

where is 5NF video? rest all videos are very simple to understand . nice job! but pls give 5NF video too!!!!!!!!!!!!!!!!!1

[@azharuddinkhan117]

Thank you

[@chaudiep8274]

Hi. I still dont understand why there must be 3 columns to determine the table has multivalued dependency?

[@matheusdutra5872]

I don't understand why in 3:43 do you have to decompose a 4 column table with f.d and 2 multivalue dependency. Aren't they unrelated concepts? What kind of complications would it bring if I just decomposed into two tables separating both course and hobby only.

[@singhsir8407]

excellent sir you become my idle awsm teaching method and explanation 💪💪💪💪

[@ap_nerd]

very good nice video

[@desusaivenkat4518]

What if our primary key is {a,b} and then if we have {a,b}->c1,{a,b}->c2 in our table. Can we consider this as multivalue dependency and split the table (or) is it not a multivaluedependency

[@tonyaltamura]

good explanation, it would be better with subtitles though

[@roma6220]

Could somebody explain please, why 2 rows of "s_id" and "course" will give rise two more rows in 2:38 ? Thanks in advance.

[@santprakash128]

For the simple reason that you can say here that there is a student with s_id 1 has maths as it's course and cricket as it's hobby. Suppose if you don't add those two columns, what'd be the output of the query select * from ENROLLMENT where course='Maths' AND hobby='Cricket'?

[@polasaibhargavgupta8301]

Ambiguity

[@shamshersingh9680]

Hi I have a small doubt, when you split the tables --> Table 1 with StudID and Subject and Table 2 with CourseID and Course at time-stamp 4:10 of your video, how do I get which course a student has enrolled for. To get course opted by a student, I will have to add CourseID to Student table which will always result in Multi-valued dependency. Therefore, it is almost impossible to get rid of multi-valued dependency. I think I am missing something here.

[@chetnapandey193]

thankyou

[@Studytonight]

Welcome

[@phuctrinh2589]

in 4:21 MVD does not exist!! c_id and c_course are dependent on eachother. What we have here is partial dependency. Because first 3 column is PK, and c_name depend on prime key which is c_id

[@elenagilbert1335]

sir .. after breaking the table .. I think it violates 3 rd normal form .becz... professor >subject .. both are non prime attributes....am I right

[@sherkhan_5050]

Can you please make Java programming tutorial? Also before that please can you tell me difference between java and core java?

[@Studytonight]

Hello Sher Khan, Java and Core Java are both same. Java is generally termed "Core Java" as it is the core part of the Language involved in Software development. J2EE is the enterprise edition used for Web development etc.

[@paintedbooks4416]

so in 4:20, both course id are dependent on 1 student id (both c1 and c2 depends on the s1) so they're multivalued dependency? Is this correct?

[@sajidseikh7425]

Sir, Please upload 5nf vedio

[@nadavThree]

What do you mean "a Table should have at-least 3 columns" ? i can have 2 columns and have the trivial multivalued dependency A->->B.. there is nothing wrong with it.

[@nag0074]

the cricket sound was amazing.

[@sunilahlawat2180]

Good keep it up

[@dharmikgohel2663]

How you edit your video

[@Studytonight]

It's pretty tough, as I do it by making slides for everything.

[@akratiagrawal824]

sir When will you upload video of 5th NF

[@laharireddy6971]

When do we get 5th normal form vedio. Plzz share it as soon as possible

[@anuragsinha6135]

5 NF plz

[@romeoacevedo1040]

But shouldn't the s_id be a unique identifier? It appears in two rows ...?

[@sappy2smarty]

Exactly.

[@WiseFatOwl]

Good video but need 5NF plz!

[@lolochan6645]

Thank you so much, I'll subscribe

[@kumarakantirava429]

LoL !!! In 4 years of my engineering i did not learn what I learnt in these 4 minute fast food ;)

[@Gabricardo0]

please make the video explain the 5NF

[@gayeliki6090]

👌plz 5 nf vedio

[@tammanakarthikeya6934]

sir i want your ppt of full normalisation concept how i will get that

[@bensas42]

What would the MVD be in the table at 4:21? s_id ->->c_id and s_id->->c_name?

[@zss123456789]

I don't think so, because c_id and c_name are not independent. You can derive c_name from c_id I actually don't think the example at 4:21 is a good one because s_name has functional dependency with s_id (meaning s_id is not going to have multiple s_name), and because c_name can be derived from c_id, you pretty much only have s_id ->>c_id which fails conditions of MVD (1:42).

[@mohmmadarshad2923]

Please upload 5th normal form video...sir

[@ap_nerd]

keep it up

[@AhmedGamal-om8sd]

thaaaaanx

[@sagarjain4128]

I imagine what if our actual college professor use these kinds of well prepared slides with that dogi image for humour 😂😂

[@sammysamsan8511]

Why haven't u published the 5nf yet

[@sat-yen-sen963]

nice

[@anubhavsrivastava2759]

2:21 I thought doge memes came in 2020 😂