in Databases
261 views
0 votes
0 votes

R is divided into R1 and R2 ,but since there is no common attribute in R1 and R2, so it should form lossy join,as for loseless join the common attribute has to be key in one of the table.But here the image above,it is comming as loseless join.Can someone please check?

in Databases
261 views

2 Comments

@Rahul,

lossless join is never checked by seeing particular instance...

what if in future, some tupple (a,b,d,6,9) is added, then it will become lossy....

therefore lossless join is never checked for a particular instance, it is checked for general schema taking functional dependecy in consideraion

2
2
Got that.Thanks a lot
0
0

Please log in or register to answer this question.