How to implement many-to-many relationship correctly?
I have Jobs and Empolyees tables. The rules are: One_Job_Can_Be_Assigned_To_Many_Employees
and
One_Employee_Can_Be_Assigned_To_Many_Jobs
I use JobsEmployees table that have 2 fields, jobID and EmployeeID, No primary key. As i know that is not good design to have tables without primary keys.
So, is there any other way to implement many-to-many relationship?
Any help is appreciated...