import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

/**
*
*
*/
public class Main {

final static String DB_NAME = "Books";
final static String DB_USER = "root";
final static String DB_PWD = "";

/**
* main function
* @param args
*/
public static void main(String[] args) {
   databaseOperation();
   tableOperation();
}

/**
* operation on tables
*/
private static void tableOperation() {
   try {
         Class.forName("com.mysql.cj.jdbc.Driver");
         Connection con = DriverManager.getConnection(
               "jdbc:mysql://localhost:3306/" + DB_NAME, DB_USER, DB_PWD);
         tableCreation(con);
         tableInsertion(con);
         tableQuery(con);
         tableUpdate(con);

         con.close();
   } catch (Exception e) {
         System.out.println(e);
   }
}

/**
* update the table
* @param connection
*/
private static void tableUpdate(Connection connection) {
   // Add new Author
   System.out.println("Add new Author ");
   tableAddAuthor(connection);
   System.out.println("");
   // Edit/Update the existing information about an author
   System.out.println("Edit/Update the existing information about an author");
   tableUpdateAuthor(connection);
   System.out.println("");

   System.out.println("Add a new title for an author");
   tableAddTitleToAuthor(connection);
   System.out.println("");

   // Add new publisher
   System.out.println("Add new publisher");
   tableAddPublisher(connection);
   System.out.println("");

   // Edit/Update the existing information about a publisher
   System.out.println("Edit/Update the existing information about a publisher");
   tableUpdatePublisher(connection);

}

/**
* update a publisher
* @param connection
*/
private static void tableUpdatePublisher(Connection connection) {
   Scanner scanner

Suppose that your work for a beverage company. The Company wants to...