3rd normal form!

[Martink]

Can some genius please tell me if my database is in 3rd normal form?


Relationship diagram

Thanks for the help Martin.

 

[jfgambit]

Why is the ProductID linked to the TransactionID in tblTransactions, instread of the ProductID?

 

[Martink]

Accident

It was just a mistake. Sorry, I should have mentioned that.

 

[Mile-O]

In the highlighted table you have a field called CategoryID - is this just data relevant to the table or a foreign key?

 

[Martink]

Just relevant data

it is not a foreign key!

 

[Martink]

When a client order is placed it removes the stock from the product file. When a product falls below a curtain amount it is placed on order in the purchase order table. The purchase order is then sent to the relevant supplier.

Could you please tell me how you think that i should link the tblClientOrder, tblClientOrderDetails, tblDelivery and tblDeliveryDetails to all the other table?

Transaction should function like a till. If some one wants a product now and they are not a existing client and do not want to be one, the transaction is carried out thought the transaction table. It can also be used for refunds. There will also be another form relating to the table to be able to write off stock as damaged, stolen or wastage etc. OH, I think I need to conect transaction to tblClientOrders then, because I need to keep records of dicounts and current prices. I was going to put the client orders thought the "till" manually after they had been completed. I know know if that will work now!

What a mess, arrh!

I hope that this helps you, help me.
Thanks to everyone who has helped me so far it is very much appreciated.

Martin Kingston

 

[KevinM]

Something else to think about....

'UnitsInStock' and 'UnitsOnOrder' is derived data and shouldn't be stored in the Products Table. They need to be calculated via queries.