Re: one record or many?

From: JRStern <JXSternChangeX2R_at_gte.net>
Date: Thu, 18 Jul 2002 16:34:59 GMT
Message-ID: <3d36ee4c.10809373@news.verizon.net>

On Thu, 18 Jul 2002 16:31:40 GMT, "Jeffrey Baler" <jbaler_at_hcri.harvard.edu> wrote:
>If a paper form is used to capture data in a "table format", with a fixed
>number of rows, how should this translate to a relational table?...should it
>be multiple records with the column attributes named as the paper form has
>named its column headings? Or should it be translated into one record with
>each attribute capturing one field of data from the paper form?

The general form that is more likely to be 3NF (or even 1NF) is to have each row as a record. Do it now, it will save you rework later.

J. Received on Thu Jul 18 2002 - 11:34:59 CDT