Re: Table design - reducing number of entities

Roy Hann wrote:
>However in both cases there might be a
>significant number of attributes that the pairs of entity types have in
>common, and one could (and I say should) use a super-entity to
>represent *just* the common attributes that have the same constraints.
 >And there I think perhaps we meet in some kind of middle ground.

I agree with Roy. I believe generalization would be better, by exporting the supertype primary key to the subtype or vice-versa. But it doesn't stop you from doing it the way you proposed: using a many to many between 'Student' and 'Address'.

--
wallace reis