Modify the design and code an updated version of the Review Project to be a program that will process information for some of the top indoor arenas in the United States using JavaDB with PostgreSQL. Arena profiles contain information about the venue, as well as current major Tenant $($sports team$)$ that plays home games in the indoor arena. Arena profiles will be read from the text file IndoorArenas.txt$.$ Download the attached text file.

Instructions

The Arena class will need to be updated to include an accessor that returns the aggregate Tenant field. The Tenant class will remain unmodified from the Review Project.

Demonstrate your design in a demo program that will use loops to read the Arena information from the text file using the same functionality as the Review Project except for the ArrayLists which will be replaced by doing the steps in the next instruction.

The demo program will also include methods that will do the following:

Create a database named ArenasDB

ArenasDB will contain a table named Arenas that will have the following fields and properties:

Venue $$ CHAR$(45)$ Primary Key

City $$ CHAR$(15)$

State $$ CHAR$(15)$

MaxCapacity $$ INT

YearOpened $$ INT

TeamName $$ CHAR$(30)$

Sport $$ CHAR$(10)$

League $$ CHAR$(15)$

Each line of the IndoorArenas.txt file will be used to create an instance of an Arena object, and the information from the instance of that object will be used to create the Rows of the Arenas table

Define a method that will be used to drop existing Arenas tables on each execution of the program

Define a method that will use SQL statements to display all of the rows and columns of the Arenas table to the console $($See Sample output section in this document$).$

You must use object$-$oriented principles in this project. All data in the Arena and Tenants classes should remain encapsulated.

Once again, The IndoorArenas.txt file should not be edited. Your program should be able to process the text file as is

Be sure to throw FileNotFoundExceptions on any method that uses the IndoorArenas.txt file, and use try$/$catch blocks to catch any SQL Exceptions within methods

A separate driver program must be used to demonstrate your classes. Demo code must not be added to the Arena and$/$or Tenant classes.

Document your source code with single and multi$-$line comments

Sample Run of the Program:Modify the design and code an updated version of the Review Project to be a program that will process information for some of the top indoor arenas in the United States using JavaDB with PostgreSQL. Arena profiles contain information about the venue, as well as current major Tenant $($sports team$)$ that plays home games in the indoor arena. Arena profiles will be read from the text file IndoorArenas.txt$.$ Download the attached text file.

Instructions

The Arena class will need to be updated to include an accessor that returns the aggregate Tenant field. The Tenant class will remain unmodified from the Review Project.

Demonstrate your design in a demo program that will use loops to read the Arena information from the text file using the same functionality as the Review Project except for the ArrayLists which will be replaced by doing the steps in the next instruction.

The demo program will also include methods that will do the following:

Create a database named ArenasDB

ArenasDB will contain a table named Arenas that will have the following fields and properties:

Venue $$ CHAR$(45)$ Primary Key

City $$ CHAR$(15)$

State $$ CHAR$(15)$

MaxCapacity $$ INT

YearOpened $$ INT

TeamName $$ CHAR$(30)$

Sport $$ CHAR$(10)$

League $$ CHAR$(15)$

Each line of the IndoorArenas.txt file will be used to create an instance of an Arena object, and the information from the instance of that object will be used to create the Rows of the Arenas table

Define a method that will be used to drop existing Arenas tables on each execution of the program

Define a method that will use SQL statements to display all of the rows and columns of the Arenas table to the console $($See Sample output section in this document$).$

You must use object$-$oriented principles in this project. All data in the Arena and Tenants classes should remain encapsulated.

Once again, The IndoorArenas.txt file should not be edited. Your program should be able to process the text file as is

Be sure to throw FileNotFoundExceptions on any method that uses the IndoorArenas.txt file, and use try$/$catch blocks to catch any SQL Exceptions within methods

A separate driver program must be used to demonstrate your classes. Demo code must not be added to the Arena and$/$or Tenant classes.

Document your source code with single and multi$-$line comments

Sample Run of the Program:

INDOORARENA.TXT ATTACHED BELOW:

The Palace of Auburn Hills

Auburn Hills

Michigan

$24276$

$1988$

Detroit Pistons

Basketball

NBA

United Center

Chicago

Illinois

$23500$

$1994$

Chicago Bulls

Basketball

NBA

BB&T Center

Sunrise

Florida

$22457$

$1998$

Florida Panthers

Hockey

NHL

Scottrade Center

St$.$ Louis

Missouri

$22000$

$1994$

St$.$