hi, im new here, ahhm can u help me abt my project, its a library system that have database and u need to login first to borrow a book, first u need to register, after register you will have ur profile, that profile consist of searching and borrowing books, and returning books. When you borrow the book it will enter to your list that u borrowed a book from that u will see also its date when u borrowed it and penalty if u not returned the book in the due date. Also when you clicked the return button it will go to the admin that u will return the book, and the admin will accept it when he/she receive the book so that you will have no more status on your profile. There is also login for the admin, and go to other interface not same as the student. In admin interface, there are ADD BOOK a, DELETE and EDIT book, also there is a window that will see the list of book that borrowed by the student.
In SEARCH and BORROW BOOK WINDOW, there are alphabet A-Z and when you click a letter e.g LETTER A, the combo box will only show the category of the book that starts with letter A.
i need to know, when someone logged by his account his database will be the one that can handle his borrowed books.
A studentA borrowed a book chemistry then the chemistry book will be on his profile and wait until it return to the library. Then, the librarian will know that someone borrowed the chemistry book.
the quantity of the book also update,
chemistry book = 5pcs
STUDENTA borrow 1 so the available CHEMISTRY BOOK was 4pcs
help me please :)