R a b A1 B1 A2 B2 A3 B1 A1 B2 A2 B2 A3 B2 A1 B4 A2 B4 S A A1

R

a

b

A1

B1

A2

B2

A3

B1

A1

B2

A2

B2

A3

B2

A1

B4

A2

B4

S

A

A1

A3

T

B

B2

B4

Please indicate which of the following statement is correct?

a. Table R can be divided by Table S

b. Table R can be divided by Table T

c. Both A and B are correct

d. Neither A nor B is correct

a

b

A1

B1

A2

B2

A3

B1

A1

B2

A2

B2

A3

B2

A1

B4

A2

B4

Solution

Given, Relation R, S, and T.

Now, R divided by S:

R/S = (A, B / A) = B

So,

In above,

A1 has B: B1, B2, B4

A3 has B: B1, B2

B1, B2 are common in both A1 and A3, So the resultant relation has tuples B1 and B2.

Now, R divided by T:

R / T = (A, B / B) = A

So,

In above,

B2 has A: A1, A2, A3

B4 has A: A1, A2

A1, A2 are common in both B2 and B4, So the resultant relation has tuples A1 and A2.

Now, From above, It is clear that,

a. Table R can be divided by Table S

and

b. Table R can be divided by Table T

So, c. Both A and B are correct.

So, the answer is c. Both A and B are correct.

B
B1
B2
R a b A1 B1 A2 B2 A3 B1 A1 B2 A2 B2 A3 B2 A1 B4 A2 B4 S A A1 A3 T B B2 B4 Please indicate which of the following statement is correct? a. Table R can be divided
R a b A1 B1 A2 B2 A3 B1 A1 B2 A2 B2 A3 B2 A1 B4 A2 B4 S A A1 A3 T B B2 B4 Please indicate which of the following statement is correct? a. Table R can be divided

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site