The data file is here

NOTE WELL -- there are extra commas in the data file for items that do not belong to that particular vacation. You should ignore these. But, you need to determine how you will decide which type of vacation you are reading. I have included a "code" as the first token on the line, a for all inclusive vacations, p for piecemeal. It seemed the easiest way at this point.

Write an abstract class encapsulating data for a Vacation. A vacation has two attributes: a budget and and a destination.

In addition to the "typical behaviors", each subclass has the ability to report on how much the vacation is over or under the budget (this is the abstract method in Vacation).

The Vacation class has two sub classes: an all-inclusive vacation and a piecemeal vacation (each of the pieces of the vacation are bought separately i.e. airfare, hotel, car, etc...). The all-inclusive vacation has three additional attributes: a brand (like VacationExpress), a rating (an integer representing the number of stars) and a price. The piecemeal vacation has two additional attributes: an array representing the pieces (airfare, hotel, car) and a second array representing the corresponding prices for each).

Create a VacationUtilities class that will create an ArrayList of Vacation objects and contain methods as listed below in the menu.

Your driver will (by menu choice):

call the method to display all all-inclusive vacations

call the method to display all piecemeal vacations

call the method to display all vacations that are under budget

call the method to display all vacations that are over budget

call the method to display the average budget for all vacations in the database.

Deliverables:

Vacation.java

AllInclusiveVacation.java

PiecemealVacation.java

VacationUtilities.java

VacationDriver.java

vacationData.csv(the picture above is a file that needs to be called into the program)

Insert Page Layout FormulasData Review View HelpTell me what you want to do Cut Copy Format Painter ? AutoSum , A Paste Conditional Format as Cell Insert Delete Format Sort &Find & Filter Select Clear Table Styles Styles Clipboard Alignment Number Cells Editing POSSIBLE DATA LOSs Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. Don't show again Save As... A1 Xcode 1 code acation destination Cozumel Mexic0 Antigua Cancun Mexic Costa Rica Paris France Orlanda Florida USA Solta Croatia Banff Alberta Canada budget brand rating airfare hotel 1250 Vacation Express 1750 Cheap Caribbean 1000 bookit 2500 Costco Travel 1750 1500 1109 1510 3.5 4 a 2799.55 1308 126 158 54 1750 1104 10 12 13 14 15 16 17 19 21 Insert Page Layout FormulasData Review View HelpTell me what you want to do Cut Copy Format Painter ? AutoSum , A Paste Conditional Format as Cell Insert Delete Format Sort &Find & Filter Select Clear Table Styles Styles Clipboard Alignment Number Cells Editing POSSIBLE DATA LOSs Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. Don't show again Save As... A1 Xcode 1 code acation destination Cozumel Mexic0 Antigua Cancun Mexic Costa Rica Paris France Orlanda Florida USA Solta Croatia Banff Alberta Canada budget brand rating airfare hotel 1250 Vacation Express 1750 Cheap Caribbean 1000 bookit 2500 Costco Travel 1750 1500 1109 1510 3.5 4 a 2799.55 1308 126 158 54 1750 1104 10 12 13 14 15 16 17 19 21