Question: In relational databases using closure do the following example R = (A, B, C, G, H, I) F = {A B A C CG H

In relational databases using closure do the following example

R = (A, B, C, G, H, I)

F = {A B A C CG H CG I B H}

(AG)+

1. result = AG

2. result = ABCG (A C and A B)

3. result = ABCGH (CG H and CG AGBC)

4. result = ABCGHI (CG I and CG AGBCH)

Is AG a candidate key?

1.Is AG a super key?

1.Does AG R? == Is (AG)+ R

2.Is any subset of AG a superkey?

1.Does A R? == Is (A)+ R

Does G R? == Is (G)+ R

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!