Write a class that connects to the CoffeeDB database and allows the user to insert a new row into the Customer table.

 

Write a method that connects to the CoffeeDB database and allows the user to select a customer, then change any of that customer's information. (You should not attempt to change the customer number because it is referenced by the UnpaidOrder table.)

 

Write a method that connects to the CoffeeDB database and displays a list of customers with unpaid orders. The user should be able to select a customer from the list and see a summary of all the unpaid orders for that customer.

 

Create a main program that implements the class above and calls each of its methods to access the database.