Database application development

database application development using a programming language of your choice (C, Java, or PHP). Write an interactive text-based program. It repeatedly gives the user a menu of options to choose from, then carry out their request, until you finally chooses the exit option. Your program should take care of all SQL queries with proper error/exception handling. Your program should also have proper transaction support. program should interact using plain text only.
top menu (and the tasks you are asked to implement) includes the following:
1. add a customer
2. add an order
3. remove an order
4. ship an order
5. print pending orders with customer information 6. restock parts
7. exit
I have attached the northwind.sql file which contains all the required table's
Additional and complete information about the project was provided in the attached PDF please take a look
Thank you