I would like to have a small air passenger management web app with Struts2, Hibernate and MySQL that has the following functionalities.
1. User sign up, log in , log out including password retrieval
2. Once logged in, Users can post, update, delete their upcoming flight information (departure city, destination city, flight date, etc..)
3. The main page would show the list of upcoming flights ordered by date or departure city or arrival city, etc.. or according to the user's browser IP city
4. System sends notification of new flights or update of existing flights to users who signed up for notification.
The system has to be pure MVC based architecture and open to modification and additional functionality in the future.