Question: Consider the attribute set R = ABCDEGH and the FD set F = {AB C, AC B, AD E, B D, BC A, E

Consider the attribute set R = ABCDEGH and the FD set F

 

Consider the attribute set R = ABCDEGH and the FD set F = {AB C, AC B, AD E, B D, BC A, E G}. 1. For each of the following attribute sets, do the following: (i) Compute the set of dependencies that hold over the set and write down a minimal cover. (ii) Name the strongest normal form that is not violated by the relation containing these attributes. (iii) Decompose it into a collection of BCNF relations if it is not in BCNF. (a) ABC, (b) ABCD, (c) ABCEG, (d) DCEGH, (e) ACEH 2. Which of the following decompositions of R = ABCDEG, with the same set of dependencies F, is (a) dependency-preserving? (b) lossless-join? (a) {AB, BC, ABDE, EG} (b) (ABC, ACDE, ADG}

Step by Step Solution

3.44 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a i The set of dependencies that hold over the set is AB C AC BADE BD BCA E G The minimal cover is A... View full answer

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 General Management Questions!