I have a question regarding natural join operations in multivalued dependencies. I know that a join operator joins two tables on similair attributes, however I have a hard time to figure out how to approach the following excersise. A nudge in the right directon will be helpful±
There are 7 tuples, B (meeting nr), T (time of meeting B), L (location of meeting b), I (organizer of B), D (participant of B), R (rol of participant D in B), E (email of D).
Several meetings can be held at the same time but at another location, an organizer is also an participant, each participant has on role at most, a participant can have multiple email addresses.
I need to prove or disprove the following statement:
BTLIDRE = BE \natural BTLIDR BTLIDRE = BDRE \natural BTLI BTLIDRE = BD \natural BTLIDR
My initial reasoning was that since both sides contain common attributes either B or BD, all those statemments are valid, however that didn't seems to be correct according to the answers. How can I approach this question?