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

  Рет қаралды 847,985

Gate Smashers

Gate Smashers

Күн бұрын

👉Subscribe to our new channel: / @varunainashots
►Database Management System(Complete Playlist):
• DBMS (Database Managem...
Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
• Design and Analysis of...
►Computer Architecture (Complete Playlist):
• Computer Organization ...
► Theory of Computation
• TOC(Theory of Computat...
►Artificial Intelligence:
• Artificial Intelligenc...
►Computer Networks (Complete Playlist):
• Computer Networks (Com...
►Operating System:
• Operating System (Comp...
►Structured Query Language (SQL):
• Structured Query Langu...
►Discrete Mathematics:
• Discrete Mathematics
►Compiler Design:
• Compiler Design (Compl...
►Number System:
• Number system
►Cloud Computing & BIG Data:
• Cloud Computing & BIG ...
►Software Engineering:
• Software Engineering
►Data Structure:
• Data Structure
►Graph Theory:
• Graph Theory
►Programming in C:
• C Programming
►Digital Logic:
• Digital Logic (Complet...
---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
► Subscribe to us on KZbin: / gatesmashers
►Subscribe to our new channel: / @varunainashots
► Like our page on Facebook: / gatesmashers
► Follow us on Instagram: / gate.smashers
► Follow us on Instagram: / varunainashots
► Follow us on Telegram: t.me/gatesmash...
► Follow us on Threads: www.threads.ne...
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Email us at: gatesmashers2018@gmail.com
#lossyLosslessdecomposition#5thNormalform#dbms

Пікірлер: 252
@aneeshsagiraju3985
@aneeshsagiraju3985 3 жыл бұрын
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!
@ANSHUKUMAR-hk2ok
@ANSHUKUMAR-hk2ok 2 жыл бұрын
LOL iit wale bhi yahi se padhte hain.😅
@gabruboy1690
@gabruboy1690 2 жыл бұрын
😂😂😂😂😁😁
@prateekjain7623
@prateekjain7623 2 жыл бұрын
@@ANSHUKUMAR-hk2ok bilkul sahi baat😂😂
@kumarsrijan7566
@kumarsrijan7566 2 жыл бұрын
Who told you iit's has good teachers 🤣
@techieboy1983
@techieboy1983 2 жыл бұрын
iit's just have good infrastructure and good facilities
@collegestudy5977
@collegestudy5977 5 жыл бұрын
omg the clarity at the ending saved my 19 minutes. i was going to quit because i was confused but as always you rockk!
@rashim
@rashim 3 жыл бұрын
Main point on 17:00 The first half of the video is natural join explanation And watch in 2x speed
@mustafabohra2070
@mustafabohra2070 3 жыл бұрын
Thanks!
@ujjwalrockriser
@ujjwalrockriser 5 ай бұрын
Mai ye comment video se pehle kyu nahi dekha 😢
@rahulmishra3820
@rahulmishra3820 3 жыл бұрын
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..❤❤❤
@Vikashpoonia.ExamsABC
@Vikashpoonia.ExamsABC 5 жыл бұрын
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.
@abhinavmathur6072
@abhinavmathur6072 5 жыл бұрын
True bro .. they are losers who don't even deserves good material
@Mandeepchaurasiya-mr3vt
@Mandeepchaurasiya-mr3vt 10 ай бұрын
No matter how complicated topic is , you make it easy every time , huge respect for you bhaiya 🙏
@priyankvashist4103
@priyankvashist4103 4 жыл бұрын
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
@utka1234able
@utka1234able Жыл бұрын
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 :)
@svarajdhanulkar1791
@svarajdhanulkar1791 4 жыл бұрын
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😍
@pallavikamboj173
@pallavikamboj173 4 жыл бұрын
same here haha
@rashmikuksal192
@rashmikuksal192 Жыл бұрын
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❤😊🎉
@GateSmashers
@GateSmashers Жыл бұрын
Wow, thank you!
@PayalMCA
@PayalMCA 5 жыл бұрын
Thanku sir, your videos are helping us a lot in our university exams and save our maximum time :-) ...............keep up loading more videos.
@pranayranjan5507
@pranayranjan5507 4 жыл бұрын
i rely on your videos to score in my exams!! Thank you sir.... you are a gifted teacher.
@shubhambhardwaj6952
@shubhambhardwaj6952 Ай бұрын
I was confused on this concept and here he explained it so easily.Great!!
@devrai5101
@devrai5101 5 жыл бұрын
3 ki jagah 5 row aagyi fayeda ho gya😂
@mahimarathor2992
@mahimarathor2992 Жыл бұрын
Apka koi jawab nahi h sir.....itni complicated topics ko itni asaani se exaplain kar dete.......really u r the great!!!!!👍👍👌👌👌👌
@siyasharma188
@siyasharma188 3 жыл бұрын
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 🙏🙏🙏🙏.
@rojertufani131
@rojertufani131 4 жыл бұрын
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
@satyajitmohanty5008
@satyajitmohanty5008 9 ай бұрын
east or west varun bhayia is best😍😍😍😍😍😍
@preethamm.n1161
@preethamm.n1161 4 жыл бұрын
One of My fav vedio on dbms From gate smashers Thank u sir💞💞🇮🇳🇮🇳🌹🌹
@Dhruvarmy13
@Dhruvarmy13 9 ай бұрын
You are really great and hardworking sir❤❤❤
@srijitanitamajumdar5904
@srijitanitamajumdar5904 4 жыл бұрын
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?
@Huntyoudown2020
@Huntyoudown2020 10 ай бұрын
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..
@ShwetaSingh-qk7vh
@ShwetaSingh-qk7vh 3 жыл бұрын
Sir u can make video on 4NF in DBMS
@subhasmitasahoo8373
@subhasmitasahoo8373 10 ай бұрын
May God bless you infinity Sir ❤️ you're the reason of our success ❤ thank you infinity ❤
@mahendrakoteri9233
@mahendrakoteri9233 5 жыл бұрын
best explanation of this topic I ever gone through
@anantsingh6599
@anantsingh6599 4 ай бұрын
ikr!!!!!
@maazosmany1291
@maazosmany1291 2 жыл бұрын
you are awesome i dont have much worlds to express but you are best !!!!!!!!!!!!!!!!!!!!!
@namanvijay3514
@namanvijay3514 3 жыл бұрын
Best explanation 👍
@funnyvideo-fe7xo
@funnyvideo-fe7xo 5 жыл бұрын
nice sir, I am really impressed on your lectures
@satyamitguru
@satyamitguru 5 жыл бұрын
Thank very much Sir for your excellent presentation
@khushishah7995
@khushishah7995 2 жыл бұрын
Thanks for making the subject so easy to understand and learn it. 😄😄
@sunilkumarmaurya4980
@sunilkumarmaurya4980 3 жыл бұрын
Thanks sir this is very helpful
@shivshakti5783
@shivshakti5783 5 жыл бұрын
Thank you so much sir , it's very useful for me
@nidahanif2114
@nidahanif2114 5 жыл бұрын
Thank u so much sir...u saves my alot of time
@mohammadzaid9189
@mohammadzaid9189 2 жыл бұрын
Entity set: DBMS Attribute: Father_of_dbms Instances/Data values: EFCodd, VarunSingla🙏❤️
@dhruvtrivedi9368
@dhruvtrivedi9368 2 жыл бұрын
Thank you sir. It was very much Helpful. I was not able to afford my Tution, so it helped me 🙏🙏
@mindbodyps
@mindbodyps 3 жыл бұрын
And the award goes to Varun sir
@Asish0089
@Asish0089 8 ай бұрын
2:30 2:32 2:34 2:36 2:38 Cro 0rod 6:59 Imp cos 21:35
@tulsikhatri8694
@tulsikhatri8694 4 жыл бұрын
This was an awesome explanation.
@knowledgesumit8953
@knowledgesumit8953 Жыл бұрын
Thank you sir for clear my all doubts And you are the best teacher 💯💯💯
@butterfly_2004
@butterfly_2004 3 ай бұрын
Thankie sir 🎉❤
@BhanuPratap-pt2wp
@BhanuPratap-pt2wp 2 жыл бұрын
Thank you for clearing all my doubts. Your way of teaching is really good. Thank you for being there for us, Sir.
@manums86
@manums86 3 жыл бұрын
Sir ur classes are super.🔥🔥🔥
@kirankaur9069
@kirankaur9069 4 жыл бұрын
Thank you so much for your awesome lecture i really appreciate it and it helps me alot
@anuragupadhyay5725
@anuragupadhyay5725 2 жыл бұрын
Amazing Explanation
@r_lyricals_6201
@r_lyricals_6201 2 жыл бұрын
🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥
@vikas4407
@vikas4407 2 жыл бұрын
Thanks sir the videos is very helpful our us 😍
@bulkmotivation705
@bulkmotivation705 8 ай бұрын
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 💖✨🔥🙇
@saniaayoub5474
@saniaayoub5474 Жыл бұрын
Varun sir you are the best instructor of cs
@Mr.Streamer01
@Mr.Streamer01 8 ай бұрын
sir g aap great ho , mazza aagya aapse padhkr
@ranuyadav7913
@ranuyadav7913 4 жыл бұрын
Me es topic me bahut confused thi apne Bahut ache se samjhaya thank you sir ☺ap Clear samjhate ho
@poojachauhan2709
@poojachauhan2709 4 жыл бұрын
Thank you sir for this excellent video
@44_siddheshparave71
@44_siddheshparave71 3 жыл бұрын
Sir , I refer you all video for DBMS and its give me so good explanation and also cocept was really awesome
@priyamalik9211
@priyamalik9211 Жыл бұрын
Thank you sir for amazing video free on YT
@suparnesh
@suparnesh 6 жыл бұрын
Excellent. Keep it up. Thanks for providing this video.
@tarushidubey2973
@tarushidubey2973 Жыл бұрын
thank u sir ur channel is the best..
@Maajwalagi
@Maajwalagi 6 жыл бұрын
thx a lot sir ........u r great .
@kartickchandramanna267
@kartickchandramanna267 7 ай бұрын
Awesome lecture! Thank you sir 🙏
@WildRose4u
@WildRose4u 6 ай бұрын
5NF - You Nailed it 🔥 Best Explanation in the ending
@karthikaunnikrishnan-oh7qw
@karthikaunnikrishnan-oh7qw 4 ай бұрын
Nice sir .Really I want to sit in your live class
@shachisinghal8856
@shachisinghal8856 10 ай бұрын
Well taught :)
@rahulkathuria1808
@rahulkathuria1808 10 ай бұрын
Alwys big thnkuh 🥳sirji
@MohammadUmair7
@MohammadUmair7 3 жыл бұрын
Sir You are the best 🔥
@subhajeetchakraborty1791
@subhajeetchakraborty1791 3 жыл бұрын
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
@aliasghar6500
@aliasghar6500 2 жыл бұрын
U have more knowledge about all subjects of CS.....🥰
@SoumitaBanerjee23
@SoumitaBanerjee23 2 жыл бұрын
Thnak you sir.. your explanation is so good..
@fahmidaalam6698
@fahmidaalam6698 Жыл бұрын
I am just thankful to this channel😁
@zainulkhan8381
@zainulkhan8381 Жыл бұрын
Very clearly explained sir. Respect ++ .
@power12450
@power12450 8 ай бұрын
Thank you so much sir 🙏🙏 very well explain 😊
@cse33-avanijain75
@cse33-avanijain75 Жыл бұрын
you are the only support in our hard times😄
@panditsanjay7762
@panditsanjay7762 4 жыл бұрын
Omg ! Sir you are video is very helpful to achieve my goal thanks lot
@taniyaartstory803
@taniyaartstory803 Ай бұрын
1 day before exam 😊 life savior videos 🥰
@JayPatel-ou2ud
@JayPatel-ou2ud Жыл бұрын
Great great great explanation thanks 🙏🏻👍🏻
@ujjwalgupta8945
@ujjwalgupta8945 Жыл бұрын
love you bhai kal exam h bht mst samjhaya thankyou
@mallikarjunpidaparthi
@mallikarjunpidaparthi 3 жыл бұрын
Thank you so much sir❤️
@nihalnandannayak5576
@nihalnandannayak5576 3 жыл бұрын
This video is like a suspense movie and finally give satisfy 😀
@SatyamKumar-25
@SatyamKumar-25 Жыл бұрын
Thank You So much Sir
@VishalYadav-tf9uq
@VishalYadav-tf9uq 2 жыл бұрын
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 ❤️
@GateSmashers
@GateSmashers 2 жыл бұрын
Thank you..4th nf is already covered with example in video named as “all normal forms with real life examples ”
@VishalYadav-tf9uq
@VishalYadav-tf9uq 2 жыл бұрын
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. 🙏
@meahaj5340
@meahaj5340 3 жыл бұрын
Sir is there a fourth normal form ? multivalued dependency.. can u cover that too ,if possible?
@rishabhkumar8115
@rishabhkumar8115 3 жыл бұрын
Thankx a lot sir
@PythonisLove
@PythonisLove 3 жыл бұрын
superb!! thanks for providing this help for free
@studentsheaven-d8v
@studentsheaven-d8v 3 жыл бұрын
LOVE AND RESPECT FROM PAKISTAN.
@RRNJSS
@RRNJSS 3 жыл бұрын
thanks sir
@nidhiruparelsachade4463
@nidhiruparelsachade4463 3 жыл бұрын
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)
@RadhikaGarg-pz9rk
@RadhikaGarg-pz9rk 3 жыл бұрын
thanks so much sir ur explanation is really bestttttttttttt
@sunitarathod7522
@sunitarathod7522 3 жыл бұрын
Excellent 🤩
@amritbirkaur9104
@amritbirkaur9104 5 жыл бұрын
Thanks Sir, your videos are too much helpful
@hashirqureshi6710
@hashirqureshi6710 2 жыл бұрын
Man i am having my degree just bcz of you
@AK-us1by
@AK-us1by 2 жыл бұрын
Good Tutorial
@Satvikshukla0007
@Satvikshukla0007 4 жыл бұрын
Awesome explanation sir. Awesome
@DipashriPokhalekar
@DipashriPokhalekar Жыл бұрын
u r superb teacher
@sadaffnazz725
@sadaffnazz725 3 жыл бұрын
Tnank u so much sir .i from pakistan.your video is superb
@archanabisht1457
@archanabisht1457 3 жыл бұрын
Superb explanation
@gunjanarya2915
@gunjanarya2915 4 жыл бұрын
Superb. Please make more vedios for dsssb tgt.
@Anonymous-i1e
@Anonymous-i1e 3 жыл бұрын
Thankyou so much Sir, For providing these free contents. Jai Hind ❤️
@abhishekupadhyay7261
@abhishekupadhyay7261 4 жыл бұрын
Really amazing explaination
@shrikrishnakulkarni4115
@shrikrishnakulkarni4115 5 ай бұрын
great
@durgeshchandravanshi32
@durgeshchandravanshi32 3 жыл бұрын
Sir aapne 4th NF q nhi padhaya h.... Baki sb to ekdm clear h
@AbhishekA-81
@AbhishekA-81 3 жыл бұрын
Confused between candidate and super key. Need explaination with example.
@pavan7861
@pavan7861 3 жыл бұрын
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!!
@VishalYadav-tf9uq
@VishalYadav-tf9uq 2 жыл бұрын
Change channel setting in the player you are playing after downloading
@durgaprasadnuthalapati8773
@durgaprasadnuthalapati8773 5 жыл бұрын
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☺️👍
@DeepakMishra-dg6ce
@DeepakMishra-dg6ce 5 жыл бұрын
As if ravindrababu ravula has the best english accent 😂. Ur getting something ! appreciate it, rather than complaining.
@sivavekkuluri9719
@sivavekkuluri9719 5 жыл бұрын
For dbms in english..you can refer my youtube channel. kzbin.info/www/bejne/mJi2p615mNuNoNE
@niteshnanda7007
@niteshnanda7007 5 жыл бұрын
But he doesn't upload all the video. I think the sir teach well as his wish he can do in english and hinglish
Magic or …? 😱 reveal video on profile 🫢
00:14
Andrey Grechka
Рет қаралды 70 МЛН
Dad Makes Daughter Clean Up Spilled Chips #shorts
00:16
Fabiosa Stories
Рет қаралды 8 МЛН
Bike vs Super Bike Fast Challenge
00:30
Russo
Рет қаралды 23 МЛН
Cute kitty gadgets 💛
00:24
TheSoul Music Family
Рет қаралды 22 МЛН
lossless decomposition in dbms
8:24
Education 4u
Рет қаралды 134 М.
What is a Relational Database?
7:54
IBM Technology
Рет қаралды 168 М.
4.16 Lossless Join Decomposition in DBMS in HINDI Part-1
16:29
KnowledgeGATE by Sanchit Sir
Рет қаралды 324 М.
5th Normal Form (5NF) | Join Dependency | Database Normalization
8:09
Studytonight with Abhishek
Рет қаралды 256 М.
Magic or …? 😱 reveal video on profile 🫢
00:14
Andrey Grechka
Рет қаралды 70 МЛН