Re: Design question

In article <1994Jan13.070433.18146_at_newsgate.sps.mot.com>, ttg242_at_newton.sps.mot.com (David Thornewill von Essen) writes:
|> 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.

Database modeling doesn't really seem to belong in comp.software-eng. I would rather try to get people here interested in modeling questions.

|>
|> > [Question deleted...]
 

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

For the sake of the discussion, I am saying that the relationship between the can and the string is exactly and always 2:1, i.e. 2 cans for each string. If the relationship is M:1 or M:M, then the solution is clear. What I am interested in is the case where M is a known and constant value.

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

-- 
Derek Fields
(derek_at_gamekeeper.bellcore.com)