View Single Post
  #9 (permalink)  
Old 03-11-10, 03:43
healdem healdem is offline
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,246
no
thats sales
a sale is registered from a specific computer/machine
a sale has nothing (directly) to do with a product, expcet that a sale may comprise many products, that many may be a quantity of apples, or a mix of different types of fruit.

I think you need to do some basic reading on table design and normalisation
Fundamentals of Relational Database Design -- r937.com
and
The Relational Data Model, Normalisation and effective Database Design
seem to be oft referred texts
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote