Posted by louisyoung187@hotmail.com on 11/02/06 12:39

> I'm intrigued. How would you normalise the data further - the date is a
> unqiue field and their would be no benefit in storing the prices in a
> separate table

Well, remember that all non-key fields needs to be dependant on the
primary key and only on the primary key. Date seems to be an attribute
of an Order (correct me if I'm wrong) and Price seems to be an
attribute of a product, so price would need to be in a products table
and Date would need to be in an orders table. The fact that you have a
lot of repeating groups, e.g. 100|100|100 shows that the data isn't
properly normalised. This is not something I can teach you in one
e-mail, so please have a look at the following link:

http://www.utexas.edu/its/windows/database/datamodeling/index.html

[Back to original message]