RE: Data Modeling

From: Jeff Cox <jeff.cox_at_ips-sendero.com>
Date: Fri, 25 Aug 2000 09:17:26 -0000
Message-Id: <10600.115570@fatcity.com>

The David Hay book is wonderful, and another one that is definitely worth the price is "Data Modeling Essentials" by Graeme C. Simsion.

Jeff Cox
Scottsdale, AZ
1-800-321-6899 ext. 3370

-----Original Message-----

From:	Larry G. Elkins [SMTP:elkinsl_at_flash.net]
Sent:	Thursday, August 24, 2000 5:04 PM
To:	Multiple recipients of list ORACLE-L
Subject:	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-----
Sent: Thursday, August 24, 2000 10:39 AM To: Burton, Laura L.
Cc: 'oracledba_at_quickdoc.co.uk'

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   |
|          |   |          |
|          |   |          |

------------ ------------

Jared

-- 
Author: Larry G. Elkins
  INET: elkinsl_at_flash.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Fri Aug 25 2000 - 04:17:26 CDT