Database design

(a) Using appropriate diagrams to aid in your answer, briefly describe the following concepts: Normalisation including First, Second and Third Normal forms. Primary, Forign and Candidate keys. Functional dependences