Python

You will be building a simple database program using Python and SQLite for a simple Employee system. 

Tips: My best suggestion on how to get started with this assignment is to build off of your Practice Lab activity from this week (fork it and then use it as a starting point). You do not have to do this based on the example in the textbook. Keep this simple and focus on the functionality. Be sure to review all of the resources from Weeks 9 and 10 before starting this assignment. 

Create an employee table with the following fields: (10 points)

· employee id number - this should be a randomly generated number between 1000 and 9999.

· first name

· last name

· email address

· phone number

· hourly rate

· department name

Build a menu system with the following functions:

· Create a function to add an employee using the given inputs. Automatically assign a random employee id but allow the user to input all other fields. (15 points)

· Create a function to list all employee id numbers, names, phone numbers, email addresses, and their department name. (15 points)

· Create a search function to search for an employee by last name. Then list all of the matches of the last name, first name, email and department name. (20 points)

· Create an update function that will allow the user to update the hourly rate for a given employee. (10 points)

· Create a delete function that will allow the user to delete a given employee. (10 points)

You have the creative license to add to this program however you wish. Be sure that the above features are working. You can add additional functionality to the program if you would like to. 

Do your best to meet the requirements of the project, but if you cannot get a particular function to work, turn in what does work. Do one function at a time and test. Once you know that function works, move onto the next. 

Ensure that there is a minimum of 10 sample employees in the employee table for us to test your program with.

Be sure to consider the user experience and the formatting of the data. (10 points)

Comment your code and name your functions well. (10 points)

Have fun with this! 

Be sure that your program is running free of errors before submitting it. 

Just a reminder - your code must be written 100% by you. Use concepts we have used so far in this class. Don't overcomplicate the assignment.