Re: Design question

In article a23_at_athos.cc.bellcore.com, derek_at_candyland.gamekeeper.bellcore.com (C. Derek Fields) writes:
>1) These discussions are taking place in another group. If so, just point me
> in the right direction.
  

You may also get a reaction out of comp.software-eng, but on no account mention patents, it gets them all in a tizz.

>2) Nobody cares about designing databases right. If so, let me know now and I
> won't belabor the point.

I've burnt much late night oil in conference rooms discussing these topics.

>3) Everybody is just waiting for somebody else to ask the first stupid question
> to get the ball rolling. So I will do the honors.
>
Actually in trying to answer your question I found out why these things don't get as discussed as they may, it's too darn fiddly to draw an ERD out of ASCII characters.

So my short answer is, I agree as long a the can is a physical serialised one, otherwose the relationship between strings and telephone models is many to many, which would be resolved through an intersect entity. I suppose going to the nth degree you would also have an ENDS entity with presumably exactly 2 occurances whcih would also be one to many to this intersect entity to discriminate which end a can/string relationship is on.

Regards,
David TvE

---
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
David Thornewill von Essen                           Sr. Systems Analyst
Motorola ASIC Division                            I don't speak for Mot.
Chandler, AZ-85224                                   fax: (602) 814-4451
email: ttg242_at_email.sps.mot.com                      tel: (602) 814-4395
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-