Re: one record or many?

From: B. Hawes <bhawes_at_satx.rr.com>
Date: 22 Jul 2002 08:09:31 -0700
Message-ID: <d478259.0207220709.7b0f8cd0_at_posting.google.com>


"Jeffrey Baler" <jbaler_at_hcri.harvard.edu> wrote in message news:<M3CZ8.20003$2v1.12210_at_nwrddc01.gnilink.net>...
> Hello all,
>
> 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?
>
> thanks in advance,
> JB

   Without knowing the contents of your form, we can only advise thats it's generally a bad idea to ever design your tables based purely on form or screen content. You may well have multiple entities represented that should be broken into 2, 3 or more tabes.

-bjh Received on Mon Jul 22 2002 - 17:09:31 CEST

Original text of this message