MS Access and FileMaker...

can you help - access

Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2005

Posts: 1

Reputation: helpwanted is an unknown quantity at this point

Solved Threads: 0

helpwanted helpwanted is offline

Offline

Newbie Poster

can you help - access

Jul 3rd, 2005

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.

Attached Files

Copy of Warehouse.zip (40.4 KB, 3 views)

•

Join Date: Jul 2005

Posts: 13

Reputation: Estuardo is an unknown quantity at this point

Solved Threads: 0

Estuardo

Offline

Newbie Poster

Re: can you help - access

Jul 19th, 2005

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