normalization example of library management system
Posts: 14,118
Threads: 61
Joined: Oct 2014
An integrated library system (ILS), also known as a library management system (LMS), is a business resource planning system for a library, used to track proprietary items, orders made, invoices paid, and customers who have Borrowed.
An ILS generally comprises a relational database, software to interact with that database, and two graphical user interfaces (one for the clients, one for the staff). Most ILSes separate software functions into discrete programs called modules, each integrated with a unified interface.
Examples of modules may include:
• acquisitions (ordering, receipt and billing of materials)
• cataloging (sorting and indexing of materials)
• circulation (loan of materials to customers and reception of them back)
• serial publications (tracking magazines, magazines and newspapers)
• OPAC (public interface for users)
Each user and article has a unique ID in the database that allows ILS to track its activity. Larger libraries use an ILS to sort and acquire, receive and bill, catalog, circulate, track, and archive materials. Smaller libraries, such as private homes or non-profit organizations (such as churches or synagogues, for example) often waive the costs and maintenance required to run an ILS, and instead use a computer system Library.