DBMS - Problem-1 To check Whether a Decomposition is Lossless

DBMS - Problem-1 To check Whether a Decomposition is Lossless
Watch more Videos at www.tutorialspoint.com/videot...
Lecture By: Mr. Arnab Chakraborty, Tutorials Point India Private Limited

[@TutorialsPoint_]

To Get Certification, Click Here: bitly.ws/PXXy
Use coupon "CZcams12" to get ‘’FLAT 12%’’ OFF at Checkout.

[@prakharladhwe8159]

Thank You so very much sir. You were literally the saviour in all my Rgpv Exams. Keep up the good work.

[@mendingbrokenpieces]

Based on the algorithm, you have explained nicely sir. Thank you

[@hritiksarkar7926]

Thank you Sir... You Just Help me alot on my work

[@monikavats5796]

thank you sir...well explained

[@souravdindafitness5177]

Awesome explained

[@sanjayksah7765]

thanku very much sir

[@monotyc6085]

thank you bro

[@sandipsarkar5261]

But sir one previous year gate question(cs 2001) there is no relation given...only dependencies are given...how can I find the relation...

[@anunourin8362]

thnkuu sirr

[@Arjun-jn8js]

thank you sir

[@CSSCHOOL-ut7ub]

Nice explained👌👌

[@mr.ak.2000]

I've a question.
Given R(A,B,C,D,E) with the functional dependencies FDs{A -> BC , CD -> E , B -> D , E -> A} are decomposed into R1(A,B,C,D) & R2(C,D,E).
Check whether the decomposition is dependency and lossless or not.

[@shibani6821]

Did u get answer for this..

[@projecttruth3610]

It will be Lossless decomposition

[@anishmanandhar1203]

the another way is check for attr (r1) ∩ attr (r2)=CD which is a candidate key for r2 so it is lossless

[@Lyricverse116]

Yeah this is lossless

[@jungkookseuphoricfield4199]

This method is not at all useful for all problems,its working only for the problem you taught

[@sohammondal9373]

Is he bangali ???

[@dpxy1599]

Yese