Python program to do the SQL functions insert, display, modify

Create a Python program to display the content of Instructor, department, and courses tables.

i. Program should ask the table name to display when selecting the display
data option from the main menu. Then display the content of the
selected table.

Add the functionality to insert record to the department table.

i. User should be able to select the option to insert data from the main
menu
ii. User should be asked to enter each column data one after the other and
once the final column data is inserted, it should insert the data to the
department table.

Add a main menu item to modify the budget of a given record of the department
table
i. User should be able to select the modify budget menu option from the
main menu.
ii. The user is presented to enter the department name and the program
displays the content of that tuple and asks from the user the new value
for the department budget. The program then updates the budget of that
department

Add a main menu item to delete a department from the department table
i. User should be able to select the delete department menu option from
the main menu.

ii. The user is presented to enter the department name and the program
displays the information of that department. Then the program asks the
user “Are you sure?”
1. If the user selects yes-> delete that department from the
department table
2. If the user selects no -> return to main menu

implement this assignment as a console application and use below database only

Please check the uploaded files

 

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.