Database Question

Need help with part (a) (c) (d) (e)

Will leave thumbs up if all good

Question 3 The following table holds data on the sweets produces by a sweet manufacturer. Formulation Shape Colour Price Size star ball cube red pyramid green 150 75 star ball cube green 150 100 pyramid red 100 50 red blue 200 90 100 100 blue 250 50 green 300 90 400 75 The price of a sweet depends on both the colour and the shape of the sweet. However the size of each of the kinds of sweet they produce depends only on the shape of the sweet (a) Write down two functional dependencies using the standard notation. (b) What is the definition of a candidate key? (c) State a candidate key for this table, and show why it is a candidate key. (d) What is the definition of the Second Normal Form? (e) Is this table in the Second Normal Form? (f) Write down a transitive dependency that exists in the table (g) What is the definition of Boyce Codd Normal Form? (h) Write down a functional dependency that demonstrates that the table is not in Boyce Codd Normal Form, saying why (i) How could the table be decomposed into two tables each of which is in Boyce-Codd Normal Form (BCNF)? Your answer should include a clear justification that the tables are in this normal form