Re: Data Redundancy

From: paul c <toledobythesea_at_oohay.ac>
Date: Wed, 15 Feb 2006 20:22:32 GMT
Message-ID: <c4MIf.13292$sa3.3502@pd7tw1no>

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 - 14:22:32 CST