Guys i need help to normalise the following attributes. I asked for help from my tutor but i really don't understand what to do, here is what he wrote to me:

"This is the list of attributes you start with normalisation. They are
basically the information you should have collected from on an invoice. The huge table is labelled as Purchase therefore there’s only one PK for this table.

This is Unnormailsed form. The first step is to identify repeated groups – those attributes with exactly the same value on each invoice.

The Order ID on different invoice will be different so it is not a part of repeated group. What about OrderItemName, Quantity? The way to help you identify them is to create a mock table “Purchase” and fill it up with some fake data."


Attributes:

PURCHASE

ORDER_ID PK
DATE
CUSTOMER_ID
FIRST_NAME
LAST_NAME
ADDRESS
POSTOCDE
PHONE
CREDIT_CARD_NO
CREDIT_CARD_TYPE
OrderItemCode
QuantityOrdered
STOCK_CODE
StockItemNAME
UnitPrice
SUPPLIER_ID
SUPPLIER_NAME