QUESTION 3 Given the dependency diagram shown below answer questions part a,b and c Primary keys are underlined. (a) Identify and discuss each of the indicated dependencies. (8 marks) (b) Create a database whose tables are at least in 2NF, showing the dependency diagrams for each (c) Create a database whose tables are at least in 3NF, showing the dependency diagrams for each table. (10 marks) Total (25 marks)