Re: Identifying candidate keys and primary keys

"rpost" <rpost@[EMAIL PROTECTED]
> wrote in message 
news:9bf14$48063060$839b4533$12580@[EMAIL PROTECTED]
> Brian Selzer wrote:
>
>>Unless you can identify the functional dependencies, you won't be able
to
>>identify the candidate keys.  If you don't know enough about the subject
>>matter (or weren't provided with that information as part of the
>>assignment), then you might as well join Bluto.
>
> Perhaps they want the student to write these assumptions down
explicitly.
> Perhaps they want to make the student realize that without such explicit
> assumptions the validity of the model cannot be determined.
>

Speculating about assumptions seems too much like work to me.  It's bad 
enough having clients who don't know what they want--just that they want
it 
NOW!  Maybe this assignment is designed to expose students to what they
can 
expect when they graduate--sort of a 'weed out the feint hearted'
exercise.

Brian