I need an online library website built using servlets and jsp or struts and beans, basically J2EE. the database is mysql and tomcat is the server
The site should have a database of books and users and a review table for book reviews(can be merged together with the book table). There would be different features for administrator of the site and of normal users.
A normal user can search for a book and reserve a book online, which would be reflected onto the database as the book being unavailable. Now since the library is online this reservation is like a ticket which is valid for 5 hours after which if the book hasnt been checked out from the actual library the ticket would then expire and the book becomes available again online. These above features have to have sessions associated with it.
A user should be able to do advanced search as well which could be on isbn, author name, book title.
Other than these a user when he logs in to the site he can see the books he has checked out along with the date it was checked out and when it is due. Also there should be a field called notifications wherein the administrator of the site can send him some messages.
He can click on books that he has checked out and be able to get an extension on the book. Also he should be able to write a review on the book as to how he found the book. This review feature would be used when someone searches for a book there would be a reviews link next to it which when clicked would display all the reviews that that particular book has recieved along with the name of the user who gave the review.
The administrator should be able to add/delete/update books/users on to the site. Also the administrator should be able to message particular users which would show up as notifications on the users home page once he logs in. One more thing the admin should be able to do is add news/alerts related to the website which would show up on the home page of the website.
One last feature, not really a feature but like a future enhancement would be to store all book searches(just the keyword searched for) along with the username which searched for the book in a table.
Finally the UI of the site need not be too fancy, a simple consisten background color would do.
I would need a database diagram, a simple ER diagram will be sufficient, or a diagram giving all the tables along with the column names. Also a list of all the classes along with the methods and variables.(sorry about this but need it to get a hang of the flow of the whole thing)