Minimal keysWe have the attributes: {A, B, C, D}.Consider the following functional dependenciesA, B -> CA, C -> BB, D -> A, CA, B, D -> CC -> A, DFind all minimal keys.Write one minimal key per line and the attributes separated by commas. For example, like:{A,B}{B,C,D}

Minimal keysWe have the attributes: {A, B, C, D}.Consider the following functional dependenciesA, B -> CA, C -> BB, D -> A, CA, B, D -> CC -> A, DFind all minimal keys.

1. Normal formsWe have the attributes: {A, B, C, D, E, F, G}.Consider the following functional dependenciesA, C, F -> D, EA -> CA, C, F -> B, EF -> A, BA, C -> E, F, GA, F, G -> C, DB, C -> DB -> AThe minimal keys are:{B}{F}{A}Determine whether these functional dependencies are in the following normal form(s):Boyce Codd normal form2. Normal formsWe have the attributes: {A, B, C, D, E, F, G}.Consider the following functional dependenciesF -> E, GA, G -> C, D, EA, B -> FD -> F, GB, E, F -> D, GA, D, E -> B, FB, D, F -> A, EF, G -> B, D, EThe minimal keys are:{D}{F}{A, B}{A, G}Determine whether these functional dependencies are in the following normal form(s):Boyce Codd normal form3. Normal formsWe have the attributes: {A, B, C, D, E, F, G}.Consider the following functional dependenciesB, C, D -> E, GB -> A, ED, E -> CA, C -> B, D, EB -> C, DD, F, G -> AG -> BB, C -> FThe minimal keys are:{B}{G}{A, C}{A, D, E}Determine whether these functional dependencies are in the following normal form(s):Boyce Codd normal form4. Normal formsWe have the attributes: {A, B, C, D, E, F, G}.Consider the following functional dependenciesA, F, G -> CC, F -> GB -> C, FA, D, E -> CE, F, G -> B, CA, B, F -> D, E, GB, C -> A, DA, C, F -> GThe minimal keys are:{B}{C, E, F}{E, F, G}{A, D, E, F}Determine whether these functional dependencies are in the following normal form(s):Boyce Codd normal form5. Normal formsWe have the attributes: {A, B, C, D, E, F, G}.Consider the following functional dependenciesD -> BF -> AB, C, D -> E, FA -> GE, F -> CA, D -> E, FE, F -> GC, F -> A, EThe minimal keys are:{D, F}{C, D}{A, D}Determine whether these functional dependencies are in the following normal form(s):Boyce Codd normal form6. Normal formsWe have the attributes: {A, B, C, D, E, F, G}.Consider the following functional dependenciesC -> EE -> D, GD -> FF -> B, GF -> C, D, EG -> FC -> FC, G -> EThe minimal keys are:{A, E}{A, C}{A, F}{A, G}{A, D}Determine whether these functional dependencies are in the following normal form(s):Boyce Codd normal form

We have the attributes: {A, B, C, D, E, F, G}.Consider the following functional dependenciesB, E -> C, D, FA, G -> B, CA, F -> B, DF, G -> ED, E -> A, B, GD, E -> A, BThe first step in computing the normal form, is to derive a canonical (minimal) set of functional dependencies. We have already done this first step for you. The following is a set of canonical functional dependencies (for the dependencies shown above):B, E -> DD, E -> AA, F -> DA, F -> BA, G -> BB, E -> FF, G -> EA, G -> CD, E -> GApply the synthesis algorithm to derive a Boyce-Codd normal form for the relation R(A, B, C, D, E, F, G).Write your answer as followsFunctional dependencies: write one dependency per line, for exampleA,B -> CB,C,D -> A,FSplitting steps: write one split per line, for examplespliting R(A,B,C,D) into S(A,B,C) and T(A,D) -- the relation names are not importantspliting (A,B,C) into (A,B) and (A,C) -- and can even be omitted...

DeterminantsWe have the attributes: {A, B, C, D}.Consider the following functional dependenciesD -> CA, C -> DB, C -> AB, C -> A, DC, D -> BFind all determinants for {B, D}.Write one determinant per line and the attributes separated by commas. For example, like:{A,B}{B,C,D}

What is the primary condition for a set of functional dependencies to be considered minimal?a.There must be at least one trivial FD presentb.Every FD must have multiple attributes on its right-hand sidec.No FD can be removed without altering the set's meaningd.Any FD can be replaced with another equivalent FD