This is a homework assignment. You must complete the task by March 7 2005.
Your job is to write a java-based application with GUI to access an established database.
Here are the requirements for the application:
First user must log in or given an option of creating a new account, before they can use the application to access the database.
The established database is for a reservation system. Once user log in, they are allowed to search for an restaurants or movies by city.
The user can select to make reservations for specific locations from the list of results. The application should switch to a purchase screen, where the user is shown his/her choice for reservation along with the charges. If the purchase is completed, then the transaction should be recorded in the database.
The users are allowed to view/update their information, such as e-mail address, name, address, password, and their registered credit cards. For the latter, the user is allowed to delete a credit card, update the information on an existing card, or insert a new card.
Users allowed to rate restaurant, bars, theaters and movies.
The application allows the user to view all his/her transactions. These transactions should be ordered by the reservation dates.
Search for a restaurant by cuisine and read its ratings. The user can search for restaurants of a particular cuisine in a city. When the user selects a restaurant the next page displays the ratings given to the restaurant by the other users. Each rating must also show the username of the other users