User Name Password Register
DaniWeb IT Discussion Community
Home
Forums
Tutorials
Code Snippets
Blogs
Link Directory
All
•
•
•
•
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 429,863 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 2,445 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: Programming Forums

can you help - access

•
•
Join Date: Jul 2005
Location: Portugal
Posts: 13
Reputation: Estuardo is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 0
Estuardo Estuardo is offline Offline
Newbie Poster

Re: can you help - access

  #2  
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
Reply With Quote  
Advertising Opportunities on DaniWeb
Contact Us - Newsletter Archive - Sitemap - Privacy Statement
All times are GMT -4. The time now is 7:37 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC