4th Normal Form (4NF) | Multi-Valued Dependency | Database Normalization
Вставка
- Опубліковано 8 лип 2024
- For complete DBMS tutorial: www.studytonight.com/dbms/
In this video, we will learn about the 4th Normal Form and Multi-valued dependency. Multi-valued dependency is a little tricky to understand, but we have tried to explain it with multiple examples. We have also covered how you can decompose a table (relation) to make it satisfy the 4th Normal Form.
Introduction to Normalization: • Basic Concept of Datab...
First Normal Form: • First Normal Form (1NF...
Second Normal Form: • Second Normal Form (2N...
Third Normal Form: • Third Normal Form (3NF...
BCNF: • Boyce-Codd Normal Form...
Fifth Normal Form: • 5th Normal Form (5NF) ...
If you LIKE this video, give it a thumbs up and do SUBSCRIBE to our channel.
Our website: www.studytonight.com
Facebook: / studytonight
Twitter: / studytonight
Instagram: / study.tonight
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
11/10 imdb rating, definitely recommend to watch. Can't wait for the sequel and prequel.
🤣🤣
dayum
Nice one
You should stop watching too many movies
"This isn't even my final form"
Nooooooooo comment of the year
LETS GOOOOO
Let the Cell games begin!!
"And this... Is... to go... even further beyond!... uaaaaaaaaah"
I like how they do a little recap of previous concepts. It helped me in concreting the concepts in my mind.
best normal form series in the entire youtube database...!!
After spending days for searching the right content. Finally understood what it is. Thank You so much!
this video has just saved my life - thank you!
these videos are very helpfull! they help me prepare for my exam so much! thank you!
Those emoticons and images are so funny. Well Done, Thanks
Amazing sir.. really useful for the beginners ..easy understanding with simple logics ...
the best video on mvd and 4nf on youtube...
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
Such a great explaination, thanks!
Thank you professor ❤️
this video saved me. thanks for making it!
Awesome video!! Simple clear and precise :)
man , I love the way you explain 👌👌👌
Such an entertaining explanation thank you soo much : )
Very good presentation
Doesn't get viewers bored
Thnks a ton.well explained.
Nice Video..very clear understanding with example..thanks for making video
Great jobs! Can't wait to get the 5th normal form video :)
You know they haven't uploaded the 5nf video since 9 months, do you?
Excellent explanation.
Very well explained in an easier way
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)
great
Dankeeee
like the way you teach ...good work..
clear understanding video ever
Its so much fun to learn with meme songs and memes and this video was made 4 yrs ago... Kudos to u sur 😀
Thanks Akash :D
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...
Great video!
very good videos, thx
Thank you so much, I'll subscribe
Thank you sir.
Good explanation.
thank you sir
Super video sir this has helped me lot but you should do more videos on this
loved it 😍😍😍😍😍😍
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
Thank you
VERY GOOD I LIKE
Thanks a lot
Best for 4nf🙌
Amazing video, Thank you very much!
My pleasure :)
what about 5NF ?
This has been very helpful!!
Glad it was helpful!
i need the 5th normal form for my exam. Please upload it fast. You so good with it. Thanks for information
Succes colegu, toate cele bune
bafta! te pwp
Did you find a good video of 5NF?
Sir Please make a separate video of function dependency and its types.
waiting for the 5NF :D
AMAZING VID
Simply amazing.
Thank you 🥰
I am fan of youuuu . 👩🏫👩🏫👩🏫👩🏫
Good keep it up
終於搞明白了！謝謝
thanks
sir can you explain all normal forms with one example
Will you also upload 5NF?
emojis are perfectly suited😂
Thanks for the clear explaination !!
How does the two rows of student ID 1 gives rise to 2 more rows?? Please explain. I didn't understand.
You can explain to a two-year-old and he/she will understand you. Good Job!!!!👍
I concur, I am 2.
Let them have some fun during this age...
5 NF plz
too good
Thanks
Welcome
Good explanation 👏👏👏
Glad you liked it
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?
please make the video explain the 5NF
When you will upload video of 5th normal form
Request needed for uploading
very good nice video
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
good explanation, it would be better with subtitles though
sir When will you upload video of 5th NF
where is 5NF video?
rest all videos are very simple to understand . nice job!
but pls give 5NF video too!!!!!!!!!!!!!!!!!1
Please come up with django tutorials and also ML model deployment in django web framework and scalability for it
ok
nice
Is every functional dependency a multi valued dependency? I read in a textbook about it, because I am confused how that can be? Thanks
thankyou
Welcome
keep it up
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?
I wanna know too someone reply me
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!
When do we get 5th normal form vedio.
Plzz share it as soon as possible
👌plz 5 nf vedio
Please upload 5th normal form video...sir
Plz explain 5NF
excellent sir you become my idle awsm teaching method and explanation 💪💪💪💪
thaaaaanx
Could somebody explain please, why 2 rows of "s_id" and "course" will give rise two more rows in 2:38 ? Thanks in advance.
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'?
Ambiguity
can you make videos on database administration???
Be confident enough to be superior
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.
Good video but need 5NF plz!
Sir, Please upload 5nf vedio
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.
What would the MVD be in the table at 4:21? s_id ->->c_id and s_id->->c_name?
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).
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.
Please upload 5th NF
the cricket sound was amazing.
Can you please make Java programming tutorial? Also before that please can you tell me difference between java and core java?
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.
please upload the 5th normal form sir
SELECT * LOVE FROM BANGLADESH;
Why haven't u published the 5nf yet
But shouldn't the s_id be a unique identifier? It appears in two rows ...?
Exactly.
Thumbs up
sir .. after breaking the table .. I think it violates 3 rd normal form .becz... professor >subject .. both are non prime attributes....am I right