2. Consider the following relation and the set of functional dependencies (FDs): R = (A B...

Transcribed Image Text:

2. Consider the following relation and the set of functional dependencies (FDs): R = (A B C D E F G H I J K) C-G AEF→BJ DE GJ J-AC F→DGI AF→B DJ G H-ABF B-GH AC D a. Find the minimal cover of FD set (15 pts). Justify your solution. b. Find the candidate key(s) of R (15 pts). c. Identify the best normal form that R satisfies (5 pts). Justify your answer. d. If R is not in BCNF, decompose it into a set of relations that satisfies BCNF (10 pts). 2. Consider the following relation and the set of functional dependencies (FDs): R = (A B C D E F G H I J K) C-G AEF→BJ DE GJ J-AC F→DGI AF→B DJ G H-ABF B-GH AC D a. Find the minimal cover of FD set (15 pts). Justify your solution. b. Find the candidate key(s) of R (15 pts). c. Identify the best normal form that R satisfies (5 pts). Justify your answer. d. If R is not in BCNF, decompose it into a set of relations that satisfies BCNF (10 pts).

Answer rating: 100% (QA)

Solution a Minimal cover of FD set C G J AC F DGI AF B DJ G b Candidate keys of R ACJ ADFJ c Best normal form that R satisfies 2NF d Decomposition of ... View the full answer