Question 2. Normalisation (10 marks) Consider the two relations below. They are in BCNF with primary key attributes underlined Customer(custlD, firstname, lastname) Item(itemNo, desc, price) A Transaction relation as below is proposed to keep data for orders. Each order is by one customer and it can contain multiple items with their quantities. Transaction(custlD, itemNo, orderlD, quantity, discount, amount_due) Given the FDs below orderlD custlD, amount_due, discount orderlD, itemNo quantity custlD, orderlD amount_due, discount Answer questions. 2.1 (4 marks) Give the minimal basis for the given FDs. 2.2) 2 marks) The Transaction relation is not in BCNF or 3NF. Give the reason. 2.3) (4 marks) Follow the BCNF/3NF decomposition algorithm to decompose Transaction into relations in BCNF or 3NF. Give the relations after decomposition and specify the primary key and any foreign keys for each relation