form to table setup

[Chimp8471]

I am trying to build a very simple but effective database that I can use to monitor who is working where within my factory.

I have set up a series of tables have linked them up the best way I know how, I dare say I have done this wrong but I have done it anyway (open to suggestions on improvements).

What I am trying to do ultimately is to be able to calculate how many people I have in each area etc… to calculate if I have any vacancies…

The set up is as follows:

Each employee has a job role
Each employee has a shift
There are three shifts associated with each Production line
Production lines are based in a specific Dept
Dept are based in specific areas

The only things that will really change is the employee, they may get moved from one role, line, dept etc…

As I said I have put some tables together, but am not sure If I need another table to store all the info for each person, by this I mean…..

Do I need to create a table to store each persons info, dept, area, line role etc…

I want to have a form that I can enter each populate, which will let me make the relevant links between people, lines etc…

Can anyone help me with this please…….if someone would prefer to do this as a freelance project I am happy to listen to offers

Cheers

Andy