Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: DB Modeling Question

Re: DB Modeling Question

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Mon, 20 Dec 1999 13:41:55 -0800
Message-ID: <83m84o$lhj$1@plo.sierra.com>


Having spent over 15 years in healthcare, and having been around "docs" far too much, I can easily "hear" a doc saying, a patient can have one and only one doc (referring of course to him/herself).

Alan Shein <alanshein_at_erols.com> wrote in message news:83m4lf$qe7$1_at_bob.news.rcn.net...
> It's just a matter of direction. Left to Right vs. Right to Left. If they
> had phrased it,
>
> "patients can have one and only one doctor"
>
> it would be a many-to-one.
>
> In my experience, everyone tends to speak in a left-to-right kind of way
> (one-to-many), as in the test's example. It makes more sense to say, "One
> doctor can have many patients" than, "Patients can have one and only one
> doctor."
>
> Mark Framness <framnesso_at_my-deja.com> wrote in message
> news:83m1s9$dhh$1_at_nnrp1.deja.com...
> > Hey All
> >
> > In the self-test SQL-PL/SQL sample practice exam I get tripped up by one
> > question regarding data modelling.
> >
> > The question is that a patient can only have one doctor, doctor can have
> > many patients and a doctor can not be a patient.
> >
> > They give one-many and many-one among other choices and the answer is
> > many to one. What is the difference in this case between one to many
> > and many to one?
> >
> > Going through the Oracle CP App Deve Exam Guide I did not notice any
> > differentiation. The impression that I got is that there are many to
> > many, one to one, many to one and nothing else (i.e. many to one and one
> > to many are the same thing).
> >
> > Thanks Again.
> > --
> > From: Mark Framness
> > http://netnet.net/~farmer/index.html
> > All standard disclaimers apply anyone who say otherwise is itching for a
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Mon Dec 20 1999 - 15:41:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US