b) The ORDER record design can be written as:

ORDER(OrderNumber, OrderDate, CustomerNumber, CustomerName, CustomerAddress,(ItemNumber, ItemDescription, UnitPrice, OrderQuantity))

Based on the above relation structure, create a new relation structure using record layout in:

i) First Normal Forms (1NF) (3 marks)

ii) Second Normal Forms(2NF) (3 marks)

iii) Third Normal Forms (3NF) (4 marks)