Write Javafx App Connects Coffeedb Database Allows User Select Customer Change Customer S Q37213397

Write a JavaFX app that connects to the CoffeeDBdatabase and allows:

• the user to select a customer, then change that customer’srecords in the database.
• build a method to delete a record
• design the relational database to enforce referential integrityby preventing the end-user from deleting the primary key. Likewise,prevent attempts to change the customer number because it’sreferenced in multiple tables.

Enforce referential integrity by preventing the end-user fromdeleting the primary key.  

Code to create the CoffeeDB:

import java.sql.*; // Needed for JDBC classes/** * This program creates the CoffeeDB database. */public class CreateCoffeeDB{ public static void main(String[] args) {

OR

 

OR