J
JoJo
I need some help! My company wants to track its employees by the department
in which they work, the job assignments, and the numbr of hours assigned to
each job. Employees can only be assigned to one department, but departments
can have many employees or none. Each department has a supervisor even if it
doesn't have any employees. Employees need to be assigned at least one job
but can have multiple assignments. The jobs themselves can have many
employees working on them or none at all.
Can anyone suggest what info to use in my tables and how I can link the
tables?
Any guidance is extremely appreciated!
in which they work, the job assignments, and the numbr of hours assigned to
each job. Employees can only be assigned to one department, but departments
can have many employees or none. Each department has a supervisor even if it
doesn't have any employees. Employees need to be assigned at least one job
but can have multiple assignments. The jobs themselves can have many
employees working on them or none at all.
Can anyone suggest what info to use in my tables and how I can link the
tables?
Any guidance is extremely appreciated!