Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DB Modeling Question
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
![]() |
![]() |