I need a web based database to for Human Resource Management purposes. I would like to have the frontend written perhaps in PHP and the database designed in either MySQL or MS SQL. In a nut shell, I want this app to do the following... 1. Require the user to login in order to make additions or query to the database. 2. The logged in user should be able to add a new employee to the database, edit existing employees and make a employees database records void, but not totally remove it. 3. The database should contain an the employess phot and the following feilds... a) National Insurance Number (must be a 8 digit feild) Employee Number Employee Last Name Employee First Name Employee Middle Name Date of Birth Sex Street Address House or Apt. Number Postal Address Telephone Contact 1 Telephone Contact 2 Email Address Alergies or Medical Conditions Additional Details b) Marital Status Name of Spouse Sex Number of Dependents Street Address Postal Address Country Place of Employment Telephone Contact 1 Telephone Contact 2 Additional Details c) Date of Employment Initial Position Starting Salary Current Position Current Salary Increment Given Increment Date Increment Amount Promotion Given Promotion Date Promotion Date Position Details Previous Place of Employment Salary at Previous Job Position at Previous Job Additional Details d) Total Vacation Days Number of Vacation Days Taken Date of Last Vacation Amount of Sick Days Number of Sick Days Taken Number of Sick Days remaining Eligible for Maternity Leave Date of Last Maternity Leave Repremand Repremand Details Additional Details Please include documentation. Also, as this will not be the final version of the product, I will need the coder to make additions and improvements from time to time.
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
PHP and MySQL or MS SQL