Lec-36: Dependency Preserving Decomposition in DBMS with Examples in Hindi | DBMS

👉Subscribe to our new channel: / @varunainashots
In the dependency preservation, at least one decomposed table must satisfy every dependency. If a relation R is decomposed into relation R1 and R2, then the dependencies of R either must be a part of R1 or R2 or must be derivable from the combination of functional dependencies of R1 and R2.
►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 CZcams: / 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/gatesmashersofficial
► Follow us on Threads: www.threads.net/@gate.smashers
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Email us at: [e-mail]

[@namanpreetsingh9500]

You did lot of efforts first then you pass on the matter to us. Thanks

[@Manishapanchal5578]

Sir apki sbse achi batt h ...jo funda h within 2 minutes clear kr dete ho .....bakio ki tarah be-vajah length ni badhate ......u always rock ....thank u for such explanation ....u really work hard😊😊

[@elpadrino5881]

😂😂😂

[@ShahidAn236]

Right...It is cristal clear concept.

[@embarrassed_dodo]

Unacademy moment lol

[@_iharsh_1]

True

[@DeepakYadav-ys7dg]

Lekin video toh 11 min ka hai

[@lifeofbillionaires9542]

Sir tbh you are the reason that I find these subjects interesting , a big fan sir

[@supriyabhide5095]

Thank you so much sir.. was trying since an hour to understand this concept by reading from a website, still couldn't get it ... but just a few minutes into your video and all was clear. thank you so much sir🙏😊

[@SoumikNandi]

I have seen multiple videos on DBMS by multiple channels. This is simply the best of all!

[@jyotirmoymukherjee4276]

really man?

[@yashisaxena9761]

@@jyotirmoymukherjee4276 yes, he is right? Why? Don't you feel so??

[@motorway9787]

@@yashisaxena9761 ignore him/her

[@monikasagar9632]

Thank you sir💙
Your effort is just beyond the excellent, the way you make complex topic easier is really appreciateable.

[@BitsAndBliss]

itna accha kaun smjhata hai bhai
. Brother you are great !!!!!!!!!!!!!!!!!!!!

[@akansharai9160]

Thanku soo much sir..... just because of u I'm able to get all the concepts of DBMS...thanks alot sir🙏🙏

[@rishabhchakraborty2628]

Best teacher ever seen!

[@ravinderkaur4288]

Thank you so much for your wonderful efforts I appreciate it.

[@shrayasichakraborty2375]

oh my god!!!marvellous explanation!

[@Amitakd2023]

THANK YOU SOO MUCH SIR FIRST TIME I'M LITTLE BIT CONFUSED AFTER WATCHING YOUR VIDEOS ALL CLEAR LIKE WATER.💖💖❤💙💙💙

[@user-wg6ud3hh1n]

thanks you for your explanation.. you are making my learning simple

[@AJGAMING_110]

Best Wishes for Varun

[@kunalsoni7681]

Awesome sir ... Very informative

[@rehanamulla6302]

Thank you so much for your wonderful explanation

[@divyakeshri2831]

BEST BEST BEST
THANKU FOR THIS AMAZING COURSE SIR❤

[@ankitmehta4133]

bhut hard bhai, tum na hote to hmara kya hota, love you bhai

[@shubh13799]

Normalization concepts are clear now. Thank you Sir 💙

[@SSY-vq7zn]

Excellent lectures Sir...

[@jyotpaul7489]

U r awsmmm sir😍😍 God bless you

[@dikshatiwari45]

Osm... Video thankyou so much sir for ur efforts 🙏

[@samarthsingh2705]

very well explained. Keep up the good work sir.

[@shubhamrajput9363]

धन्यवाद सर जी 🙏

[@swaranjeetkaur4993]

Thank you sir. Finally aaj yeh topic understand hoea .

[@swathig5060]

Excellent sir👏👏👏👏

[@animationcrust1993]

May you get prosperity in life ☺️🙌

[@vartikasinghania9723]

❤️❤️best explanation

[@krishanudutta2943]

Very. Well explained sir❤️

[@oindrilamajhi7050]

Indeed helpful

[@shadekurrahmantamgid6115]

Thank you, brother.

[@namanpreetsingh9500]

Good work bro.

[@poojavishwakarma1859]

Good explanation sir...

[@vinitasingh1117]

Thank you sir

[@shashanksharma7747]

VERY GOOD EXPLANATION

[@saptarshichattopadhyay8234]

Thank you so much Sir❤❤❤❤

[@varunmk]

Love you Sir 💙

[@meenumidha3646]

Shukriya

[@educationalportal5374]

live long sir...love from Pakistan

[@loveysingh9913]

great vdo

[@gauravimore4362]

Thank you !

[@RTBOSS]

Thank you so much

[@minivashishta9288]

thanks,sir

[@Icelander00]

Thanks A Lot

[@PratimaYadav-bg3ug]

Thanku sir🙏

[@viral_video_ayana]

Thankyou sir

[@publicstudio66]

LOVE AND RESPECT FROM PAKISTAN DEAR SIR...

[@sarthakgaba1583]

Thank you :)

[@abhirajsingh3071]

Best best best ❤️.

[@lopamudramahapatra4292]

Thx sir 😊

[@DanielSmith-uj7rr]

Thank you for your efforts! Very well explanation..!!

[@rakeshkumarmeena8107]

Thanks bro

[@saya._Za]

thank u sir

[@dushyantsirohi4851]

Love you sir from Blue planet❤️👍🙏🎉🔥💘

[@HabibiTau]

Sir, once i become rich in life i will do something for you
you don't charge us anything and give us such quality content
hats off sir

[@noone_senpai]

Every time he turns to write something on the board , KL Rahul appears out of nowhere. xD

[@Gauravkoshyari2911]

Bro KL RAHUL sir ka cousin h 😅

[@nabeelusmani5937]

Sara panga create ho jaiga 😂😂🙏❤️

[@neh95]

Ak doubt tha ki last ma humne jab check kiya toh c ka closure nikala toh vo preserved kaise hua condition kya tha

[@protikbiswas3907]

❤❤God 😌😌

[@selinamishra8432]

Sirr!! Kitna masst padhate hoo aap!!!!!😭😭

[@pradumanvlogs9893]

😂

[@eduqueue]

6: 00 trivial

[@animeshhazra6061]

Nice

[@gunjanarya2915]

👍💯 please make vedios for dssb tgt questions

[@SanketSharmasanket7317]

ok

[@freevideocourses6349]

Where were u still. I hv taken ugc net coaching from a reputed Institute bt none could explain in this way

[@nunemuntalavardhan9933]

can we say that originaal clouser must be equal to clousers of possible FD's.

[@padhle2184]

🔥🔥🔥🔥🔥

[@shamatangotra1382]

Sir please make videos for UGC NET computer science questions......

[@prashunprateek9085]

[@sonalibagewadi1219]

How the Dividing of AB, BC and BD is done sir

[@RaushanKumar-wt3zq]

How it is possible to divide into AB,BC,BD because B is the common attribute but it is not a candidate key or super key of the table?

[@rakeshsaraf2963]

i guess bana to aap kisi bhi attribute se sakte ho par agar candidate key nahi use karoge to lossy decomposition hoga... yahan pe hm lossy decomposition ka baat kar hi nahi rahe so...

[@gamingwithMr.K]

thank you sir for helping us to crack the exams

[@ranuyadav7913]

👍👍👍👍👍👍👌👌👌👌👌

[@HarshYadav-cb2cb]

university mai course ki jagha aapki videos chlani chaie

[@gaganpandey8333]

Chandigarh University CU students like 😂❤️

[@harshitagarwal3135]

Bkl ek like nhi hai

[@gaganpandey8333]

@@harshitagarwal3135 par 1 reply to h

[@sajaalasharhassan8105]

Your explanation is too good, but try to use English please instead of Hindi!

[@iassahabji1436]

aa gye exam se pahle 2x wale 😂

[@munimekalaabhishek40]

Thank you sir

[@mindbodyps]

Thanks sir