Online Library Management System

View With Charts And Images

Introduction to Online Library Management System

1.1. Introduction:-

The Library Management System is a data processing to perform routine Library activities. This system is concerned with developing a library management system using database software. In this system the library management becomes more efficient and easier to handle with its reliable system components. Library system was developed in order to make computerized the borrowing and returning of elements, return elements, and add elements, search elements and special tools

A library management system, also known as an automated library system is software that has been developed to handle basic housekeeping functions of a library. Library automation is the general term for information and communications technologies (ICT) that are used to replace manual systems in the library.

The functions that may be automated are any or all of the following: acquisition, cataloging, circulation, serials management and reference. When the library management system shares a common database to perform all the basic functions of a library, the system is integrated To make the existing system more efficient. To provide a user friendly environment where user can be serviced better. Make functioning of library faster. Provide a system where the library staff can catch defaulters and not let them escape. To minimize the loss done to The Library Management System is a data processing to perform routine Library activities. This system is concerned with developing a library management system using database software.

This application is used to convert the manual Application to the online application. Customized data will be used in this application. User does not have right to enter information about books. Project is related to library management which provides Reading services to its members. Any person can become a member of the library by filling a prescribed form. They can get the book issued, so that they cab take home and return them. Online membership. Keeps the track of issues and submission of books.

Background of Online Library Management System

2.1. BOOK

Each book includes an ‘About this book’ page with basic bibliographic data like title, author, publication date, length and subject. For some books members may also see additional information like key terms and phrases, references to the book from scholarly publications or other books, chapter titles and a list of related books. For every book, member will see links directing you to bookstores where member can buy the book and libraries where member can borrow it.

Determine how member think of books. do you categorize them by story type, color, size, genre, title, author, id,price,book code, book name, rack no, subject code etc. There are as many ways to organize books as there are members. Pick the method that appeals or makes the most sense to member.

Shelve the books alphabetically by author or title. This method will work well if member are good at remembering titles or names. Putting books by the same author together helps member find a book in a series easily.

Place the books on the shelf according to size. It is best to put larger, heavier books on lower shelves and smaller, lighter books on higher shelves to stabilize the bookcase. This method is more visual and appears neat. This could be a good method if member remember books by their size or shape.

Sort member’s books by topic. i.e.: All the Romance in one pile, all the science in another, Philosophy, Biographies, How to Manuals, etc.

Determine the shelf space required for each topic Place the books on the shelves together with others of their genre. Choose an identifying mark for each subject or genre. Some easy methods are: Colored Stickers. Choose stickers with permanent adhesive from a library supply company, or be prepared to cover the sticker in permanent tape. Avoid packing tape and scotch tape as they yellow, crack and peel. Duct tape becomes gooey over time. Colored Cloth Tape. Permanently adhesive colored tapes work very well for this task. Written symbols. Use a permanent marker to write a letter(s) or identifying mark for each subject or genre. For example: “R” for Romance, “M” for Mystery, “R” for Religion, “B” for Biographies, etc… Unfortunately, not all books are the same color so what shows up well on one cover may not show up at all on a different color.

Pull the books, papers, etc., off the shelf. Divide the items into two piles: those members want to keep and those members want to give away. Take out any extra papers such as bookmarks that may be in the book. Recycle the unneeded papers. Make a pile of books that need to be fixed. Later member can decide if it’s worth the effort to fix the book or if member rather just replace it with a better copy. If member have any books that member think might be of value, try looking

Them up on Books outer or RentScouterto see if anybody is willing to buy them. Box up member’s unwanted books. Call member local used bookstores and find out if them Buy books. Most thrift stores will also accept book donations, and member can get a receipt for a tax deduction, but don’t donate trashed or smelly books, which the thrift store will then have to throw away! Member can also give away members books anonymously at member work or school.

Book Crossing is a community of people who enjoy giving away their books. Paperbacks can often be recycled (check with member local garbage company), but the glue in hardcover makes them unrecyclable, so do the right thing and throw trashed books away yourself. Wipe down the shelves thoroughly with an all-purpose cleaning spray or furniture polish. Member might not get another chance to do this for a long time. Decide how member are going to organize members collection. There are many ways member can choose to arrange member books: by size, by color, by number of pages, by subject, by member favorite titles, by publisher, by publication date, by date member received the book, by member favorite genre and then by author, by author (fiction) or Dewey Decimal system/Library of Congress Classification system (non-fiction) or by reading level or lexile.Make labels for member book using a hand-held label maker to add letters or Dewey Decimal numbers to the spines of books. Put the books back into the bookshelf in whatever order member decided earlier, and enjoy member clean, organized bookshelf!

Adjust these guidelines to reflect member own personality and the quirks of member collection. It’s member collection, so organize it in a way member enjoy and can use comfortably. Members aren’t stuck with it in any case, and member can rearrange your collection as often as member like.

  Put larger books, like textbooks, cookbooks, and picture books on a lower shelf to keep them from toppling onto someone’s head. If member organize member books by type, start with the general book type and then split it into subgroups. For example, cookbooks can be organized by cuisine type: Italian, French, Thai, Mexican, etc. Fiction can be organized strictly by author, or member can sort into genre, such as sci-fi, romance, mysteries, or historical fiction. Subtopics can be as specific as Mexican cooking or British romance novels. Children’s books can be organized by age level.

  If you want a more formal catalog system, Library Thing can be used to organize member books online while keeping track of people who read the same things member are. Some users like to organize by tags; Library Thing also provides Dewey Decimal numbers, Library of Congress Subject Headings and so forth.

 Consider using computer software to organize and track member book collection. For Macs, check out Delicious Library at With Windows, have a look at Media Man There is also Freeware book management software such as and even full Library Automation packages. Search on Google using the search phrase “Free Library Automation Software.”

  Dewey Decimal and Library of Congress numbers are usually found in the front of the books with the publication information. If a book doesn’t list the Dewey Decimal number, go the the website for a major public library that uses the Dewey Decimal System (such as the New York Public Library) and search for the book by author or title. If that fails, use a subject search to find similar books and use their number.

  A useful tool could be the freeware program AZZ Card file. One of the free downloads for this program is the Dewey Decimal System. Take a look at the program and the downloads:.

If member you are a current student, organizing member collection may spill into organizing member school books, so member may want to make sure your dictionary, thesaurus and other reference books are right by member computer for when member are working on reports. For home libraries, alphabetizing is probably the best option.

Take everything out of the bookshelf. It’s so much easier to start with a blank slate! Remove books that member no longer want. Look them up on Books outer com to see if any websites are buying them. Otherwise member box them up and donate them to local charities or libraries. If you have books member can give to charity, set those aside now. Books to choose for this can be books that you never read, books your children have outgrown, or books you are not interested in keeping. Doing this helps your bookshelves remain clutter-free. Decide how you want to categorize the books.

Popular choices are by author, title, and subject. But if you want to organize them by height and color, this is also fine, although it might take a little extra work. Another good way to organize books is fiction/non-fiction. Also, you can put all the books you haven’t yet read together, and books that you have read together. That way, when you’re looking for a good book to read, all of the un-read books are together. Spread out all the books on a floor, bed, etc. Begin organizing them into categories. After they are all organized, double-check to make sure you don’t have a book by Zoë Zucker next to a book by Andrew Ardell, if you’re going alphabetically. Transfer each category into the bookshelf.

When organizing a child’s shelf, kid’s books tend to be taller than adult ones. Try stacking these on the tallest shelf. If you don’t have a tall shelf to put your taller books in, then after your finish organizing the other books, put it on top of the other books already put into the shelf, horizontally with the spine facing outplace binding side outwards. When placing the books on the shelf, make sure all of the book spines are facing you. Admire your work!

2.2. MAGAZINE

Everyone has a stack of old magazines lying around the house somewhere, and whether you’re walking past a newsstand in the mall or sitting in the dentist’s office, you’re going to be tempted to pick up a magazine and flip through the pages. Magazines are everywhere, but what are they exactly? On one hand, magazines are a mechanism for providing people with current information on a broad range of topics on a regular basis – usually monthly, but in some cases even weekly.

However, the word magazine was originally used to indicate a storehouse for grain or gunpowder, so how did the term come to be associated with a periodical publication? The first periodical to use the word magazine in its title was started in London by Edward Cave in 1731. Cave used the word magazine in the name of his ‘Gentleman’s Magazine’ to suggest that this new publication was a storehouse of information, providing all the news that a civilized person needed in order to keep up to date on what was going on in the world. Cave’s magazine was tremendously successful, and within a few years several spin-off publications began to appear in London and in the United State.

This should be a fun project that helps students become more effective at communicating and utilizing their computer. The final product should be a magazine of approximately ten pages with at least two articles by each member of the group. Additionally, a digital copy of the magazine will be emailed to the teacher in addition to turning in the final printed copy. Students will form groups of about four or five. They will determine the style of the magazine and the responsibilities for each member (Editor, Secretary, Photographer, etc.) Any planning should be written down neatly, and submitted to the teacher when the project is finished.

As mentioned before, each student will provide at least two articles. In addition to the articles, there should be a nice cover, title page, and credits page. It is expected that all the articles and pictures will be new, original work of the students. Copyright infringement and plagiarism is not acceptable. If required, quotes and facts need proper citations. The teacher will give approximately two weeks for the completion of this project. Wasting of time will lead to a moving up of the due date. If help is need, first be sure to ask everyone in the group and then ask the teacher.

Currently you cannot find magazine listings in the Virtual Catalog. Magazines are treated a little bit differently by online catalogs for a number of reasons. The type of record in the database is different. For instance, Time magazine comes out every week, so the library catalog record may show how many years of Time are being held by the library. This makes it harder to identify and “grab” the specific issue of the magazine for which you are looking. Libraries will usually not loan a complete issue of a magazine. Rather, library users request a specific article. We hope to add the ability to search for periodicals and request articles in the future. Magazines have gone through a complex evolution over the years, and it is instructive to think of magazines as belonging to one of three distinct categories: trade, news, and consumer.

Trade magazines are designed to inform the members of a particular professional or occupational group, of items of specific interest to them. Individuals and businesses purchase subscriptions to trade magazines, and most of the content is written by and for people in the trade – for example, accountants or school teachers. These magazines are generally not available to the general public, and any advertising that they may contain (usually not much) tends to be directed at members of that trade.

News magazines, which in the case of publications like ‘Time’ or ‘The Economist’ are often published weekly, are directed at a broad readership. These magazines are designed to provide a single source through which readers can catch up on news, current events, and hot topics. They are available in bookstores, at newsstands, as well as by subscription, and the moderate amount of advertising that they contain is quite varied with respect to products displayed, and quite general in terms of the approach taken in the ads.

The vast majority of modern magazines fall into the consumer category, and these magazines are directed at highly specific segments of the population, whether dog-lovers, gardeners, brides-to-be, or people who want to get rich. Consumer magazines usually contain a number of small articles that deal with topics of interest to the targeted group, but in most instances the bulk of available space is devoted to advertising.

In consumer magazines, advertisers have the opportunity to pitch well-defined mixes of products, in a way that speaks directly to the targeted group. For the marketer, this means that they are getting maximum penetration with their message, and for publishers this means that they can rely on the advertisers to generate the bulk of their revenue stream. With consumer magazines, actual sales of the magazine are a secondary consideration. What matters is that potential advertisers think that, through magazines, information about their products is getting directly into the hands of those people who are most likely to purchase what they are selling. Every time you pick up a magazine that catches your interest, even if only to browse through it briefly, you are one step closer to buying something, and if magazines are doing what they are designed to do that something is not going to be the magazine. In the library technical sense a “magazine” paginates with each issue. Academic or professional publications that are not peer-reviewed are generally professional magazine

Robert A. Campbell, Ph.D. writes about world affairs, particularly on matters pertaining to religion, science, global ethics, and the knowledge economy

• A periodical publication containing articles and illustrations, typically covering a particular subject or area of interest

A.   a car magazine

B.   a women’s magazine

• A regular television or radio program comprising a variety of topical news or entertainment items
• A chamber for holding a supply of cartridges to be fed automatically to the breech of a gun
• A similar device feeding a camera, compact disc player, etc
• A store for arms, ammunition, explosives, and provisions for use in military operations

The Magazine is the only monthly digest entertainment magazine of its kind for youth published in Canada. Magazine is a studio album by the hard rock band Heart. The album was certified platinum. It has an unusual history in that the first release in 1977 was not authorized by the group. A second authorized version of the album was re-recorded, re-mixed, and re-released in 1978. Magazine is an Argentine cable television channel owned and operated by Grupo Clarín from Buenos Aires. It can be tuned in all the country via subscription television.

There are many types of magazine are in library are given below:

Arts & Humanities, Business & Economics, Computers & Internet, Entertainment & Leisure, Health & Medical Sciences, Law, Government & Political Science, Reference, Science & Technology, Social Sciences, Regional & country Information

2.3. CD/DVD

Searching for information has never been easier! The automatic CD/DVD

Storage/Retrieval, File Manager can store up to 100 CD/DVDs in one unit. Each automatic CD/DVD unit is daisy-chainable up to a total of 127 automatic CD/DVD Organizer/Manager units. You can have a Digital Library that holds up to a total of 27,000 CD/DVD titles! The CD Manager allows you to categorize and manage your CD/DVD/VCD/CD-R titles (e.g. Electronic Books, Financial Data, Images, and Photos).

The CD-DVD Library Manager is only limited by your imagination. Not only can it be operated independently but also be connected to a PC for creating a powerful storage and management system for quick information retrieval. The easy-to- use catalog/search software is included for free. Just locate the disk title on the screen, click it and the CD Manager will find and eject the disk for you in no time.

This is a great new product to compliment your computer CD, DVD, and/or Audio CD library. Best of all, if you don’t have a computer, you can still use CD Manager alone! You can easily locate the correct disk you want. This product is a definite time and money saver from misplaced and damaged CD’s. We use this product in our office and highly recommend it for both home and office use.

Short for digital versatile disc or digital video disc, a type of optical disk technology similar to the CD-ROM. A DVD holds a minimum of 4.7GB of data, enough for a full-length movie. DVDs are commonly used as a medium for digital representation of movies and other multimedia presentations that combine sound with graphics.

The DVD specification supports disks with capacities of from 4.7GB to 17GB and access rates of 600KBps to 1.3 MBps. One of the best features of DVD drives is that they are backward-compatible with CD-ROMs, meaning they can play old CD-ROMs, CD-I disks, and video CDs, as well as new DVD-ROMs. Newer DVD players can also read CD-R disks.

Type of optical disc

The DVD represents the second generation of compact-disc (CD) technology. Like a CD drive, a DVD drive uses a low-power laser to read digitized (binary) data that have been encoded onto the disc in the form of tiny pits. Because it uses a digital format, a DVD can store any kind of data, including movies, music, text, and graphical images. DVDs are available in single- and double-sided versions, with one or two layers of information per side. Single-sided DVDs have become standard media for recorded motion pictures, largely replacing videotape in the home market. A double-sided, dual-layer version can store about 30 times as much information as a standard CD. DVDs are made in a ROM (read-only memory) format as well as in erasable (DVD-E) and recordable (DVD-R) formats. Though DVD players can usually read CDs, CD players cannot read DVDs. It is expected that DVDs will eventually replace CDs, especially for multimedia workstations.

(Digital VideoDisc or Digital Versatile Disc) An optical digital disc for storing movies and data. Introduced in the U.S. in 1997, and developed by both the computer and movie industries, the disc uses the same diameter platter as a CD (120mm/4.75″ diameter), but holds 4.7GB rather than 700MB. Whereas CDs use only one side, DVDs can be recorded on both sides as well as in dual layers. DVD drives/players read most CD media as well

A DVD-RAM is a rewritable DVD that functions like a removable hard disk. DVD-RAM media can be rewritten 100,000 times before they are no longer usable. DVD-R and DVD+R are competing write-once formats for movies or data. DVD-RW and DVD+RW are competing rewritable (re-recordable) formats that unlike DVD-RAM’s 100,000 cycles can only be rewritten 1,000 times. Aimed at the consumer, 1,000 rewrites is considered more than sufficient.

Originally, “Digital VideoDisc.” Since the technology became important to the computer world, the “video” was dropped, and it was just D-V-D. Later, it was dubbed “Digital Versatile Disc” by the DVD Forum. Take your pick. The formats endorsed by the DVD Forum have a hyphen in their names and are verbalized as “DVD minus R” or “DVD Dash R” (DVD-R) and “DVD minus RW” or “DVD Dash RW” (DVD-RW). The competing formats from the DVD+RW Alliance use a plus sign: “DVD plus R” (DVD+R) and “DVD plus RW” (DVD+RW). Starting in 2002, drives that supported both Minus and Plus formats were introduced.

2.4. JOURNAL

The word “journal” has been derived from the French word “jour”. Jour means day. So journal means daily. Transactions are recorded daily in journal and hence it has been named so. It is a book of original entry to record chronologically (i.e. in order of date) and in detail the various transactions of a trader. It is also known Day Book because it contains the account of every day’s transactions.

 Journal has the following features: Journal is the first successful step of the double entry system. A transaction is recorded first of all in the journal. So the journal is called the book of original entry. A transaction is recorded on the same day it takes place. So, journal is called Day Book. Transactions are recorded chronologically, so, journal is called chronological book. For each transaction the names of the two concerned accounts indicating which is debited and which is credited, are clearly written in two consecutive lines. This makes ledger-posting easy. That is why journal is called “Assistant to Ledger” or “subsidiary book” Narration is written below each entry. The amount is written in the last two columns – debit amount in debit column and credit amount in credit column.

The following arte the advantages of journal: Each transaction is recorded as soon as it takes place. So there is no possibility of any transaction being omitted from the books of account. Since the transactions are kept recorded in journal, chronologically with narration, it can be easily ascertained when and why a transaction has taken place. For each and every transaction which of the two concerned accounts will be debited and which account credited, are clearly written in journal. So, there is no possibility of committing any mistake in writing the ledger.

Since all the debits of transaction are recorded in journal, it is not necessary to repeat them in ledger. As a result ledger is kept tidy and brief. Journal shows the complete story of a transaction in one entry. Any mistake in ledger can be easily detected with the help of journal. While recording transactions in journal the following two objects must be aimed at: That each entry in the journal should be so clear that at any future time we may, without the aid of memory, perceive the exact nature of the transactions. That each transaction should be so classified that we may easily obtain

the aggregate effect of such transactions at the end of a certain period. The act of recording transactions in journal is called journalizing.

The rules may be summarized as follows: Use two separate lines for writing the names of the two accounts concerned in each transaction. write the name of the debtor or account to be debited in the first line and the name of the creditor or the account to be credited in the next line Write the name of the account to be debited close to the line starting the particulars column and that of the account to be credited at a short distance from this line. Use “Dr” after each debit item and “To” before each credit. The term “Cr.” after a credit item is unnecessary, as if one account is debtor, the other must be creditor. To separate one entry from another a line is drawn below every entry to cover particulars column only. The line does not extend to amount column.

We are going to begin writing an account of this school year that will include our thoughts and feelings about what is happening in class. Each of you, on a weekly basis, will use the computer to word process your thoughts about all that you are learning. You will maintain a special file where you jot down notes each day about what you have accomplished, so that when you write your account you will have a way to remember all that happened since the last time you wrote. Of course you may include discoveries you make on your own whether at school or at home.

Many people, throughout history, have done the same thing you will be doing. Sometimes their thoughts have remained private; other times these thoughts have been published and shared with others. The writing you will be doing will be shared, so if you also want to keep some thoughts private, you will have the option of writing a separate version for yourself that you can keep secret. A journal is a type of diary. I have a copy of a journal entry for each of you. After I pass them out, I will read the entry aloud while you read it silently.

Proposed of Online Library Management System

3.1. E-R diagram of Online Library Management System

3.2. Main Features of the system are:

The system can support large volume of elements and can maintain member’s data in the form of registers in which all the details of the college member’s are kept.

Issue Procedure:

Student can issue the elements (3books, 1cd/dvd, 1 magazine, 1 journal at a time) using the allotted issue cards to him. The Librarian takes off the issue card from the elements in which all the details of the elements are written viz. bar accession number, title of the bar, author of the book, bar name, bar code. He attaches the bar card with the issue card of the member s and places it in the record column.

 Elements return procedure:

Member s are required to return the book within the due date. The element is taken by the librarian then the issue card of that member id taken out from the stored records, then the bar card is again placed in the respective elements and the issue card is returned to the member by no longer holds that elements with him. If the element is not returned within the due date then the fine is calculated as mentioned below.

Addition of new element:

Member can also request for the addition of the new element in the library if his choice of the element is not present in the library by filling up the new elements request form. If more than 10 member s demands for the same elements then librarian staff meeting is held to discuss to how to process the element in the library with the total number of the required elements based on students demand.

Fine system:

 It is required by the librarian to calculate the fine which is paid by the member on not returning the elements within the return date of the elements.Libraian sees the issue elements register and checks the issue date and return date along with the student’s details. The cost of the fine is Rs.1/day for a elements and is calculated as the difference between the current date and the return date.

Deletion procedure:

Deletion of the element from the library registers is required in case where the element has been lost or completely damaged by the borrower on the timely detoriation of the element. The entry of that book is deleted from all the above 3 registers maintained previously and the student is supposed to pay fine or causing unwanted damage to library property if he does.

3.3. The lists of attributes of these entities are as follows:

3.4. Context Level DFD: