Create a file in your project named employees.txt with the following data (you can simply create the file by hand rather than with Python code): 123 Bob Smith 345 Anne Jones 256 Carol Lee 845 Steve Robert Anderson 132 Jill Thompson From your program's main function, give the user the following options: lookup a name based on ID number, lookup an ID number based on name, and quit the program. OPTION 1: The user chooses to lookup a name based on ID number: Use a try/except and ask the user to enter an integer. If they don't enter an integer, print an error message. If they do enter an integer, call a function named lookup_employee which takes the id as a parameter. If an employee with the given id number is found, return the name. Otherwise, return the string “Employee not found” Back in main, print the return result. OPTION 2: The user chooses to lookup an ID based on name: Ask the user to enter the first and last name (don't ask for the middle name). Call a function named lookup_id, which takes the first and last name as two separate strings. If an employee with the given first and last names is found, return the ID number. Otherwise, return the string "ID not found" Back in main, print the return result. OPTION 3: Exit the loop and quit the program.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Create a file in your project named employees.txt with the following data (you can simply create the file by hand rather than with Python code):

123 Bob Smith
345 Anne Jones
256 Carol Lee
845 Steve Robert Anderson
132 Jill Thompson

From your program's main function, give the user the following options: lookup a name based on ID number, lookup an ID number based on name, and quit the program.
OPTION 1: The user chooses to lookup a name based on ID number:
- Use a try/except and ask the user to enter an integer.
  - If they don't enter an integer, print an error message.
  - If they do enter an integer, call a function named lookup_employee which takes the id as a parameter.
    - If an employee with the given id number is found, return the name.
    - Otherwise, return the string “Employee not found”
  - Back in main, print the return result.
OPTION 2: The user chooses to lookup an ID based on name:
- Ask the user to enter the first and last name (don't ask for the middle name).
- Call a function named lookup_id, which takes the first and last name as two separate strings.
  - If an employee with the given first and last names is found, return the ID number.
  - Otherwise, return the string "ID not found"
- Back in main, print the return result.
OPTION 3: Exit the loop and quit the program.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions