Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #370
| Path | csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!news2.arglkargh.de!feeder.erje.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| From | Gene Wirchenko <genew@ocis.net> |
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: What is the advantage to this kind of database structure? |
| Date | Tue, 24 May 2011 15:34:34 -0700 |
| Organization | A noiseless patient Spider |
| Lines | 22 |
| Message-ID | <0gcot692q7ph473191j1funodh8elq4e5j@4ax.com> (permalink) |
| References | <ee9af52a-f912-41bf-9854-a1a76ee9db69@x3g2000yqj.googlegroups.com> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=us-ascii |
| Content-Transfer-Encoding | 7bit |
| Injection-Info | mx04.eternal-september.org; posting-host="7Qrvczazr82YckO5XW8Vtw"; logging-data="12101"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/kcyvrbfOTZaqwZVCaXUAtDb9bz+kd12o=" |
| X-Newsreader | Forte Agent 4.2/32.1118 |
| Cancel-Lock | sha1:dMFU8TDMDGPy6nEKagiVg2LbpEs= |
| Xref | x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:370 |
Show key headers only | 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
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