I have a problem in logical design of Sql server database . Still i can not distinct which relation has to be One to Many and which one has to be Many to Many? Some one told me if both entity tables are independant , they can have Many to Many relation , else they will have one to many.
But now i am working on a project that collect personal information of the employees , in one part there is a table known as JobStatus which is for the personle's current job.this table has a relationship with Person(table) that is Many to Many,ofcourse there is a junction table between them . I made this type of relation because one job position's name is assigned to several persons and with different performance.
For instance : Person A ----->Operator perosn B------>Operator and so on...
And in other side there are some cases that a person has two Job position , i mean he is either a director and a teacher . For instance :
Person C ------>Director & Teacher
So would you please guide me in this ambiguous logical mean?
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)