Answered You can hire a professional tutor to get the answer.
QUESTION
Consider the following relation schema R(A, B, C, D, E, F) with the following functional dependencies: AC-gt;F, B -gt;D, AB-gt;CEF, ACE-gt;B, and...
Consider the following relation schema R(A, B, C, D, E, F) with the following functional dependencies: AC->F, B ->D, AB->CEF, ACE->B, and AEF->BC. Please complete the following:
- Give all the candidate keys for relation schema R(A, B, C, D, E, F) under the set of FDs. Please describe, illustrate, and explain your solution in detail.
- Is Relation R in the 3rd Normal Form? If yes, why and explain in detail. If no, show which FD violates the 3NF condition and explain why in detail.
- Is Relation R in BCNF? If yes, why and explain in detail. If no, show which FD violates the BCNF condition and explain why in detail.
- Try to decompose relation schema into several relational schemas in BCNF. Please describe, illustrate, and explain why each decomposition step is desirable in detail.
