Database for office expenditure, attendance record, and salary record

CLOSED
Bids
8
Avg Bid (USD)
$209
Project Budget (USD)
$30 - $250

Project Description:
We need a database
For each employee there is user ID with the code in the database to login
Database should be accessible through internet explorer intranet
Process
1- When someone request money, he should send a request to the payer in the database
2- The payer pays him physically; the requester goes to the database and approves the receipt of payment (user will have one secret code. When he receives the money he will confirm it by entering the code in the database. In case he loose it or it’s leaked, the liability goes to the user)
3- A balance sheet within the database opens for this payment, where the receiver adds all his expenditures for the money at the end of each day until zero amount remains with him
4- During the clearance, the payer/the finance person will check all the expenses one by one and approves each. After the approval, the receiver will be free of liability for the amount he has received.
5- Once the balance is cleared, no one has access to edit/delete the balance sheet.. only read access
6- If the receiver has to pay some amount of money to another user, within the balance sheet he will have the access to transfer amount. The second receiver will approve the amount and in the remarks section the confirmation will be added
The user in the database can access:
Summary of payment received/sent each month/year
Detailed Record of the each balance sheets of each month/year
Amount he/she owes
Salary section
Attendance sheet/ details of attending
The operator and the payer will have access to:
Change the pin code of the users
View summary of expenses for all employees (Read only)
Salary section
Attendance sheet/ details of attending
Stock/inventory record system
Each items is recorded in the database
User will make a request for using the item

Skills required:
Database Administration
Additional Files: expense+database.docx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 250
in 5 days
$ 250
in 3 days
$ 150
in 7 days
$ 150
in 20 days
$ 145
in 5 days
$ 250
in 13 days
Hire jayashkumar
$ 250
in 15 days
$ 230
in 12 days