Re: Database design
Date: Fri, 25 Aug 2000 07:29:56 -0700
Message-ID: <39a6830c$1_2_at_news.pacifier.com>
"py" <py_at_ottawa.com> wrote in message
news:l_lp5.177816$1h3.3293702_at_news20.bellglobal.com...
> Hi,
>
> I have a question I have been debating for some time and I would like your
> thoughts on the subject.
>
> In one Internet application, I have a table with 22 fields. I access
> regurarly only 8 of those fields. Should I:
>
> - Make two table with a one on one relationship ?
> - Make one big table ?
That depends on a great number of things. Generally speaking, a table should describe one "subject" if you will. Each of the fields should be an attribute of that subject.
The principles of relational database design are not difficult concepts to master, but the thinking required is not something most folks grasp intuitively. A web search should provide a wealth of resources for you. Received on Fri Aug 25 2000 - 16:29:56 CEST