Simple Library Transaction Idea

Last few days ago, I was interested by a topic on mailing list group. This is about how to monitoring books circulations on library?

As we know, library is a place we can study with reading at the place, or we can borrow books we like to take home.

In here we need technology to control the circulation of books, in and out, new arriving, broken books, and etc.

Today I don’t want share a code here. What I want is only share idea about circulation books on library?

Here the ideas:

On simple library transactions are in and out books. Then we need to record every transaction which related with it.


Ok. Now we know about the flow of simple library.

Next, we need a design of database structure:

In here we need 3 tables, which is bookmaster, bookborrow, bookreturn.

Fields on bookmaster are: bookID, bookName, bookQTY, bookstatus.
Fields on bookborrow are: borrowers, bookID, bookQTY, dateofborrow.
Fields on bookreturn are: borrowers, bookID, bookQTY, dateofreturn.

The flows of code are:

1. bookstatus is “Available”
2. If somebody borrows books, then record it at bookborrow table.
3. Reduce bookQTY with borrowed book qty.
4. If bookQTY = 0, then set bookstatus into “Not Available”
5. If somebody returns the book, then record it at bookreturn table.
6. Sum bookQTY with returned book QTY.
7. if bookQTY <> 0 , then set bookstatus into “Available”

That is a little from me. If somebody wants to add another idea, you can comment at comment section.

Chao…..