Normalisation

[Doball]

Is the normalisation below correct, if not could you please correct me?

Flat File (0NF)
(OrderNo, CustomerName, PayeeAddress, ShippingAddress, OrderDate, ShipDate, ItemNo, Description, Quantity, UnitPrice)

1NF

ORDER
(OrderNo, CustomerName, PayeeAddress, ShippingAddress, OrderDate, ShipDate)

ITEM
(ItemNo, Description, Quantity, UnitPrice)

2NF

ORDER
(OrderNo, OrderDate, ShipDate, ItemNo)

ITEM
(ItemNo, Description, Quantity, UnitPrice)

CUSTOMER
(CustomerName, PayeeAddress, ShippingAddress)

3NF

ORDER
(OrderNo, OrderDate, ShipDate, ItemNo)

ITEM
(ItemNo, Description, UnitPrice)

PRICE
(UnitPrice, Quantity)

CUSTOMER
(CustomerName, PayeeAddress, ShippingAddress)

[drawmack]

no it's not normalized because you're repeating fields

[Doball]

If one of the attributes is underlined it means its a primary key. For example:

OrderNo

If one of the attributes is in italics it means its a foreign key. For example:

ItemNo

[onyx]

The Price table makes no sense at all to me.

Are you trying to say that if something is a particular price then it can only have a certain quantity attatched to it?

What can be done:

The description and item number will remain constant and hence you should have a table:

ItemDesc
itemno (primary key), desc, unitprice

I am assuming here that a customer will place an order, hence you should have:

Order
customername (primary), itemno(primary), quantity

However that would mean that a customer could only have one entry for every itemno purchased. Hence you may need to expand on the above.

Also you shouldnt be using things like customer name as a primary key, you should think about introducing customerids.

I have not answered your question totally and probably you will find it more benificial to look on google for infomation on how to normalise data and examples to work through in order to apply this knowledge to your own data. Homework is about understanding not just getting the answer right 😉

[Doball]

Cheers for your help! 😃