Lec-28: Lossless and Lossy Decomposition| Fifth (5th) Normal Form | Database Management System 

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!

omg the clarity at the ending saved my 19 minutes. i was going to quit because i was confused but as always you rockk!

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..❤❤❤

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.

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

Main point on 17:00 The first half of the video is natural join explanation And watch in 2x speed

No matter how complicated topic is , you make it easy every time , huge respect for you bhaiya 🙏

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 :)

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😍

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❤😊🎉

Thanku sir, your videos are helping us a lot in our university exams and save our maximum time :-) ...............keep up loading more videos.

i rely on your videos to score in my exams!! Thank you sir.... you are a gifted teacher.

Apka koi jawab nahi h sir.....itni complicated topics ko itni asaani se exaplain kar dete.......really u r the great!!!!!👍👍👌👌👌👌

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 🙏🙏🙏🙏.

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..

3 ki jagah 5 row aagyi fayeda ho gya😂

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?

I was confused on this concept and here he explained it so easily.Great!!

One of My fav vedio on dbms From gate smashers Thank u sir💞💞🇮🇳🇮🇳🌹🌹

May God bless you infinity Sir ❤️ you're the reason of our success ❤ thank you infinity ❤

east or west varun bhayia is best😍😍😍😍😍😍

Thanks for making the subject so easy to understand and learn it. 😄😄

best explanation of this topic I ever gone through

You are really great and hardworking sir❤❤❤

Entity set: DBMS Attribute: Father_of_dbms Instances/Data values: EFCodd, VarunSingla🙏❤️

you are awesome i dont have much worlds to express but you are best !!!!!!!!!!!!!!!!!!!!!

nice sir, I am really impressed on your lectures

Thank you for clearing all my doubts. Your way of teaching is really good. Thank you for being there for us, 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

2:30 2:32 2:34 2:36 2:38 Cro 0rod 6:59 Imp cos 21:35

Thank you sir for clear my all doubts And you are the best teacher 💯💯💯

Sir u can make video on 4NF in DBMS

Thank you so much sir , it's very useful for me

Thanks sir this is very helpful

Thank you so much for your awesome lecture i really appreciate it and it helps me alot

And the award goes to Varun sir

Thank u so much sir...u saves my alot of time

Me es topic me bahut confused thi apne Bahut ache se samjhaya thank you sir ☺ap Clear samjhate ho

Varun sir you are the best instructor of cs

Best explanation 👍

Thanks sir the videos is very helpful our us 😍

Excellent. Keep it up. Thanks for providing this video.

Thank you sir for amazing video free on YT

5NF - You Nailed it 🔥 Best Explanation in the ending

Awesome lecture! Thank you sir 🙏

U have more knowledge about all subjects of CS.....🥰

sir g aap great ho , mazza aagya aapse padhkr

Sir ur classes are super.🔥🔥🔥

This was an awesome explanation.

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

Omg ! Sir you are video is very helpful to achieve my goal thanks lot

Amazing Explanation

Thank you sir for this excellent video

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)

Thank you so much sir 🙏🙏 very well explain 😊

Thnak you sir.. your explanation is so good..

you are the only support in our hard times😄

Sir is there a fourth normal form ? multivalued dependency.. can u cover that too ,if possible?

Thankie sir 🎉❤

Nice sir .Really I want to sit in your live class

1 day before exam 😊 life savior videos 🥰

thx a lot sir ........u r great .

thank u sir ur channel is the best..

This video is like a suspense movie and finally give satisfy 😀

love you bhai kal exam h bht mst samjhaya thankyou

Very clearly explained sir. Respect ++ .

I am just thankful to this channel😁

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 ❤️

🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥

Thankyou so much Sir, For providing these free contents. Jai Hind ❤️

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☺️👍

Man i am having my degree just bcz of you

Thank you so much sir❤️

LOVE AND RESPECT FROM PAKISTAN.

superb!! thanks for providing this help for free

thanks so much sir ur explanation is really bestttttttttttt

Thankx a lot sir

Thanks Sir, your videos are too much helpful

Tnank u so much sir .i from pakistan.your video is superb

Sir aapne 4th NF q nhi padhaya h.... Baki sb to ekdm clear h

Superb. Please make more vedios for dsssb tgt.

Confused between candidate and super key. Need explaination with example.

bro, if you don't mind will you make another video for the second normal form! due to the syncing problem, I didn't understand that one!!

Mene to btech m sach m sewaye theory ke kuj ni jia... smjh kuj ni aatavtha bt now understanding real meaning of kida study kri di aa

Sir agr 2 rows m unique attributes ho to sir isme condidate key kya lege .??

i have a ppr in 2 hours thank you gate smashers :)

thanks sir

sir, can you plz tell how an common attribute i.e a part of candidate key can prevent lossy decomposition?

apke likhane samy bord chip jaa rha h. side me rho n sir jisse data hm logo ko dikhe

you told about the lossy join, but we can also do a lossless join using AB and AC ,and you didnt explain that. please try to do that also, i am confused to do a lossless join

Why do we need to join in which we do cross product and many calculations? And even after doing such calculations and end up in a flaw. Cant we just access the original table? Or maybe a copy of the original table?

preparing for gate and now i have university exams so it is time for Gate Smashers😍🤩🤩🤩🤩

Excellent 🤩

Awesome explanation sir. Awesome

u r superb teacher

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

Sir is there any lecture on dependency preserving decomposition

Sir dependency preserving decomposition ka lecture nahi hai kya ?? .this lecture loss less or lossy but after this lecture not dependency preserving decomposition lecture . Plz sir make the lecture on dependency preserving decomposition .