Jo 15 saal pehle college ke ek poore semeester mein naa jaan paaya woh kuch minutes ke video mein seekha diya..!! Gate Smashers and Eli the computer guy are epitome of philanthropy! Making free learning a dream for everyone!! Keep making videos, we all admire your great work!! Big kudos to your team behind the scene as well. I know a successful Frontend is possible only due to robust backend :)
Keep going friend with dedication and pure thoughts. You have good knowledge and your skills are also good. Heartless people dislike sincere efforts of others.
I have no words to show gratitude towards you, you're the best teacher I have ever found, its difficult to understand 5NF, but after your lecture .. It is super easy.. Thanku so much sir, stay blessed always❤😊🎉
I couldn't understand anything of these when taught in college..but now I have no confusion at all Thank you very much sir for making it this much easy to understand
This is magical. You should be the highest paid individual in the entire system of Universe. I just do not even look at my lecture notes. I make my own from your videos, thank you so much..
00:06 - Lossless Vs Lossy decomposition 02:35 - At least one common attribute is necessary for joining tables. 05:03 - How to write a SQL query with a natural join 07:30 - Natural join is a cross product of two tables plus a condition of equivalence on their common attributes. 10:03 - Natural join selects rows where B's value is the same in both sides 12:34 - Lossy Decomposition leads to inconsistency in database 14:46 - Lossy decomposition occurs due to inconsistency in the database 17:06 - The common attribute should be the candidate key or super key of either R1 or R2. 19:14 - Lossless join decomposition ensures no spurious tuples in decomposed and joined tables 21:31 - Candidate key can be either of R1 or R2 or both
You are the best teacher in this world.i have no word to thanking you.All the videos are really help ful to me.because of your video I score good marks in my exams.Thank you so much sir for this video's 🙏🙏🙏🙏.
BEST EXPLAINEATION AND MAINE JO SOCHA 5F ME VAHI HUA LOSSY DECOMPOSITION ME ATTRIBUTE COMMAN HAI BUT NO DUPLICACY MAINE VAHI SOCHA KI PEHLE AB AC LENA CHAHIYE SIR NE BATA DOYA FINALLY VARY GREAT EXPLAINED 💖✨🔥🙇
Sir, could we also have a lecture on dependency preservation, which could, by your skill and kindness, be as simple and easy to understand as this one was?
It's not only the IITs which makes it special it's their brightest minds who are focussed to chase their goals in a consistent way. Everyone should be consistent and acquire latest skills to kick-start or progress in our career. Thanks to #Gate_Smashers team for their continuous efforts to provide best education for everyone ♥💓
for 11:22 i think the quary should be SELECT * FROM R1 JOIN R2 ON R1.B = R2.B WHERE R1.A = 1 because on "SELECT R2.c FROM R2 NATURAL JOIN R1 WHERE R1.a = 1" is giving error when i tried running it
Thank you so much for the prime content sir. I didn't find your lecture for 4th normal form request you to please upload the same. Thank you. Love from Armed Force ❤️
Sir common attribute should be CK or SK of R. This will be good to say.. because this we have to do before we decompose. Kindly suggest. For this example we decided that A is CK of R then we went for R1(AB) and R2(AC)
Sir..please try to explain in English(Whole video)..then you are also became popular like RavindraBabu Ravula..bcoz your videos are excellent..that's why many of them will seen if you explain in English..I'm u r well wisher☺️👍
We don't need IIT's if we have teachers like u on YT. Thank you so much for making this quality content available for free!
LOL iit wale bhi yahi se padhte hain.😅
😂😂😂😂😁😁
@@ANSHUKUMAR-hk2ok bilkul sahi baat😂😂
Who told you iit's has good teachers 🤣
iit's just have good infrastructure and good facilities
omg the clarity at the ending saved my 19 minutes. i was going to quit because i was confused but as always you rockk!
Main point on 17:00
The first half of the video is natural join explanation
And watch in 2x speed
Thanks!
Mai ye comment video se pehle kyu nahi dekha 😢
Jo 15 saal pehle college ke ek poore semeester mein naa jaan paaya woh kuch minutes ke video mein seekha diya..!! Gate Smashers and Eli the computer guy are epitome of philanthropy! Making free learning a dream for everyone!! Keep making videos, we all admire your great work!! Big kudos to your team behind the scene as well. I know a successful Frontend is possible only due to robust backend :)
varun sir..u r like god for us in this lockdown period..if this semester we will pass then only it is becoz of u sir..❤❤❤
No matter how complicated topic is , you make it easy every time , huge respect for you bhaiya 🙏
Keep going friend with dedication and pure thoughts. You have good knowledge and your skills are also good.
Heartless people dislike sincere efforts of others.
True bro .. they are losers who don't even deserves good material
If i were aware of this channel before my whole doubts would have been cleared in one/first attempt................ as usual great work sir G #Guru_G
Apka koi jawab nahi h sir.....itni complicated topics ko itni asaani se exaplain kar dete.......really u r the great!!!!!👍👍👌👌👌👌
i rely on your videos to score in my exams!! Thank you sir.... you are a gifted teacher.
Thanku sir, your videos are helping us a lot in our university exams and save our maximum time :-) ...............keep up loading more videos.
I have no words to show gratitude towards you, you're the best teacher I have ever found, its difficult to understand 5NF, but after your lecture .. It is super easy.. Thanku so much sir, stay blessed always❤😊🎉
Wow, thank you!
I was confused on this concept and here he explained it so easily.Great!!
I couldn't understand anything of these when taught in college..but now I have no confusion at all
Thank you very much sir for making it this much easy to understand
What a teaching way 😍 you have ! I m in 3 rd yr i think tum hi puri engineering nikalonge meri har sal yahi ajana padta hai😍
same here haha
jinda ho kya ? agar ho to btao package kitne ka mila? mila bhi ya nhi
2:30 2:32 2:34 2:36 2:38
Cro 0rod 6:59
Imp cos 21:35
This is magical. You should be the highest paid individual in the entire system of Universe. I just do not even look at my lecture notes. I make my own from your videos, thank you so much..
00:06 - Lossless Vs Lossy decomposition
02:35 - At least one common attribute is necessary for joining tables.
05:03 - How to write a SQL query with a natural join
07:30 - Natural join is a cross product of two tables plus a condition of equivalence on their common attributes.
10:03 - Natural join selects rows where B's value is the same in both sides
12:34 - Lossy Decomposition leads to inconsistency in database
14:46 - Lossy decomposition occurs due to inconsistency in the database
17:06 - The common attribute should be the candidate key or super key of either R1 or R2.
19:14 - Lossless join decomposition ensures no spurious tuples in decomposed and joined tables
21:31 - Candidate key can be either of R1 or R2 or both
You are the best teacher in this world.i have no word to thanking you.All the videos are really help ful to me.because of your video I score good marks in my exams.Thank you so much sir for this video's 🙏🙏🙏🙏.
One of My fav vedio on dbms
From gate smashers
Thank u sir💞💞🇮🇳🇮🇳🌹🌹
3 ki jagah 5 row aagyi fayeda ho gya😂
you are awesome i dont have much worlds to express but you are best !!!!!!!!!!!!!!!!!!!!!
Varun sir you are the best instructor of cs
Entity set: DBMS
Attribute: Father_of_dbms
Instances/Data values: EFCodd, VarunSingla🙏❤️
best explanation of this topic I ever gone through
ikr!!!!!
May God bless you infinity Sir ❤️ you're the reason of our success ❤ thank you infinity ❤
You are really great and hardworking sir❤❤❤
BEST EXPLAINEATION AND MAINE JO SOCHA 5F ME VAHI HUA LOSSY DECOMPOSITION ME ATTRIBUTE COMMAN HAI BUT NO DUPLICACY MAINE VAHI SOCHA KI PEHLE AB AC LENA CHAHIYE SIR NE BATA DOYA FINALLY VARY GREAT EXPLAINED 💖✨🔥🙇
Thank you for clearing all my doubts. Your way of teaching is really good. Thank you for being there for us, Sir.
nice sir, I am really impressed on your lectures
Sir, could we also have a lecture on dependency preservation, which could, by your skill and kindness, be as simple and easy to understand as this one was?
east or west varun bhayia is best😍😍😍😍😍😍
Excellent. Keep it up. Thanks for providing this video.
Thanks for making the subject so easy to understand and learn it. 😄😄
And the award goes to Varun sir
Thank you sir. It was very much Helpful.
I was not able to afford my Tution, so it helped me 🙏🙏
Sir , I refer you all video for DBMS and its give me so good explanation and also cocept was really awesome
sir g aap great ho , mazza aagya aapse padhkr
Me es topic me bahut confused thi apne Bahut ache se samjhaya thank you sir ☺ap Clear samjhate ho
Best explanation 👍
Awesome lecture!
Thank you sir 🙏
Thank you sir for clear my all doubts
And you are the best teacher 💯💯💯
5NF - You Nailed it 🔥 Best Explanation in the ending
Sir I didn't find your with 4th normal form
Anyways your teaching skills are too good
Thank you sir for amazing video free on YT
love you bhai kal exam h bht mst samjhaya
thankyou
Omg ! Sir you are video is very helpful to achieve my goal thanks lot
Thanks sir the videos is very helpful our us 😍
Condition for a decomposition to be lossless is at 20:00 in this lecture.
Thank u so much sir...u saves my alot of time
Thank you so much for your awesome lecture i really appreciate it and it helps me alot
Thank you so much sir , it's very useful for me
U have more knowledge about all subjects of CS.....🥰
Thank very much Sir for your excellent presentation
Very clearly explained sir. Respect ++ .
Thanks sir this is very helpful
Thnak you sir.. your explanation is so good..
I am just thankful to this channel😁
mai normal exams ke liye prep kr rha hu , 1.5 x speed mei bi clear hai , itni clear explanation dekh ke GATE hi prepare krne ka mann kr rha hai
Thank you so much sir 🙏🙏 very well explain 😊
Sir ur classes are super.🔥🔥🔥
you are the only support in our hard times😄
Thank you sir for this excellent video
Alwys big thnkuh 🥳sirji
Amazing Explanation
superb!! thanks for providing this help for free
1 day before exam 😊 life savior videos 🥰
This was an awesome explanation.
Great great great explanation thanks 🙏🏻👍🏻
It's not only the IITs which makes it special it's their brightest minds who are focussed to chase their goals in a consistent way. Everyone should be consistent and acquire latest skills to kick-start or progress in our career.
Thanks to #Gate_Smashers team for their continuous efforts to provide best education for everyone ♥💓
This video is like a suspense movie and finally give satisfy 😀
Thankie sir 🎉❤
Thanks Sir, your videos are too much helpful
thank u sir ur channel is the best..
Sir You are the best 🔥
LOVE AND RESPECT FROM PAKISTAN.
Thankyou so much Sir,
For providing these free contents.
Jai Hind ❤️
for 11:22 i think the quary should be SELECT * FROM R1 JOIN R2 ON R1.B = R2.B WHERE R1.A = 1
because on "SELECT R2.c FROM R2 NATURAL JOIN R1 WHERE R1.a = 1" is giving error when i tried running it
Tnank u so much sir .i from pakistan.your video is superb
Nice sir .Really I want to sit in your live class
thanks so much sir ur explanation is really bestttttttttttt
thx a lot sir ........u r great .
u r superb teacher
Thank you so much sir❤️
Man i am having my degree just bcz of you
Thank you so much for the prime content sir.
I didn't find your lecture for 4th normal form request you to please upload the same.
Thank you.
Love from Armed Force ❤️
Thank you..4th nf is already covered with example in video named as “all normal forms with real life examples ”
Yeah, I have already seen that.
Taking your lectures at 14k ft. altitude.
Will surely meet you after the success.
Thank you for keep guiding. 🙏
Awesome explanation sir. Awesome
Excellent 🤩
Very good explanation sir 🙏🙏❤️
i have a ppr in 2 hours thank you gate smashers :)
Superb explanation
Superb. Please make more vedios for dsssb tgt.
Awesome Sir
Really amazing explaination
Sir u can make video on 4NF in DBMS
preparing for gate and now i have university exams so it is time for Gate Smashers😍🤩🤩🤩🤩
Uff, 17th min end game 🖤
Well taught :)
Sir common attribute should be CK or SK of R. This will be good to say.. because this we have to do before we decompose. Kindly suggest. For this example we decided that A is CK of R then we went for R1(AB) and R2(AC)
Sir..please try to explain in English(Whole video)..then you are also became popular like RavindraBabu Ravula..bcoz your videos are excellent..that's why many of them will seen if you explain in English..I'm u r well wisher☺️👍
As if ravindrababu ravula has the best english accent 😂. Ur getting something ! appreciate it, rather than complaining.
For dbms in english..you can refer my youtube channel. th-cam.com/video/bgSvzCcvZjo/w-d-xo.html
But he doesn't upload all the video.
I think the sir teach well as his wish he can do in english and hinglish