An online cooking recipe database has the following data: Recipe id, dish name, dish description, cooking time, ingredient id, ingredient name, ingredient description, ingredient quantity Given that: Recipe id determines dish name, dish description and cooking time; Ingredient id determines ingredient name and ingredient description; Recipe id and ingredient id determine dish name, dish description, cooking time, ingredient name, ingredient description and ingredient quantity. Describe the conditions that a table must meet to be in BCNF. Is the table in BCNF? If not perform normalization to BCNF. Description (5 marks) Process shown (5 marks) Correct relations (10 marks) (b) Explain what a functional dependency is. Give an example. (5 marks) Total (25 marks)