4.16 Lossless Join Decomposition in DBMS in HINDI Part-1

[@KNOWLEDGEGATE_kg]

For complete DBMS, check out this video: kzbin.info/www/bejne/j4PRm3qbhsemfrM

[@sachinkaushik2932]

Mandatory Properties 1. all attributes of the parent table, should be in child table. 2. there should be at least one common attribute in both tables. 3. the common attribute should have unique/distinct values which means that attribute should be candidate key.

[@rainachoudhary6861]

@18je0367_Ishan Thapa 😒

[@crookshanksacademy]

thanks

[@ramgurnani9723]

sir please make videos on SQL and Relational Algebra. Its a humble request. If anybody want please like the comment

[@somethingsomething2825]

Done

[@Ankit-we8ym]

#sir dil aur dimag se thanks a lot .Always feel awesome and blissed when watch your lectures ,thanks for creating this for all of us student community .I promise to make you feel proud .

[@alapanroy1114]

Thanks sir... Apki wajese exam e acchey marks aaigi ab... Clg m kuch samjhaya nhi.. shrif kehe diya aise hoga.. aur kuch nehi.. thanks a lot sir.

[@KNOWLEDGEGATE_kg]

🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg 🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg

[@deepchandra9031]

SIR Plz add lectures on 4NF and 5 NF

[@devbachani2487]

sir you are god.....best explaination....sir I am a Nirma University student, unfortunately i couldnt meet you sir....Will always be grateful for your lectures....

[@KNOWLEDGEGATE_kg]

Thanks a lot dear @Dev for your kind words & generous feedback ❤ Glad to know that you are liking our content, keep supporting & stay connected for more upcoming videos 👍

[@adityavinodk]

Great simple understandable explanation. Good job!

[@dibyadas8924]

NORMALISATION AUR FD KO ITNA CRYSTAL CLEAR TARIKHE EXPLAIN KIYE HAIN SIR THANKS A LOT SIR FOR SUCH VIDEOS SALUTE SIR 🙏🙏🙏🙏

[@KNOWLEDGEGATE_kg]

Thanks a lot Dibya.. Do visit our website www.knowledgegate.in for more courses and contents. Keep learning and supporting !!

[@ayushprakash1766]

Sir all your lectures are truly amazing

[@KNOWLEDGEGATE_kg]

Thanks a lot dear Ayush, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@mokshadayadav4876]

Thanks sir mujhe class me samjh nhi aa rha tha par aapke video se pura samajh aa gya Thank you so much sir

[@harpreetv761]

God bless you sir.. you are very good teacher

[@c.danielpremkumar8495]

To follow this lecture, I need a higher clock speed. Nevertheless, this S. Jain is excellent !

[@megha16_]

Your teaching style is amazing. Bht easily smjh aa gya. Thankyou ✨💛

[@weekendvibess]

Love you sir !!! lots of love for you and huge respect for your diligence .

[@syedaiman5705]

Pj never disappoints

[@santoshprasadyadav7314]

Dandwat pranam sir 🙏🙏🙏🙏 bahut badhiya samjhaya hai sir

[@Satvikshukla0007]

Best lossless join decomposition video on KZbin

[@machinelearningfromscratch9873]

sir please upload lecture video of relational algebra and sql.

[@RohIt_bhopali]

Amazing lectures, kindly a video on Different types of keys like Surrogate,Foreign and Alternative key that you left for separate video and also on Conversion of ER to Relational along with Weak strong entity concepts. And lastly B,B+ trees.

[@abhishekhegde3913]

Dil Khush ho Gaya boss! Keep Growing !

[@Aarzoo_Tamanna]

Thanks a lot sir,way of explanation is very easy and simple.I'm really thankful to u

[@sarat6782]

Brilliant Lecture!

[@gouravsharma1952]

sir also uploads video on dependency preserving

[@vintagecricketedits535]

Sir...please add lectures on SQL and relational algebra & calculus

[@raghunathbhattacharjee]

Beautiful explanation sir

[@kalpanaverma1269]

✔👌superb lecture !

[@KNOWLEDGEGATE_kg]

Thank you Kalpana.. Do visit our website www.knowledgegate.in for more courses and contents. Keep learning and supporting !!

[@shivrajahirwar4334]

very nice explanation sir

[@milanjain.2564]

Sir aap itne inteligent kase ho???Mai bhi apki tarah banana chahti ho.u r superb sir.

[@RanjanKumar-pg6om]

Pado ache se ho jayogi

[@nirmalpatel155]

din mai ek baar muth maro

[@anandkumar.3307]

thank you so much sir

[@anupamsinghchoudhary]

Aap jabardsttt padhaate h sir.. khatarrnaaK...

[@shivangimishra9723]

Hatsoff to this explaination sir.

[@ashishghosh4735]

Upload just in time before my semester DBMS examinations. Lovely. :D

[@kajalsandhu3022]

👍 thankyou sir you are great

[@KNOWLEDGEGATE_kg]

So nice of you,visit www.knowledgegate.in for more courses and content !

[@CSE_11]

you are fantastic sirji

[@KNOWLEDGEGATE_kg]

Thanks a lot for your kind words ❤ Keep learning & supporting! Stay tuned for more amazing contents & upcoming videos 👍😊

[@shashankmishra377]

Well I have a question, In 3rd condition what you mention was about the uniqueness of common attribute B but I have a point, if the common attribute B is determining the value of C in table R2 then itself it will have unique value for C, otherwise dependency will not exist. Then what is the point to write the 3rd condition?

[@anjithaprakash43]

Sir,please make more videos in English. Your videos are awesome

[@subhajitbehera98]

Very nice sir app bahat achaese problem ko solve kardeteho

[@harpreetsandhu7697]

Thank you awesome lecture

[@RohIt_bhopali]

Sir, hope you are doing well. Bas ek request hain, please make videos on JOINS and its types and the division operator. Also do the rest remaining parts of dbms. Pranaam

[@saketborkar2114]

Best explain sir

[@KNOWLEDGEGATE_kg]

Thanks a lot dear Saket, keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents !

[@ajitsafeway]

Great Sanchit ..

[@statusqueen7300]

Dost aap bohot acha padate ho

[@hsygtgh6911]

thanks so much sir your vedio is very nice

[@SushantKumar-xr3fc]

nice explanation......clear n precise

[@nishu2605]

Sir please please make video on mapping of ER model to Relational model

[@soniparveen3794]

Vry nice

[@ramanjha2277]

You are an original in the world of duplicates .

[@Aabara_ka_dabara]

HAPPY BIRTHDAY SIR 🥰 ... AND KEEP MAKING AWESOME CONTENT... KEEP HEALTHY , KEEP GROWING

[@KNOWLEDGEGATE_kg]

Thanks dear 😍Keep supporting & stay connected 👍😊

[@debolinasaha7379]

Awesome explanation sir. Thank you

[@jatindesai8345]

Thank you for your explanation 👍👍

[@LawStation24]

Awesomely explained👍

[@manjitdhoot]

if the common attribute is itself a key then it will be there in both the tables definitely

[@anurag9110]

Sir how can we apply the lossless conditions for more than 2 decomposed tables?

[@shikha2751]

great explanation sir.

[@shadabiakram5283]

Thank u so much sir.....

[@dharmendraparmar1788]

greatly explained.

[@himanidadem]

sir, Is lossless decomposition applicable only 5th normal form or for every normal form??

[@know9242]

Thanks....sir

[@shivaclasses1683]

Tysm sir

[@gouravsharma1952]

thanks sir

[@AditiVerma825]

Thanku sir Sir candidate key or key both are same ?

[@Good-tz8ep]

❤️❤️💕💕

[@gourabgermany]

Thanks sir!

[@snehaedke3504]

Thank you

[@kartiksingh5274]

Sir, if the table is decomposed into more than two tables?

[@muditjantwal4413]

padh le fir

[@manavshah4783]

sir if my table has a huge amount of attribute & i decomposed that table then after combine of table how could i find that it is lossless or lossy. As checking each & every attribute in a table will take a huge amount of time. Then how can i do this without wasting time

[@studyonline3236]

starts at 4:22

[@abhijeetvarun7185]

best

[@Cloudkitchen701]

Sir but Jo last example m 1option h usme x candidate key Kaise hai bcz hum x se w prr nhi pahuch paa rhe hein toh WO 1 option b sure nhi h

[@taha7shaikh]

Thank you sir

[@KNOWLEDGEGATE_kg]

You're welcome! Keep learning & stay connected! You can also check out our website www.knowledgegate.in for more amazing videos & contents👍😊

[@saurabhs2229]

sir please tell me some book for the rdbms

[@jatindesai8345]

Sir when I can get your notes

[@tanmaysaxena1943]

Sir yahi 5 normal form hoti hai ...??

[@avinashchaudhary4231]

Dont know how 34 people disliked. Thank you sir.

[@adityagupta435]

Sir aapko bharat ratna milna chahiye

[@skp7230]

Exam kee eek raat pehle padha... Aur phor maine exam ki keh ke li😊

[@muditjantwal4413]

kitni li

[@apoorvbansal2179]

sir, yr app bahut repeat karte ho chizo ko

[@KiranKumar-mt3of]

Sanchit ji.. Real-time example se be explain Kiya karo Kabi tho... Hamesha a, b, c ke piche pade hui aap...

[@harshjoshi6257]

16 minute me aur kitna chahiye bhai tujhe

[@shivangigoyal3547]

Sir pls make videos on SQL and relation algebra .

[@ankitmehta4133]

thanks a ton

[@nikitasinha8181]

Thank you so much sir

[@KNOWLEDGEGATE_kg]

You're welcome dear @Nikita❤ Keep learning & supporting! You can also check out our website www.knowledgegate.in for more amazing videos & contents👍

[@cvismenu]

Thanks a ton

[@rohanm2793]

Sir, plzz make video on 4th normal form also

[@murkyPurple123]

Thanks!

[@sujalgoel3090]

thanks sir

[@RaviSingh-yf6jd]

Thanks sir

[@ankitathakur5989]

Tnq sir ji

[@askariaziz4163]

thanks sir

[@badal8435]

Thank you sir

[@NishaSharma-nd1dk]

Thanks sir g