dependencies Given the schema R(A,B,C,D,E) with the following set F of functional E AC AB...

Transcribed Image Text:

dependencies Given the schema R(A,B,C,D,E) with the following set F of functional E → AC AB - BE AC → CD BE → BC C E D → C Perform the following tasks: a) (10 pts.) Compute the closure of the set of attributes (BE) step by step by explaining the reason why each attribute belongs in that closure. b) (10 pts.) Find a superkey for R different from (A.B.C.D.E} and prove that it is a superkey. dependencies Given the schema R(A,B,C,D,E) with the following set F of functional E → AC AB - BE AC → CD BE → BC C E D → C Perform the following tasks: a) (10 pts.) Compute the closure of the set of attributes (BE) step by step by explaining the reason why each attribute belongs in that closure. b) (10 pts.) Find a superkey for R different from (A.B.C.D.E} and prove that it is a superkey.