I have created four tables in my database(the database I want is basically for timesheet & productivity factor)
I want to create
One-to-many relationship between Department and Employee
many-to-many relationship between Department and Project
Many-to-many relationship between Employee and Project
As it is required ..... kindly guide me whether I am doing write or wrong and whats the most suitable relationship between all tables as I am getting confused for many-to-many relationship I have read that for many-to-many relationship b/w two tables we have to create one more table in which the primary keyis the primary keys of the other two tables.If I am going to do this I have to create more tables ...plz suggest me.