Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #370

Re: What is the advantage to this kind of database structure?

Show all headers | View raw

On Tue, 24 May 2011 15:11:56 -0700 (PDT), stapes
<steve.staple@gmail.com> wrote:

>I have had to do maintenance work on a number of databases that have
>been created using what seems to me a very complex structure.
>
>For instance, instead of having one table of information on members of
>staff, there are 20. Separate tables exist for items which are
>compulsory - such as Medical information, Criminal Records, etc. I can
>understand this in the case of optional items, which may or may not
>exist, such as Interview results, or items which may exist in
>multiples, such as References.
>
>Is there any advantage to this kind of structure?

     Are you sure about the cardinality of the data?  Medical
information, for example, does not strike me as something that is
just-one-of (unless it is very abbreviated).

Sincerely,

Gene Wirchenko

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

What is the advantage to this kind of database structure? stapes <steve.staple@gmail.com> - 2011-05-24 15:11 -0700
  Re: What is the advantage to this kind of database structure? Gene Wirchenko <genew@ocis.net> - 2011-05-24 15:34 -0700
  Re: What is the advantage to this kind of database structure? Erland Sommarskog <esquel@sommarskog.se> - 2011-05-25 23:32 +0200

csiph-web