RE: Data Modeling

Jared,

In addition to the David Hay book, do you, or any of the listers, have any thoughts on the following book?

The Data Model Resource Book : A Library of Logical Data and Data Warehouse Designs
by Len Silverston, Kent Graziano, William H. Inmon

I've got some Kimball and some Inmon books addressing DW's; but, the book above sounded interesting. Most, but not all, of the reviewers at the Amazon site spoke favorably of the book.

Regards,

L. Elkins

-----Original Message-----
From: Jared Still [mailto:jkstill_at_bcbso.com] Sent: Thursday, August 24, 2000 10:39 AM To: Burton, Laura L.
Cc: 'oracledba_at_quickdoc.co.uk'
Subject: Re: Data Modeling

Laura,

When data modeling, it is too early to talk about tables.

Rather, you should be talking about entities and attributes.

You don't really need an employee entity, as an employee is just a person, as is a witness.

There are a number of good books on data modeling. A search on Amazon should find David Hay's excellent book, as well as others.

Here's one simple possibility.

      |            |
      | ACCIDENT   |
      | WITNESSES  |
      |            |
      --------------
       \|/       \|/


        |         |

        |         |

        |         |

        |         |

------------   ------------
|          |   |          |
| ACCIDENT |   | PERSON   |
|          |   |          |
|          |   |          |