Data Redundancy

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 ? Received on Wed Feb 15 2006 - 13:54:01 CST