Re: Data Redundancy

cybose wrote:
> A Relation has the following two entities - Employee & Department.
>
> A snapshot of the data could be -
>
> Employee. Dept.
> A 001
> A 002
> A 003
> B 001
> B 005
> C 001
> C 002
> .
> .
> .
>
> An employee can belong to multiple departments and a department can
> have multiple employees. How can I model this with the least amount of
> redundancy ?
>

I think you just did. OTOH if you're talking about storing it, then I think you must clarify what kind of model you mean.

cheers,
pc Received on Wed Feb 15 2006 - 21:22:32 CET