Homework
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 homework 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 homework.
I. Create an employee table with the following fields:
1. employee id number - this should be a randomly generated number between 1000 and 9999.
2. first name
3. last name
4. email address
5. phone number
6. hourly rate
7. department name
II. Build a menu system with the following functions:
1. 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.
2. Create a function to list all employee id numbers, names, phone numbers, email addresses, and their department name.
3. 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.
4. Create an update function that will allow the user to update the hourly rate for a given employee.
5. Create a delete function that will allow the user to delete a given employee.
III. 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.
IV. 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.
V. Ensure that there is a minimum of 10 sample employees in the employee table for us to test your program with.
Format your homework according to the give formatting requirements:
1. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the homework, the course title, the student's name, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.