I need someone to create an access database system for a payroll department only. This protocol does not have to be done in access just in excel and word.
This process entails 10 employees working for a restaurant, there are in total 5 restaurants. Each employee can work, in any given time, in either restaurant. Each work 20 hour per week and get paid $15 an hour.
I want a system where an employee can sign in a computer, with their id #, in either restaurant. This system will accumulate all hours worked by each employee regardless of location worked. In addition, management must also sing on to system to process payroll.
Also I need all processes preformed by payroll such as reports etc.
The following is what I need:
I need 3 dfd
1 context diagram
2 logical level 0 diagram
3 physical diagram
In addition, I also need the following:
A Entity Relationship Diagram
System flow Chart
I need Solution in Prototype demonstrated by tables using excel and output in word