<noagbodjivictor@[EMAIL PROTECTED]
> wrote in message
news:7b355c27-a3c3-488b-994e-c2559a08a8b4@[EMAIL PROTECTED]
> On Apr 13, 7:05 am, "Brian Selzer" <br...@[EMAIL PROTECTED]
> wrote:
> > <noagbodjivic...@[EMAIL PROTECTED]
> wrote in message
> >
> >
news:fc37fe0e-476b-4a0b-8396-ab81c9a5f4a1@[EMAIL PROTECTED]
> >
> >
> >
> > > Hello guys, this one is for one of my assignments. I want
explanations
> > > and hints only.
> >
> > > I'm still confused with the concepts of candidate keys and primary
> > > key. We have a patient medication form from an hospital with these:
> >
> > > Heading: Patient number, Full name, Bed number, Ward number, Ward
> > > name.
> > > Then a table with this columns: drug number, name, description,
> > > dosage, method of admin, units per day, start date, finish date.
> >
> > > I have to find all the candidate keys and primary keys. I think
> > > candidate keys are the minimal superkeys.
> >
> > > I have found {Patient number, Ward number, Ward name}. I have
excluded
> > > {Patient number, Ward number, Ward name, Full name} and {Patient
> > > number, Ward number, Ward name, Full name, Bed number} which are
also
> > > superkeys but contain more attributes.
> >
> > Can a patient be in more than one ward (at the same time)?
> >
> > > This means that I have found only one candidate key, and this is
also
> > > the primary key I have found (a composite).
> >
> > > Since the question was "identify all the candidate keys" I thought
> > > maybe I dont really understand the concepts...
> >
> > http://en.wikipedia.org/wiki/Candidate_key
> >
> > > thanks for any help.
>
> Brian, I don't really know...
>
> I have been looking at how hospitals work here in US. From what I have
> learned online, I don't think it's possible to have a patient in
> multiple ward at the same time (and I can't confirm).
>
> Also from what I have learned it seems like the ward names are unique
> in hospital. It probably means that a ward number assigned to a name
> is also unique. So that when we take a name, we have the number. But I
> can't confirm that either, I have found all this by searching
> online...
No wonder you are confused by your assignment. It sounds like the people
who gave you the assignment did not describe the subject matter in
sufficient detail for you to be able to determine the candidate keys.
Were
they relying on you to use general knowledge of how hospitals work to
determine candidate keys? Were they relying on you to do online searches
to
find out which combinations of columns are unique?
Or (shudder) did they even understand the implications of the assignment
they were giving you?
|
