Modern Libraries are not made up of just Books but CD ROM’s, Articles, ProjectReports, Bound volumes are substantial part of the holding, Managing the holdingsmanually is a not a simple job. There are few solutions but many a times, we findourselves “making them works” by finding “ways to work around” system inadequacies. Moreover we have limited staff resources, these “work around” waste time, effort, andskills that should be spent on user services. Many solutions do not keep up with the technological changes and hence prove to betime wasters.
Library Management system is a small footprint software suitable for personal /individual Libraries. You can store the information about the books and other materialand control the movement of the same. Silent Features * Control the movement of books and other material and avoid loosing the same. * Search if you have a specific book in your collection based on the title, author etc. * Print the spine labels for the book. Find what a specific person has borrowed from you. It offers the following modules Cataloguing, Circulation, Queries Cataloguing – Salient Features.
You can create a catalogue of your books, CDs, maps, drawings and all similar collections using this module. It supports various classification schemes likeDDC, DD, and CC etc. The cataloguing module is based on AACR2 (Anglo AmericanCataloguing Rule Circulation Circulation module deals with issue and return of material from the Library. It is a barcode and smart card enabled system and hence the issue and return of material is handled uniformly. You can issue member cards and also do the transactions 1. 1. BACKGROUND OF THE STUDY * CEU- CENTRO ESCOLAR UNIVERSITY.
Centro Escolar University was established on June 3, 1907 by Dona Librada Avelino and Dona Carmen de Luna for the instruction and training of the youth in all branches of the arts and sciences. With some benches, a single blackboard and a few books, the two educators steadfastly nurtured a dream of establishing a nationalistic center of learning for Filipino women. The first college, that of Pharmacy, opened in 1921. The College of Liberal Arts, Education and Dentistry followed one after the other. Three years later, the College of Optometry was established. LIBRARY SYSTEM.
The University Library in Mendiola, Manila is an integral part of the educational facilities of CEU. the resources consist of PRINT, NON PRINT collection and ELECTRONIC materials. Print materials are composed of volumes of books supplemented with foreign and local periodical titles received through subscriptions, gifts and exchange. Non print materials include the CD-ROMS of books and periodicals and microfilms. Internet facilities are available for electronic resources and online subscriptions to professional journals. The following are installed in the different units of the library: 1.
CD-ROM of books and periodicals available at the Reference, Dental, Periodicals and the Graduate Unit Library 2. Internet facilities – available at the Cybrary 1 & 2, Dental and the Graduate Unit Library. 3. Microfilms of selected local newspapers and magazines available at the Periodicals Unit. 4. Online subscriptions to professional journals available online on the web site. 5. Online Public Access Catalog (OPAC) database for books accessible in all library units, CEU Intranet and Internet. 6. Periodical Index database – available at the Periodicals, Dental and Graduate Unit Library.
The University Library is located on the first, mezzanine and second floors of the Carmen De Luna Hall (CDL), and on the second Floor of the Library Avelino Hall (LAH). The Dental Unit Library is situated on the third floor of Dent/Science Building. Borrowing & Circulation RESERVED BOOK COLLECTION – Books requested by faculty members in the various courses are placed on reserve. These books may be read in the reading room only on one-hour loan subject to renewal if no other students need them. Overnight loans are allowed for reserved books at 4:00 p. m.and are to be returned not later than 8:00 a. m. the next day. Reminders:
1. The Identification card is non transferable and must be presented to the librarian every time a home reading book is borrowed or renewed. 2. The Identification card is necessary every time a student enters the library. Fines and Penalties 1. A fine of Php2. 00 a day is charged for failure to return a circulation book on its due date. 2. For failure to return a reserved book on overnight loan at 8:00 a. m. , the following class day, a fine of Php2. 00 for every succeeding hour. 3.
A book that is lost should be reported at once to library service desk where it is charged. 4. A book not returned within seven (7) days after due date or recall shall be replaced within thirty (30) days. 5. Any library user who shall deface, mutilate, or steal any library material or property shall be required to replace the same and in appropriate cases be referred to the Student Affairs Office. 6. Lending of the identification card and with book borrowed on it will subject the owner of the card to suspension of library privileges for two (2) weeks. 7.
A library user who fails or refuses to settle his outstanding library account shall not be: a. allowed to register b. permitted to use the library c. given clearance from the library 8. Making noise or loud conversation and eating within the library premises are strictly prohibited. 9. Using a cellular phone inside the library is prohibited. Any student violating this rule shall be penalized according to the University’s system of discipline. 10. Violation or infraction of the rules and regulations of the library shall not be excused on the plea of ignorance.
CIRCULATION UNIT – Books in the Circulation Unit may be borrowed for home use: 1. Period of loans Regular semester: Three (3) days for undergraduate students and one week for graduate students and faculty Summer session: One week for both graduate and undergraduate students. 2. Loans of any books are renewable for the same period if not needed by other students or borrowers. 3. Number of loans Undergraduate students Two (2) books at a time, or more on meritorious cases Graduate students and faculty: Five (5) books at a time or more depending on need Service Hours: Regular Semester.
Monday-Saturday — 8:00 a. m. – 6:00 p. m. Summer Session Monday-Saturday — 8:00 a. m. – 6:00 p. m. DENTAL UNIT – Professional books and periodicals in the field of Dentistry are available in this unit. Except for reference books and periodicals, they may be borrowed for home use for three (3) days. The unit has internet facilities exclusive for the use of Dental students. 1. Period of loans Regular semester: Three (3) days for undergraduate students and one week for graduate students and faculty. Summer session: One week for both graduate and undergraduate students. 2.
Loans of any book are renewable for the same period if not needed by other students or borrowers. 3. Number of Loans Undergraduate students Two (2) books at a time or more 0n meritorious cases Faculty Two (2) books at a time or more depending on need Services Hours: Regular Semester/Summer session Monday – Friday — 8:00 a. m. – 5:00 p. m. Saturday – 8:00 a. m. – 12:00 noon PERIODICALS UNIT – Periodicals of current and back issues available in this unit are for Room Use only. It also includes the following: 1. Microfilms of selected local newspapers and magazines in CD-ROM and DVD-ROM formats. 2.
Periodical titles in CD-ROM format 3. On-Line Periodical titles available on the website Computer workstations are available in this unit for journals in CD-ROMS. Articles found maybe printed out for Php 5. 00 per page. Print materials, however, may be photocopied for 15 minutes only. Service Hours: Regular Semester Monday-Saturday – 8:00 a. m. – 6:00 p. m. Summer Session Monday-Saturday – 8:00 a. m. – 6:00 p. m. REFERENCE UNIT – The Unit has a collection of reference materials in text form and in electronic format. The text form is limited for Room Use, and may be photocopied for 15 minutes only.
Computer workstations are available for reference materials that are in CD-ROM format. Researchers may request print out of the article for Php 5. 00 per page. FILIPINIANA UNIT – Materials available in this unit are: 1. Filipiniana books and other materials which may be drawn out for home use or room use only depending on the type of materials. 2. Filipiniana Reference books such as Philippine yearbooks, encyclopedias, dictionaries, biographical sources, almanacs, etc. are for Room Use only and may be photocopied for 15 minutes only. 3.
Undergraduate Research Collection – a collection of undergraduate theses and feasibility studies submitted by the graduating students to their respective school/college and turned over to the library for use as references by incoming fourth year students. These materials are for ROOM USE ONLY. Service Hours: Regular Semester/Summer session Monday-Saturday – 8:00 a. m. – 5:00 p. m. Science Unit – Materials available are: SCIENCE UNIT – Materials available in this unit: 1. Circulation books with class nos. 500-599; 600-649 and 660-699 are available in this unit.
1. 1. Period of loans Regular semester: Three (3) days for undergraduate students and one week for graduate students and faculty. Summer Session: One week for graduate students and faculty. 1. 2 Loans of any book are renewable for the same period if not needed by other students or borrowers. 1. 3 Number of Loans: Undergraduate students – Two (2) books at a time or more in meritorious cases. Faculty and Graduate students – Five books at a time or more depending on need. Service Hours: Regular Semester/Summer Session Monday to Saturday 8:00 a. m. – 6:30 p. m.
CYBRARY UNIT – On-line researching can be done in this unit. The Internet Services supplement the existing print materials in the library. Students are allowed to browse web pages and to do e-mail but on a specified time only. In this unit you can also borrowed a WiFi card bus adapter, ten (10) free per month and a fine of Php0. 50 cents per minute if the user exceed the allotted time. Services Hours: Regular Semester Cybrary 1 – Monday-Friday – 8:00 a. m. – 5:00 p. m. Cybrary 2 – Monday-Friday – 8:00 a. m. – 5:30 p. m. Summer Session Monday-Saturday Cybrary 2 – Monday-Friday 8:00 a.
m. – 5:30 p. m. GRADUATE SCHOOL UNIT LIBRARY – Materials available in this unit: 1. Master’s theses and doctoral dissertations submitted to CEU Graduate School 2. Abstracts and indexes 3. Professional journals and periodicals of general interest 4. Professional books for the different course offerings in the Graduate School which may be borrowed for home use for one week. 5. CD-ROMs and Internet facilities Materials in nos. 1-3 are for Room Use Only. Service Hours: Regular Semester Monday- Friday 12:00 p. m. – 8:00 p. m. Saturday – 7:00 a. m. – 6:00 p. m. Summer Session.
Monday- Saturday – 7:00 a. m. – 6:00p. m. 1. 2. OBJECTIVES OF THE STUDY 1. 3. 1. GENERAL OBJECTIVES To design a database for a library which will help to minimize the duplication of data, get rid from paper filling system and it makes the processing of datavery easy without waste of time. 1. 3. 2. SPECIFIC OBJECTIVES * To make it easy to search any record It will be much easier to find particular record rather then opening such huge files and finding a single record from them. * To keep the data secure The data will be much secure from any unauthorized access.
It will be made secure by using passwords and by taking other security measures. * To edit the records and update the database easily Records will be easily edited and the database will easily be updated at the time of entering a record. * To make the system user friendly The system will be much more easy to use and the operator will feel no difficulty. 1. 3. SIGNIFICANCE OF THE STUDY Library is the best place in the School where the students review and study. It is the place where students study so our group aims to improve the manual operation of the library system.
We thought of something that makes the time of students and library personnel decreases for searching and borrowing of books. To maketheir library system to be automated. So that managing of their librarywill be more efficiently and secure. 1. Students/borrowers It will be easy for them to know if the book they’re searching inthe library is existing and they will have lesser time to locate where thebooks located. 2. Library personnel It will lessen their paper works when it comes to maintaining datathat contains all the records in the library as the computer restore thedetails. 3. School.
The library management system is to provide quality data in the School in a timely fashion through systems that are completely integrated. This will provide opportunities for operational efficiency. 4. Researchers We are encouraged to cooperate each other for the success of this study. For we know that this proposed study can help for the betterment of the files of our chosen company. We learned more about Library System. 1. 4. SCOPE AND LIMITATION OF THE STUDY * SCOPE Easy to search any record It will be much easier to find particular record rather then opening such huge files and finding a single record from them.
Keep the data secure The data will be much secure from any unauthorized access. It will be made secure by using passwords and by taking other security measures. It can edit the records and update the database easily Records will be easily edited and the database will easily be updated at the time of entering a record. It is user friendly The system will be much more easy to use and the operator will feel no difficulty. * LIMITATION Libraries may need to change their LMS every now and then to avoid lagging behind the technology.
Although a library management system’s end goals include cutting costs, setting up a new system initially requires a substantial amount of money and resources. Libraries not only pay for the software but may also spend for new computers, installations, hosting and maintenance. In addition, libraries must hire or train an IT support team to deal with computer network glitches. As LMS becomes more sophisticated and costly, there may be less need for traditional library staff, leading to a decrease in employment opportunities in the industry. CHAPTER 2 2. REVIEW OF RELATED LITERATURE 2. 1. LOCAL LITERATURE.
U. P. Library System The University Library of UP Diliman encompass one Main Library and thirty-five (35) College or Unit Libraries. It envisions global information exchange throughout the UP Library System. It is mandated to be the information resource center of excellence in the social sciences, humanities and basic sciences. It strives for full automation, a world-class collection and a staff of thoroughly modern information professionals. The University Library was officially established by the Board of Regents in 1922, fourteen years after the founding of the University of the Philippines in 1908.
The University Library, which was at the same time designated as the Department of Library Science was placed on equal level with other departments of instruction for the services of all colleges of the university. Between the years 1908 to 1922 University constituents made use of small libraries in the various units and colleges of the university and government libraries in Manila for their research and information needs The UP Diliman Library Collections have been developed in aid of teaching, research and extension work in the disciplines designated to Diliman.
Topping the list of choice collections in UP Diliman are the Filipiniana Collections, which come in print, non-print and digital forms. P. U. P. Library System The books in the library are arranged on the shelves according to the Library of Congress Classification System. This is a system where the fields of knowledge are identified by letters, which are used in assigning the class number of library materials. The letters are combined with Arabic number, other letters and author notation, which complete the call number of a book. The outline is presented below: Access to Collections The Card Catalog.
The card catalog, which serves as guide to the holding of the library, is available at the 3rd Floor of the NALLRC Building. It is maintained as backup in case there is a problem in electrical power or in the event that on-line system bogs down. The catalog cards contain descriptive information of a book such as call number, author, and title, place of publication, publisher, copyright date, collation, notes and subject. The card catalog is always helpful in finding out whether or not a desired book is among the library’s holdings and if it is, where it may be located. Online Public Access catalogue.
The Koha Open Source System is the system that the NALLRC is using. It is designed for better access to its collections and for an improved and faster delivery of services. The system allows on-line inquiry regarding NALLRC resources. The OPAC is located at the third floor lobby of the NALLRC Building. The satellite libraries have their own stand-alone computer for their own access. Electronic Resources On-line database such as e-books and e-journals by Gale Virtual Library and Academic OneFile as provider are one of the latest Information technology tools that the NALLRC has acquired.
Multimedia Resources The NALLRC also acquires multimedia resources, which are in various titles for the research needs of the clientele that support its mission, vision, goals and objectives of. The following multimedia resources are audio cassettes, beta tapes, Compact disks, compact disks-read only memory, floppy disks, slides, VHS tapes. U. S. T. Library System University of Santo Tomas Central Library (UST Central Library) boasts a precious collection of rare books and manuscripts which are unique in the Philippines.
It has several sections such as General References and Information, General Circulation, Music, Science and Technology, Rare Books, Civil Law, Graduate School, Social Sciences, Filipiniana, Spanish, Asian, Map Room, Humanities, Serials and Old Books. Making it more automated, it has CD-ROM that offers several databases, 85 Internet terminals, 12 Library Online Reader’s Network Zone (LORENZO, an alternative to traditional catalog), and 8 computers for research, four computer stations as return chutes and barcode scanners, and a Security Check System.
2. 2. FOREIGN LITERATURE University of Phoenix Library System With a long history of educational and technological innovation, University of Phoenix has established an extensive university library with a comprehensive array of scholarly and professional research material. The core of the library consists of a collection of databases available to students and faculty. The University Library houses more than 100,000 electronic periodicals as well as e-books of interest. The eBook Collection is made up of 200,000 electronic books.
Students and faculty have access to the entire eBook Collection throughout their degree programs. The University Library and eBook Collection are available to users seven days a week from anywhere there is an Internet connection. Students and faculty frequently take advantage of the extensive library, downloading or viewing over 3 million documents each month. University of Phoenix updates traditional course reserve readings by offering the electronic readings with direct links to articles and pre-formatted searches.
A team of professional librarians and research specialists provide support to the library and respond daily to student or faculty inquiries. The extensive university library resources have been specially designed for the unique needs of University of Phoenix and to enhance our students’ overall experience. Everglades University Library System The Everglades University Library supports the mission of the University by providing students with academic resources and research skills necessary to become independent learners in a changing environment. The academic library has more than a collection of books and journals.
The Everglades University Electronic Resources will provide students with access to databases and indexes, electronic journals, a catalog, eBooks, and other valuable resources: http://www. evergladeslibrary. com Campus Library Hours of Operation Boca Raton (Main Campus) Monday, Tuesday & Thursday: 8:30am to 10:00pm Wednesday & Friday: 8:30am to 9:00pm Saturday: 8:30am to 5:00pm Sunday: Closed Telephone (888) 772-6077 Fax (561) 912-1191 Orlando Campus (Branch Campus) Monday-Thursday: 8:30am to 10:00pm Friday: 8:30am to 5pm Saturday: 8:30am to 5pm Sunday: Closed Telephone (866) 289-1078 Fax (407) 482-9801.
Sarasota Campus (Branch Campus) Monday-Tuesday: 7:30am to 9:00pm Wednesday: 7:30 to 10:00pm Thursday: 7:30am to 9:00pm Friday: 7:30am to 5:00pm Saturday: 9:00am to 5:00pm Sunday: Closed Telephone (866) 907-2262 Fax (941) 907-6634 Subscription Databases Everglades University subscribes to a variety of electronic resources many with full-text peer-reviewed journal articles. Our students and faculty can enter and search all of the following databases from our library catalog LIRN: LIRN InfoTrac, ProQuest, Credo Reference, eLibrary, and Bowker’s Books in Print AGent VERSO ™: online library catalog.
Ask-a-Librarian Service (live chat, text, and 24-hour email) Aviation Week Intelligence Network (AWIN) BuildingGreen Suite ebrary (electronic book collection) EBSCO A-to-Z EBSCOhost: Business Source Complete, CINAHL, MEDLINE, Regional Business News, Alt HealthWatch, Energy & Power Source, Entrepreneurial Studies Source, GreenFILE, Health Source: Nursing/Academic Edition, and Business Continuity and Disaster Recovery Reference Center. Library’s Blog: http://eulibraries. wordpress. com Natural Standard Salem Health Salem Historical Encyclopedia of American Business Westlaw (Librarian Access).
Services and Resources Print collection at each campus Full-time Librarians Computer and audiovisual resources Internet access on all computers Microsoft Office Applications (Word, Excel, PowerPoint, and Access) Reference Materials Periodicals Newspapers-Wall Street Journal, USA Today, South Florida Business Journal, local dailies Southeast Florida Library Information Network (SEFLIN) Associate Member Tampa Bay Library Consortium (TBLC) Northeast Florida Library Information Network (NEFLIN) Wireless access, free computer printing, coin-operated photocopier Interlibrary loan Flight Simulator.
*The flight simulator located at the Sarasota Campus is not located in the library. Please see campus administration for the location of the flight simulator. CHAPTER 3 3. DATABASE DIAGRAMS AND FIGURES Figure.
1. Relational Data Structure of Library Database Management System BOOK NUMBER ISSUE ID NUMBER FIRSTNAME ID NUMBER LAST NAME STUDENT ADDRESS COURSE DATE ISSUE DUE DATE CONTACT NUMBER SECTION DATE RETURN DATE ISSUE BOOK NUMBER ID NUMBER RETURN BOOK NUMBER PUBLISHER AUTHOR TITLE BOOKS Figure 2. Entity Relationship Model of Library Database Management Sytem RECORD-BASED RELATIONAL MODEL.
ID NUMBER Figure 3. 1. Relational Model FIRST NAME ADDRESS CONTACT NUMBER SECTION COURSE LAST NAME STUDENT BOOK NUMBER ID NUMBER DATE ISSUE DUE DATE ISSUE PUBLISHER BOOK NUMBER TITLE AUTHOR BOOKS ID NUMBER DATE ISSUE DATE RETURN BOOK NUMBER RETURN Figure.
3. 2 NETWORK MODEL Figure 3. 3 HIERARCHICAL MODEL CHAPTER 4 LIST OF APPENDICES 4. 1. SAMPLE FORMS AND REPORTS Sample Reports Screen Design DEFINITION OF TERMS * First name- the first name of the end-user. * Id- unique number of identification. * Date return- the date, time of returning the book. * Date issue- the date, time of borrowing the book.
* Book number- the unique numbering of the book. * Publisher- the publisher of the book. * Author- the author of the book. Chapter 6 Conclusion and Recommendation Conclusion The design and evaluation of an automated library database system is easily accessible to the students and others who enter and uses a library for them to have an organized and well performed library access in their schools. People who use the designed database will be able to have good time management. The Classification for books can be accessible and they can easily search for the book they wanted to be.
We conclude that the design and evaluation of this database is the basic for having databases of books. Recommendation We are recommending the designs and evaluation of the database for small libraries. Also we recommend the system for free testing. As the system is for free testing we are willing for a free tutorial about our system. And we are highly recommending this system for schools to have an organized and well-provided library for the access of the students. Also we are making this system to have a systematized production of your library.
Alyzza Marie G.Baniqued E-mail add: [email protected] com Blk-7 Lot-30 Celina Homes, Camarin, Caloocan City Mobile no. +639097090551 PERSONAL DATA Provincial Address: Lingayen, Pangasinan Date of birth : November 21, 1992 Place of birth: Makati City Civil status: Single Sex: Female Citizenship: Filipino Height: 5’1’’ Weight: 99 lbs Religion: Roman Catholic Father’s Name: Bernardino Baniqued Mother’s Name: Irene Galvan Languages/dialects: Filipino and English EDUCATIONAL BACKGROUND Tertiary: Associate in computer technology Bestlink College of the Philippines 1071 Bgy.
Kaligayahan, Quirino Hi-way, Novaliches, Quezon City June 2011-present Secondary: Cielito Zamora High School Annex 1 Brgy. 177 Cielito Homes, Caloocan City Year Graduated: 2010 Primary: Camarin Elementary School Main Camarin, Caloocan City Year Graduated: 2006 Kristine Jhoy Tatad E-mail add: [email protected] com Ph7b pkg3 Blk87 Lot12 Bagong Silang, Caloocan City Mobile no. +639303962663 PERSONAL DATA Provincial Address: Catanduanes Bicol Date of birth : February 20,1995 Place of birth: Caloocan City Civil status: Single Sex: Female Citizenship: Filipino Height: 5’6’’ Weight: 45kg.
Religion: Roman Catholic Father’s Name: Robert L. Tatad Mother’s Name: Ligaya V. Tatad Languages/dialects: Filipino and English EDUCATIONAL BACKGROUND Tertiary: Associate in computer technology Bestlink College of the Philippines 1071 Bgy. Kaligayahan, Quirino Hi-way, Novaliches, Quezon City June 2011-present Secondary: Tala High School Tala Caloocan City Year Graduated: 2011 Primary: Pag Asa Elementary School Bagong Silang Caloocan City Year Graduated: 2007 MARK BREN V. PIRA E-mail add: [email protected] com Kingspoint subd. Sauyo novaliches quezon city. Mobile no. 09127421319.
PERSONAL DATA Provincial Address: tarlac city Date of birth : march, 10, 1992 Place of birth: caloocan Civil status: Single Sex: male Citizenship: Filipino Height: 5’8’’ Weight: 130 lbs Religion: Roman Catholic Father’s Name: Glen Pira Mother’s Name: Annabelle Pira Languages/dialects: Filipino and English EDUCATIONAL BACKGROUND Tertiary: Associate in computer technology Bestlink College of the Philippines 1071 Bgy. Kaligayahan, Quirino Hi-way, Novaliches, Quezon City June 2011-present Secondary: tanyong highschool Marikina city Elementary: ninoy Aquino elementary school.