4.16 Lossless Join Decomposition in DBMS in HINDI Part-1

[@KNOWLEDGEGATE_kg]

For complete DBMS, check out this video: th-cam.com/video/YRnjGeQbsHQ/w-d-xo.html

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

[@KNOWLEDGEGATE_kg]

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

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

[@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 👍

[@deepchandra9031]

SIR Plz add lectures on 4NF and 5 NF

[@adityavinodk]

Great simple understandable explanation. Good job!

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

[@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 ✨💛

[@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 !!

[@harpreetv761]

God bless you sir.. you are very good teacher

[@weekendvibess]

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

[@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 !!

[@Aarzoo_Tamanna]

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

[@mokshadayadav4876]

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

[@sarat6782]

Brilliant Lecture!

[@raghunathbhattacharjee]

Beautiful explanation sir

[@machinelearningfromscratch9873]

sir please upload lecture video of relational algebra and sql.

[@syedaiman5705]

Pj never disappoints

[@Satvikshukla0007]

Best lossless join decomposition video on TH-cam

[@kalpanaverma1269]

✔👌superb lecture !

[@KNOWLEDGEGATE_kg]

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

[@gouravsharma1952]

sir also uploads video on dependency preserving

[@santoshprasadyadav7314]

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

[@ashishghosh4735]

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

[@vintagecricketedits535]

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

[@shivrajahirwar4334]

very nice explanation sir

[@harpreetsandhu7697]

Thank you awesome lecture

[@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 👍😊

[@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

[@abhishekhegde3913]

Dil Khush ho Gaya boss! Keep Growing !

[@studyonline3236]

starts at 4:22

[@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

[@anjithaprakash43]

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

[@ajitsafeway]

Great Sanchit ..

[@anupamsinghchoudhary]

Aap jabardsttt padhaate h sir.. khatarrnaaK...

[@Aabara_ka_dabara]

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

[@KNOWLEDGEGATE_kg]

Thanks dear 😍Keep supporting & stay connected 👍😊

[@hsygtgh6911]

thanks so much sir your vedio is very nice

[@debolinasaha7379]

Awesome explanation sir. Thank you

[@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 !

[@SushantKumar-xr3fc]

nice explanation......clear n precise

[@shivangimishra9723]

Hatsoff to this explaination sir.

[@soniparveen3794]

Vry nice

[@jatindesai8345]

Thank you for your explanation 👍👍

[@LawStation24]

Awesomely explained👍

[@subhajitbehera98]

Very nice sir app bahat achaese problem ko solve kardeteho

[@ramanjha2277]

You are an original in the world of duplicates .

[@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?

[@statusqueen7300]

Dost aap bohot acha padate ho

[@shadabiakram5283]

Thank u so much sir.....

[@Good-tz8ep]

❤️❤️💕💕

[@shikha2751]

great explanation sir.

[@dharmendraparmar1788]

greatly explained.

[@know9242]

Thanks....sir

[@gouravsharma1952]

thanks sir

[@nishu2605]

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

[@shivaclasses1683]

Tysm sir

[@snehaedke3504]

Thank you

[@manjitdhoot]

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

[@gourabgermany]

Thanks sir!

[@abhijeetvarun7185]

best

[@anurag9110]

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

[@avinashchaudhary4231]

Dont know how 34 people disliked. Thank you sir.

[@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👍😊

[@himanidadem]

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

[@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

[@skp7230]

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

[@muditjantwal4413]

kitni li

[@kartiksingh5274]

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

[@muditjantwal4413]

padh le fir

[@AditiVerma825]

Thanku sir
Sir candidate key or key both are same ?

[@adityagupta435]

Sir aapko bharat ratna milna chahiye

[@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

[@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 ...??

[@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

[@apoorvbansal2179]

sir, yr app bahut repeat karte ho chizo ko

[@ankitmehta4133]

thanks a ton

[@cvismenu]

Thanks a ton

[@murkyPurple123]

Thanks!

[@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👍

[@sujalgoel3090]

thanks sir

[@shivangigoyal3547]

Sir pls make videos on SQL and relation algebra .

[@rohanm2793]

Sir, plzz make video on 4th normal form also

[@RaviSingh-yf6jd]

Thanks sir

[@ankitathakur5989]

Tnq sir ji

[@askariaziz4163]

thanks sir

[@badal8435]

Thank you sir

[@NishaSharma-nd1dk]

Thanks sir g