This is a 2 part project.
(1) Create a database to keep track of employees and job history
(see "STS Master [login to view URL]" for current system for reference)
(2) Generate two graphs from job history
(see "[login to view URL]" for example)
We take resumes from various individuals(oil field workers) and try to find jobs for them with one of our clients(Gas companies).
An employee can only be on one job at a time. The various actions associated with the job is hire, rehire, rate-change, client-change, and termination. Also, there is a checklist associated with each action.
Currently the master workbook is being filled out and re-saved in a folder titled with that employee's name. The graph spreadsheet information is manually being filled. We would like a database to bring all of the employee information together in a user friendly manner. Also, we would like to automate the graphing process.
Part "A" (database) of this project will be multi-user as 3 or 4 secretaries will be filling out this information.
Part "B" will be on a big TV in the main boss's office. He wants the screen split into four sections. The first two being the graphs -- they would need to be live and update as the database updates. The third would be an "employee activity" log showing the most recent hires/rate-changes/client-changes/terminations. The fourth section is going to be the weather(this section is not important at the moment and may change to a stock ticker or something).
Along with the spreadsheets, please find attached a screenshot of a database I created to show the tables and relationships of this data.(At least how I think they should be)
Được trao cho:
14 freelancer đang chào giá trung bình $646 cho công việc này
Hello Sir, I am a senior Java developer,I am very interested in this Manager System project could you please attach the document you mentioned in project description Thanks Bing