ZZBurgerStoreisstillusingfile-basedmethodintheiroperationalbusiness.Theyrecordthe

customerordersinExcelspreadsheetasshowninTable2.CustomersshouldhavecustomerID,customername andtheirphone number.

OrderID	OrderDate	MenuName	Quantity	CustomerName	Customer PhoneNumber	StaffIDandName
11	30/06/2022	FishBurger	2	William	012- 34567899	301 - Willy
11	30/06/2022	Benjo	2	William	012- 34567899	301 - Willy
12	30/06/2022	ChickenBurger	1	Andrew	012- 1122334	302 - Wendy
13	07/08/2022	MuttonKebabBurger	1	Zach	012- 5555555	301 - Willy
13	07/08/2022	ChickenDoubleCheeseBurger	3	Zach	012- 5555555	301 - Willy

1. Statethenormalformoftheabovetable.Explainyour answer withreasons.

(3marks)

1. Convertthetableintoarelationalschema.Identifytheprimarykey(s)andpartialdependenciesand/ortransitivedependencies.

(6marks)

1. Normalizetherelationalschemain(b)untilthirdnormalform(3NF).Showallyourwork.