Question: In this assignment, you are to write a Python program that will connect with a POSTGRES database and programmatically perform several operations with the database.

In this assignment, you are to write a Python program that will connect with a POSTGRES database and programmatically perform several operations with the database. Prompt the user for the parameters necessary to make a connection to the database that contains the teachers table. Recall the teachers table has attributes of id, first_name, last_name, school, hire_date, and salary After the database connection is successful, set up a menu system where the user can choose to Show all of the data in the teachers table. Show a particular tuple of data based upon entering a unique identifier Delete a tuple based upon entering a unique identifier. Show the attributes first_name, last_name, and school where salary is
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
