Question: Consider the following relation: A B C D 10 b1 c1 d1 10 b2 c2 d1 11 b4 c1 d1 12 b3 c4 d1 13

Consider the following relation:

A B C D
10 b1 c1 d1
10 b2 c2 d1
11 b4 c1 d1
12 b3 c4 d1
13 b1 c1 d2
14 b3 c4 d2
15 b1 c1 d2
15 b2 c2 d2

Given the previous extension (state), which of the following dependencies may hold in the above relation?

{AB}{C}

{C}{B}

{A, C, D}{B}

{B}{A, C}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!