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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]