Need help with sql transaction question. Please explain how to reach the solutions for the questions below.
Consider the universal relation
EMPLOYEE(ID, First, Last, Team, Dept, Salary)
with the following set F of functional dependencies:
ID à First
ID à Last
First, Last à ID
Last à Team
ID à Dept
ID à Salary
Salary à Dept
a. Identify candidate keys of EMPLOYEE.
b. Construct a decomposition of EMPLOYEE into relations in 3NF that preserves dependencies. How can you be sure that your decomposition is dependency-preserving?
c. Are all of the relations in your decomposition in BCNF? Either explain why they are, or identify one that is not and explain why it is not. (Note that for a relation to be in BCNF, the determinants of all functional dependencies in the relation must be superkeys of that relation - not superkeys of the original universal relation.)