can you help - access

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 373,545 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,808 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS Access and FileMaker Pro advertiser:

Thread Tools Display Modes

Views: 1614 | Replies: 1

•

Join Date: Jul 2005

Posts: 1

Reputation: helpwanted is an unknown quantity at this point

Rep Power: 0

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

Location: Portugal

Posts: 13

Reputation: Estuardo is an unknown quantity at this point

Rep Power: 4

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