Video není dostupné.
Omlouváme se.
4th Normal Form (4NF) | Multi-Valued Dependency | Database Normalization
Vložit
- čas přidán 2. 08. 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
best normal form series in the entire youtube database...!!
"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"
@@mainmanlobo_bro it's frieza not cell
I like how they do a little recap of previous concepts. It helped me in concreting the concepts in my mind.
Those emoticons and images are so funny. Well Done, Thanks
After spending days for searching the right content. Finally understood what it is. Thank You so much!
these videos are very helpfull! they help me prepare for my exam so much! thank you!
this video has just saved my life - thank you!
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
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
Amazing sir.. really useful for the beginners ..easy understanding with simple logics ...
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?
Awesome video!! Simple clear and precise :)
the best video on mvd and 4nf on youtube...
Such a great explaination, thanks!
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
this video saved me. thanks for making it!
Such an entertaining explanation thank you soo much : )
Nice Video..very clear understanding with example..thanks for making video
man , I love the way you explain 👌👌👌
Thnks a ton.well explained.
Thank you professor ❤️
loved it 😍😍😍😍😍😍
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?
Very good presentation
Doesn't get viewers bored
Thank you so much, I'll subscribe
Very well explained in an easier way
like the way you teach ...good work..
終於搞明白了！謝謝
what about 5NF ?
Excellent explanation.
Super video sir this has helped me lot but you should do more videos on this
Great video!
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...
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
Good keep it up
clear understanding video ever
thank you sir
How does the two rows of student ID 1 gives rise to 2 more rows?? Please explain. I didn't understand.
sir i want your ppt of full normalisation concept how i will get that
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?
emojis are perfectly suited😂
Thanks for the clear explaination !!
This has been very helpful!!
Glad it was helpful!
very good videos, thx
too good
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...
Good explanation.
VERY GOOD I LIKE
Amazing video, Thank you very much!
My pleasure :)
Thank you sir.
When you will upload video of 5th normal form
Request needed for uploading
AMAZING VID
Thank you
Thanks a lot
I am fan of youuuu . 👩🏫👩🏫👩🏫👩🏫
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.
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!
Best for 4nf🙌
Simply amazing.
Thank you 🥰
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.
Is every functional dependency a multi valued dependency? I read in a textbook about it, because I am confused how that can be? Thanks
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
sir can you explain all normal forms with one example
waiting for the 5NF :D
thanks
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
Sir Please make a separate video of function dependency and its types.
keep it up
very good nice video
Will you also upload 5NF?
Good explanation 👏👏👏
Glad you liked it
thaaaaanx
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).
nice
Hi. I still dont understand why there must be 3 columns to determine the table has multivalued dependency?
Thumbs up
Thanks
Welcome
sir .. after breaking the table .. I think it violates 3 rd normal form .becz... professor >subject .. both are non prime attributes....am I right
where is 5NF video?
rest all videos are very simple to understand . nice job!
but pls give 5NF video too!!!!!!!!!!!!!!!!!1
thankyou
Welcome
Why haven't u published the 5nf yet
Please come up with django tutorials and also ML model deployment in django web framework and scalability for it
ok
excellent sir you become my idle awsm teaching method and explanation 💪💪💪💪
4:18 I don't think this table has MVD. Or does it?
Yes, it does, if you look at the last two attributes, they both are dependent on the primary key (which is S_id) and are also independent of one another
sir When will you upload video of 5th NF
But shouldn't the s_id be a unique identifier? It appears in two rows ...?
Exactly.
How you edit your video
It's pretty tough, as I do it by making slides for everything.
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.
good explanation, it would be better with subtitles though
can you make videos on database administration???
When do we get 5th normal form vedio.
Plzz share it as soon as possible
👍
5 NF plz
please make the video explain the 5NF
thank you sir... {: -)
where is the 5th NF vedio?
Heyy i didnt find ur 5nf vdo.??
Because we have not yet created 5NF video :|
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.
wait for 5 NF?
the cricket sound was amazing.