Programming Language is Java.

For this assignment you will create an employee database, containing contact information, salary, and position. You will also define the type of company. Is it an engineering firm, a supermarket, or a call center? Once the database has been completed, I should be able to perform a query for any piece of information associated with each employee. For instance, if I search for employees who make over $50,000, all of the employees whose salaries are greater than $50,000 should print to the screen. If I ask for employees whose last name starts with a 'C' , all employees with the last name beginning with a 'C' should print to the screen. I should be able to repeat the query as many times as I wish. When I am done, I should be given the option to quit the program.

These are the guidelines you must follow:

1. The database must contain at least 20 employees.

2. Some of the employees can have the same first name, but they should all have different last names. Some of the names can start with the same letter, but try using at least 10 different letters.

3. There must be at least 4 salary ranges, i.e. 20-40K, 40-60k, etc... Also, each employee should have a specific salary. $45,555, $79,898, and so on.

4. The employee contact information must include the following: employee id, first name, last name, m/f, start date, address, telephone number, social security number, and date of birth (which should return an age).

5. Each employee should be classified by their position in the company, i.e. President, Manager, secretary, engineer, programmer, scientist, etc. Model their positions on the company itself.

6. There should be a final option to see all of the information related to a specific employee. If I choose this option, please ensure that all of the employee's information is printed to the screen in a professional looking format. You are free to design this on your own.