Re: one record or many?
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