can you help - access

Question

helpwanted 0 Newbie Poster

18 Years Ago

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.

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with zip files.

Copy_of_Warehouse.zip (40.41 KB)

2 Contributors
1 Reply
148 Views
2 Weeks Discussion Span
Latest Post 18 Years Ago Latest Post by Estuardo

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

Estuardo 0 Newbie Poster · Answer 1 · 2005-07-20T06:58:26+00:00

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