Re: DB Modeling Question

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 - 14:47:28 CST