I'm afraid we can't tell you anything with virtually no information given by
you. What is a product? Which are the informations you want to hold about a
product? How do they relate to each other? What is the purpose of the
database? Which sort of informations are people supposed to get out of it?
If you answer these questions for yourself, the design should become visible.
If any doubts, ask, but please be specific.
Stefan
P.S: If interested, the ER diagram of a chemical database can be found here:
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/*checkout*/nmrshiftdb/nmrshiftdb/doc/ER-Diagram_for_NMRShiftDB.ps?rev=HEAD&content-type=aplication/ps
But "chemical" is a wide field ...
Am Monday 04 April 2005 23:47 schrieb Dave Shariff Yadallee - System
Administrator a.k.a. The Root of the Problem:
> I have a customer who has sent my close to 300 chemical products
> in word format? How do I translate this into mysql tables?
--
Stefan Kuhn M. A.
Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de)
Zülpicher Str. 47, 50674 Cologne
Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786
My public PGP key is available at http://pgp.mit.edu
