rakeshn

 Profile Answers by rakeshn 

• Feb 19th, 2008

 

Employee
Department
lets say one employee can work in multiple department.
It needs many to many relationship
Create another table EmpDeptMap.
it will have foreign key with employee and Deptartment too.
In this table (empid+deptid) is the primary key

krishnaindia2007

 Profile Answers by krishnaindia2007 

• May 16th, 2008

 

Cartesian product is an example for many to many reolationship in SQL.

For example

select a.ename, a.job, a.sal, b.dname from emp a, dept b

results in many to many relationship.