Normalising my data

[PraxxtorCruel]

Hi guys,

need a little help here, I've got to normalise the following data which is (UNF) currently all the way to 3NF. Below is what I've currently accomplished but am not sure if I have done it correctly.

For 1NF I did:

TABLE 1:

SANDWICH CODE [-PRIMARY KEY-]
SANDWICH DESCRIPTION
TOTAL PRICE
_________________________________________

TABLE 2:

ORDER NO [-PRIMARY KEY-]
SANDWICH CODE [-PRIMARY KEY-]
DATE OF ORDER
COMPANY NO
COMPANY NAME
COMPANY ADDRESS
POSTCODE
CUSTOMER ID
QUANTITY
PRICE

NF2 I DID:

TABLE 1:
SANDWICH CODE [-PRIMARY KEY-]
SANDWICH DESCRIPTION
TOTAL PRICE
________________________

TABLE 2:
ORDER NO [-PRIMARY KEY-]
DATE OF ORDER
COMPANY NO
COMPANY NAME
COMPANY ADDRESS
POSTCODE
CUSTOMER ID
_____________________________

TABLE 3:
ORDER NO [-PRIMARY KEY-]
SANDWICH CODE [-PRIMARY KEY-]
QUANTITY
PRICE

Can anyone help me out if possible thanks?

 

[ian54]

Your PRICE and TOTAL PRICE are the wrong way round.

Table 1 (SANDWICHES)
SANDWICH CODE
SANDWICH DESCRIPTION
PRICE

Table 2 (COMPANIES)
COMPANY NO
COMPANY NAME
COMPANY ADDRESS
POSTCODE
CUSTOMER ID

Table 3 (ORDERS)
ORDER NO
DATE OF ORDER
COMPANY NO
SANDWICH CODE
QUANTITY

Not sure about the CUSTOMER ID, if this should be in a separate CUSTOMER-COMPANY table.

I don't think you need TOTAL PRICE in 3NF.