4 Consider Schema Abcdef Following Fds V Fc Eb C Eb Cd E Ac B Keys Table Provide Justifi Q37031158

4. Consider the schema ABCDEF with the following FDs: V = {FC→EB, C→A, EB→CD, E→AC, A→B}. a). What are the keys for this table?Provide justifications. b). Write a CREATE ASSERTION statement toenforce constraint FC→ EB. c). Calculate the minimal cover of V.Show the results after each step. d). Use the 3NF synthesisalgorithm to obtain a lossless and dependency preservingdecomposition into 3NF.

Answer