Population DatabaseYou will find a program named CreateCityDB.java in Starting Out with Java: Early Objects (6th Edition) Chapter 15 Source Code. Compile and run the program (SEE BELOW). The program will create a Java DB database named CityDB. The CityDB database will have a table named City, with the following columns:Column NameData TypeCityNameCHAR (50) Primary KeyPopulationDOUBLEThe 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, write a JavaFX application called PopulationDemo that connects to the CityDB database and allows the user to click 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. Population DatabaseBeijingBuenos AiresCairoCalcuttaDelhiJakartaKarachiLagosLondonLos AngelesManilaMexico CityMoscowMumbaiNew York CityOsakaSao PauloSeoulShanghaiTokyoCITYNAMESort AscendingGet Average12,500,00013,170,00014,450,00015,100,00018,680,00018,900,00011,800,00013,488,00012,875,00015,250,00016,300,00020,450,00015,000,00019,200,00019,750,00017,350,00018,850,00020,550,00016,650,00032,450,000Sort DescendingGet HighestPOPULATIONSort NameGet LowestXGet TotalExit Chapter 15HOMEWORK5. Population DatabaseYou will find a program named CreateCityDB.java in Chapter 15 Source Code. Compile and run the program.The program will create a Java DB database named CityDB. The CityDB database will have a table namedCity, with the following columns:Column NameCityNamePopulationData TypeCHAR (50) Primary KeyDOUBLEThe 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 andtheir populations.Next, write a program that connects to the CityDB database and allows the user to select any of the followingoperations:▪ 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.

This is a java program question. The required code is an implementation of a Java program that…

Answered: Population Database You will find a…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Population Database

You will find a program named CreateCityDB.java in Starting Out with Java: Early Objects (6th Edition) Chapter 15 Source Code. Compile and run the program (SEE BELOW). The program will create a Java DB database named CityDB. The CityDB database will have a table named City, with the following columns:

Column Name	Data Type
CityName	CHAR (50) Primary Key
Population	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, write a JavaFX application called PopulationDemo that connects to the CityDB database and allows the user to click 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.

Population Database
Beijing
Buenos Aires
Cairo
Calcutta
Delhi
Jakarta
Karachi
Lagos
London
Los Angeles
Manila
Mexico City
Moscow
Mumbai
New York City
Osaka
Sao Paulo
Seoul
Shanghai
Tokyo
CITYNAME
Sort Ascending
Get Average
12,500,000
13,170,000
14,450,000
15,100,000
18,680,000
18,900,000
11,800,000
13,488,000
12,875,000
15,250,000
16,300,000
20,450,000
15,000,000
19,200,000
19,750,000
17,350,000
18,850,000
20,550,000
16,650,000
32,450,000
Sort Descending
Get Highest
POPULATION
Sort Name
Get Lowest
X
Get Total
Exit

Chapter 15
HOMEWORK
5. Population Database
You will find a program named CreateCityDB.java in Chapter 15 Source Code. Compile and run the program.
The program will create a Java DB database named CityDB. The CityDB database will have a table named
City, with the following columns:
Column Name
CityName
Population
Data Type
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, write a program 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.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

How do you display the data in a JavaFX application?

Solution

by Bartleby Expert

SEE SOLUTION

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions