can you help - access
 

I have a table containing the fields:


DeliveriesID // SupplierID // Date // ProductID // QTY // costprice // totalprice


I need to make this table 1NF. I know I should make related tables but I'm not sure what fields go with which.

Re: can you help - access
 

G'd evening helpwanted!
Requeriments to be in the 1NF are:
1. The rows are not ordered.
2. The columns are not ordered.
3. There are no duplicate rows.
4. Every row/column intersection contains exactly one domain value and nothing else.
5. No irregular columns.

At a glance your table is in 1NF

Storing the Total price, you are breaking the 3NF.

I thing you may want to read more about normalization. Here is an starting point: Database Normalization Basics

Good luck
Estuardo