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
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)
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 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!
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'?
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.
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
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
I have 1 small doubt. At 4:19, there is no MVD right? Since there is dependency between cid and cname, therefore we cannot say s_id ->-> c_id. Am I missing something?
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.
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).
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
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.
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
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...!!
I like how they do a little recap of previous concepts. It helped me in concreting the concepts in my mind.
"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
Those emoticons and images are so funny. Well Done, Thanks
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!
After spending days for searching the right content. Finally understood what it is. Thank You so much!
What are you doing now bro?
Awesome🎉🎉🎉
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
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?
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
the best video on mvd and 4nf on youtube...
Amazing sir.. really useful for the beginners ..easy understanding with simple logics ...
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
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?
man , I love the way you explain 👌👌👌
When you will upload video of 5th normal form
Request needed for uploading
This has been very helpful!!
Glad it was helpful!
Such an entertaining explanation thank you soo much : )
Very good presentation
Doesn't get viewers bored
sir can you explain all normal forms with one example
Such a great explaination, thanks!
How does the two rows of student ID 1 gives rise to 2 more rows?? Please explain. I didn't understand.
Awesome video!! Simple clear and precise :)
this video saved me. thanks for making it!
loved it 😍😍😍😍😍😍
Simply amazing.
Thank you 🥰
Excellent explanation.
what about 5NF ?
Amazing video, Thank you very much!
My pleasure :)
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...
I am fan of youuuu . 👩🏫👩🏫👩🏫👩🏫
Thank you professor ❤️
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!
VERY GOOD I LIKE
Good explanation.
Will you also upload 5NF?
Very well explained in an easier way
clear understanding video ever
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...
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
Great video!
like the way you teach ...good work..
Best for 4nf🙌
emojis are perfectly suited😂
Thanks for the clear explaination !!
Nice Video..very clear understanding with example..thanks for making video
Good explanation 👏👏👏
Glad you liked it
終於搞明白了！謝謝
Thnks a ton.well explained.
very good videos, thx
Hi. I still dont understand why there must be 3 columns to determine the table has multivalued dependency?
Thanks a lot
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.
AMAZING VID
where is 5NF video?
rest all videos are very simple to understand . nice job!
but pls give 5NF video too!!!!!!!!!!!!!!!!!1
LoL !!! In 4 years of my engineering i did not learn what I learnt in these 4 minute fast food ;)
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
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
5 NF plz
Thank you
I have 1 small doubt. At 4:19, there is no MVD right? Since there is dependency between cid and cname, therefore we cannot say s_id ->-> c_id. Am I missing something?
There is MVD. Coz s_id --> s_name & s_name has multi values...
@@ramyaluhar9199 ? s_name doesn't have multiple values. Each s_id is associated with only 1 s_name
sir i want your ppt of full normalisation concept how i will get that
can you make videos on database administration???
Thank you sir
Super video sir this has helped me lot but you should do more videos on this
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.
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 come up with django tutorials and also ML model deployment in django web framework and scalability for it
ok
very good nice video
Good keep it up
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.
Sir, Please upload 5nf vedio
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).
Is every functional dependency a multi valued dependency? I read in a textbook about it, because I am confused how that can be? Thanks
thanks
waiting for the 5NF :D
too good
Sir Please make a separate video of function dependency and its types.
Thank you so much, I'll subscribe
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
sir .. after breaking the table .. I think it violates 3 rd normal form .becz... professor >subject .. both are non prime attributes....am I right
Why haven't u published the 5nf yet
please make the video explain the 5NF
When do we get 5th normal form vedio.
Plzz share it as soon as possible
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.
Be confident enough to be superior
👌plz 5 nf vedio
2:21 I thought doge memes came in 2020 😂
good explanation, it would be better with subtitles though
Plz explain 5NF
keep it up
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
Please upload 5th NF
nice
wait for 5 NF?
where is the 5th NF vedio?
the cricket sound was amazing.