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 menuii. 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 tablei. 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 tablei. 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 table2. 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
