sql with java

Question 2 (100 points) Create a menu driven application in Java using Hibernate. In the menu, provide options for creating a new customer, updating customer phone number, deleting a customer, getting customer details. After every operation, ask the user if they wish to make more changes or wish to exit the application. Utilize the northwind database provided to you. a. When a user creates a new customer, obtain all necessary information from the user and persist new customer into database. For customer ID, use first 3 letters of company name and last 2 digits of phone number. b. When a user wishes to update their contact details, get customer id, and the number they wish to update and perform the necessary operation. c. When a user wishes to delete a customer, get customer ID. Before deleting, confirm if the user really wants to delete and then perform the necessary operation. Deletion may not be possible for customers who have orders due to foreign key constraints. d. When a user wishes to fetch customer details, get the customer ID and display the company name and contact name. You can leave this answer blank. Please submit the solution at the Github assignment URL provided by your instructor