From: dcs@proton.chem.yale.edu (Dave Schweisguth)
Subject: Re: data structure question
Date: 1997/07/07
Message-ID: <5pqo8l$eui@news.ycc.yale.edu>#1/1
References: <5p90l3$l2o@nbc.ksu.ksu.edu>
Organization: Dept. of Chemistry, Yale University
Newsgroups: comp.databases.oracle.misc



Sanjeev K Akkina (ska@ksu.edu) wrote:
: I am looking for a way that I can store the following data into a table:
:
: Name
: Date
: Plot1
: Plot2
: Plot3
: ...
: Plot50

The table should have columns name, date and plot. Each "row" of the table
you proposed will become 50 rows. This is a basic database-design issue one
needs to get over right away: use rows, not columns, to iterate.

Cheers,

--
| Dave Schweisguth                     CuraGen Corp., Bioinformatics Dept. |
| dcs@proton.chem.yale.edu             New Haven, Connecticut              |
| http://proton.chem.yale.edu/~dcs/    My opinions are my own.             |
| For compliance with the NJ Right to Know Act: Contents partially unknown |