Library Management System..

The LMS maintains information about books and users. Books have a title, an author and a publication year. Books can be either in the library or borrowed by a user. Users can be either students or professors. Students have a name and a student number. Professors have a name and belong to a faculty. Users can borrow books. A Student can borrow 2 books at a time while professors are allowed to borrow 5 books simultaneously.

The LMS application provides a GUI allowing:

* Add new books and new users,
* Borrow or return of a book,
* List available books,
* List borrowed books,
* List users

and the database should be using SQL..

so any1 can help me here with this??

oh....
i'm actuly having the same project & i'm in trouble. Please can any1 help me also.
i will preciate it

hi, it seems that no 1 had helped us,so i finally got the project but i wish its not to late for you angel555,here it is