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 .

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

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

[@deepchandra9031]

SIR Plz add lectures on 4NF and 5 NF

[@adityavinodk]

Great simple understandable explanation. Good job!

[@harpreetv761]

God bless you sir.. you are very good teacher

[@abhishekhegde3913]

Dil Khush ho Gaya boss! Keep Growing !

[@mokshadayadav4876]

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

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

[@megha16_]

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

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

[@weekendvibess]

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

[@Satvikshukla0007]

Best lossless join decomposition video on KZbin

[@c.danielpremkumar8495]

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

[@ashishghosh4735]

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

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

[@syedaiman5705]

Pj never disappoints

[@sarat6782]

Brilliant Lecture!

[@santoshprasadyadav7314]

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

[@anupamsinghchoudhary]

Aap jabardsttt padhaate h sir.. khatarrnaaK...

[@raghunathbhattacharjee]

Beautiful explanation sir

[@shivrajahirwar4334]

very nice explanation sir

[@Aarzoo_Tamanna]

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

[@kalpanaverma1269]

✔👌superb lecture !

[@KNOWLEDGEGATE_kg]

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

[@shivangimishra9723]

Hatsoff to this explaination sir.

[@ajitsafeway]

Great Sanchit ..

[@anandkumar.3307]

thank you so much sir

[@machinelearningfromscratch9873]

sir please upload lecture video of relational algebra and sql.

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

[@kajalsandhu3022]

👍 thankyou sir you are great

[@KNOWLEDGEGATE_kg]

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

[@ramanjha2277]

You are an original in the world of duplicates .

[@harpreetsandhu7697]

Thank you awesome lecture

[@gouravsharma1952]

sir also uploads video on dependency preserving

[@SushantKumar-xr3fc]

nice explanation......clear n precise

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

[@debolinasaha7379]

Awesome explanation sir. Thank you

[@statusqueen7300]

Dost aap bohot acha padate ho

[@hsygtgh6911]

thanks so much sir your vedio is very nice

[@LawStation24]

Awesomely explained👍

[@anjithaprakash43]

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

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

[@jatindesai8345]

Thank you for your explanation 👍👍

[@vintagecricketedits535]

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

[@subhajitbehera98]

Very nice sir app bahat achaese problem ko solve kardeteho

[@soniparveen3794]

Vry nice

[@shikha2751]

great explanation sir.

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

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

[@dharmendraparmar1788]

greatly explained.

[@shadabiakram5283]

Thank u so much sir.....

[@Aabara_ka_dabara]

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

[@KNOWLEDGEGATE_kg]

Thanks dear 😍Keep supporting & stay connected 👍😊

[@nishu2605]

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

[@Good-tz8ep]

❤️❤️💕💕

[@studyonline3236]

starts at 4:22

[@know9242]

Thanks....sir

[@gourabgermany]

Thanks sir!

[@snehaedke3504]

Thank you

[@gouravsharma1952]

thanks sir

[@anurag9110]

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

[@shivaclasses1683]

Tysm sir

[@manjitdhoot]

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

[@abhijeetvarun7185]

best

[@avinashchaudhary4231]

Dont know how 34 people disliked. Thank you sir.

[@himanidadem]

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

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

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

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

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

[@skp7230]

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

[@muditjantwal4413]

kitni li

[@adityagupta435]

Sir aapko bharat ratna milna chahiye

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

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

[@ankitmehta4133]

thanks a ton

[@cvismenu]

Thanks a ton

[@murkyPurple123]

Thanks!

[@shivangigoyal3547]

Sir pls make videos on SQL and relation algebra .

[@sujalgoel3090]

thanks sir

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