please help me with this JAVA programming 1 assignment.   You are creating a database of fey creatures found in Western Arkansas.  Your data includes the creature's species, description, diet, and difficulty to catch.  Include the following in your database: Species Description Diet Danger Level Times Caught Sprite Small winged humanoid berries medium 1 Goblin Common evil fey Omnivorous medium 5 Troll Large, dangerous, ugly humanoids high 1 Boggart Mischievous teleporting goblin-like creature stolen pies low 4 Gnome Small, shy, burrowing  burrowing critters low 2 Dryad tree-maiden spirit tied to a forest unknown medium 0 Using one or more arrays, display this list. Modify the program so the user enters a number.  Then, display all the creatures (and their info) who have been caught at least that many times. In addition to the above, allow the user to enter the name of a creature.  If that creature is in the list, add one to the number of times that creature has been caught and display the list again.  Otherwise, let the user know it isn't in the list.

Assume that a database has a table named Stock, with the following columns:Column Name                           TypeTrading_Symbol                       nchar(10)Company_Name                      nchar(25)Num_Shares                                 intPurchase_Price                           moneySelling_Price                               moneyWrite a Select statement that returns the Trading_Symbol column only from the rows where Purchase_Price is greater than $25.00.

Q4. Problem Statement You are managing a database for a movie production company. The database includes information about actors, directors, movies, movie cast, and ratings. Write a query for updating the ratings of all movies directed by 'Lankesh' to a new rating of 3 in a database that contains information about actors, directors, movies, movie casts, and ratings. The following table is already created, and the records are inserted into the table. The Sample records are given below Input Format The input records are already prepopulated, as given in the problem statement. Output Format The output should display the updated RATING table after the ratings for movies directed by 'Lankesh' have been changed to 3. Movie ID Review Stars 1 4 2345 3 4 6 4 3 Refer to the sample output for the column headers. Sample Input Sample Output DFocus BE

JavaFX program  Create a JavaFX GUI that allows the user to retrieve records from the product table in the example database. The GUI should allow the user to specify desired fields, desired order, and a where condition. Display only the desired fields in the desired order for the desired where condition.You may display the records in the GUI in any way you wish.   database below

How do you index a CLOB datatype for faster search operations?

When the Search button is pressed in the screen depicted, the getSales() function from the PosDAO.java class is called, the parameters of this function are the from date and to date.The getSales () function should return a list of Pos objects that matches the criteria specified, Note this function has to perform two INNER JOINs in to combine all three tables in order to get all the needed data to fill the Pos object. The database schema is also depicted. The PosDAO, Product, SalesDetails and Pos classes are shown BELOW Write the getSales() function public class PosDAO {     private Connection conn;    PreparedStatement stmt = null;    public boolean openConnection(){     try {         // db parameters         String url = "jdbc:mysql://localhost:4306/swen2005";         String user = "root";         String password = "";         // create a connection to the database         conn = DriverManager.getConnection(url, user, password);         if (conn!= null){             return true;…

Population Database   Compile and run CreateCityDB.java which will create a Java DB database named CityDB. The CityDB database will have a table named City, with the following columns: CityName & Population. Their Data Types: CHAR(50) Primary Key & DOUBLE. The CityName column stores the name of a city, and the Population column stores the population of that city. After you run the CreateCityDB.java program, the City table will contain 20 rows with various cities and their populations. Next, create an application that connects to the CityDB database and allows the user to select any of the following operations: Sort the list of cities by population, in ascending order. Sort the list of cities by population, in descending order. Sort the list of cities by name. Get the total population of all the cities. Get the average population of all the cities. Get the highest population. Get the lowest population.   CreateCityDB.java import java.sql.*; /**  This program creates the CityDB…