Employee Roster Web App

We are going to see where we all stand when it comes to building a simple CRUD site. This web site should be able to create,retrieve,update and delete data.

Requirements

• A site that will hold data for a company's employee roster is required.
• It needs to be able to create new employees.
• It needs to be able to delete an employee.
• It needs to be able to update an employee.
• A page that displays all active and inactive employees is required.
• A page that shows all all active employees is required.
• A page that shows all inactive employees is required.
• A page that shows all employees that were hired with in certain date timeframes is required. (the user will supply the dates).
• A page that shows all employees that were terminated and reason with in a certain date timeframes and level is required. (the user will supply dates and employment level (probably a drop down)).

Data requirements for employees

• date of hire
• first name
• last name
• city
• state
• zip
• phone number
• department
• level (software developer, adminstrative staff, management, senior management)
• active (Y or N)
• date of termination
• reason for termination (retired, resigned, terminated)

Functional requirement

• Create a normalize database to support this application.
• State needs to be in a drop down list
• Department needs to be in a drop down list
• Ensure it is done professional and meets a good user interface standard.