Haven't been following and not sure if this is what you're after, but these are some great data models: http://www.databaseanswers.com/data_models/index.htm
HTH olinux --- Tim Foster <[EMAIL PROTECTED]> wrote: > > You wouldn't happen to have a spare ELH diagram (or > two) lying around > that one could take a look at, would you? > > Thanks. > > TIM > -When you save for a long time to buy something, > then you find > that you can't afford it --- that's inflation. > > > > -----Original Message----- > > From: DL Neil > [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, January 09, 2002 7:23 AM > > To: George Pitcher; [EMAIL PROTECTED] > > Subject: Re: [PHP-DB] Concept help required > > > > =The purpose of an ELH diagram is to take a piece > of data > > (in your case, because we are assuming/checking > > normalisation, I'd 'cheat' and work at the table > level - > > rather than something more atomic like the > data-item > > level). Once again we draw boxes (I have some > wonderful s/w > > for doing these tasks, but it is M$). A single > > label/box at the top, featuring the name of the > data-unit, > > and I would guess a minimum of three (must be my > > favorite number!) boxes in the next row, > representing the > > arrival/creation of the data, its use within the > > system, and the removal of the data from the > system once > > its usefulness has subsided, respectively. The > third > > row of boxes represents the actual, individual > events in > > the life-cycle/daily operation of the system, and > how > > they alter/update/use the data. Lines drawn > between the > > boxes show how these events relate and where there > may > > be some iteration. > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > To contact the list administrators, e-mail: > [EMAIL PROTECTED] > __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]