can you help - access

Expand Post »

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, 10 views)

Similar Threads

VB: Connect to Access database via ODBC datasource name in Visual Basic 4 / 5 / 6
Disable access to .htaccess in Linux Servers and Apache
Writing to an Access Database in Visual Basic 4 / 5 / 6
Writing to an Access Database using Java... in Java

helpwanted

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jul 2005

Permalink

Jul 19th, 2005

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

Estuardo

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

13 posts
since Jul 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS Access and FileMaker Pro Forum Timeline: How do I replace worksheets in Excel?

Next Thread in MS Access and FileMaker Pro Forum Timeline: Access Security Pop-Up

DaniWeb Message

Cancel Changes

User Name
Password