Your neighbor has a business representing Magicians. She would like to run her business on her computer and has asked you to develop a program that will allow her to track what Magicians are booked for which Customers for specific Holidays. This application should have a very nice GUI interface and will be a database driven application. The database used will be Derby. This application must use good Object Oriented Design and Programming. The database must use good Object-Oriented Design and Programming. There is a very close correlation between Object-Oriented Design and Database Design. Your application design should include at least four classes besides the main GUI class, e.g. Magician class, Holiday class..., etc. Your database accesses should be in the classes that correlate with the database tables.

This phase of the project will implement the following user commands:

Book Customer Holiday The customer will be assigned a magician for the requested holiday, if one is available. If one is not available, the customer will be put on a wait list for that holiday. The waiting list must be maintained in the order the customers where placed on the list. The magicians can be assigned in any order.

Status Holiday or Magician or Waiting List The Status command for holiday will display the customers and their respective magicians for the requested holiday. The Status command for magician will display the customers and the holiday for the requested magician. The Status command for waiting list will display the waiting list of customers and the holiday for which they are waiting.

Database considerations: The Magician Table should be preloaded with several magicians such as Merlin, Houdini, and Gandalf. The Holiday Table should be preloaded with several holidays such as New Years, Halloween, and 4th of July. The database tables should not contain redundant data, i.e. relevant data should only appear in one table except for foreign key fields.

GUI Guidelines: The user should be required to enter only unknown data. Drop down lists of known data such as Magician names or Holiday names should be displayed for the user to select from. Combo Boxes should be used to categorize data on the form. When information is requested to be displayed e.g. for a Status command, all of the requested information must be displayed. When a command is performed, the results of that command should be displayed to the user without the user needing to check Status to see what was done.