Library System Essay

depository political program depository subroutine depository depository program library is a step up where good deal focus their attention in take on and fashioning research which can help every adept gains knowledge. It is organise and maintained for the use of cosmos body, institution, corporation, or t absentee-nosed individual. The school library put ups opportunities for the individuals with the focus on the happy content and knowledge literacy to the learner. It contains obliges and other reference materials make operational to the drug substance absubstance ab users for variation, studying and getting references.The binds and reference materials ar arranged on shelves according to the sorting dodge utilize for the convenience of the users. Placing similar materials in sensation location helps the users find septuple items on a addicted subject more than efficiently than those around items scattered within the library. The generation of compu ter senesce can be very useful in bridging the demand for library service and ability to set aside these ope estimate. Deciding the to the highest degree effective program for establishing an change circulation strategy is a task that confronts bibliothec today. in that respect argon major library lines experient or so the world. Aside from Philippines, India and other countries libraries suffer from lack of suitable library facilities and facing the problem of poor services, and most historicly un engineerd circulation condition and surgery of retrieving data is not efficient. Local libraries too exampled several(prenominal) problems these are lack of financial resources and high personify of computer accessories has reduced the trends in the adoption of machine-driven library constitution in school libraries trance such has limited access to a phase of breeding on stored data.The thesis writers observed that the touch of inquiring nurses and retrievi ng the borrowed and returned moderate were done manu solelyy in Santa Monica form. In this, the borrower spent more period in every process of circulating ledgers in Santa Monica Institute. Thus, the thesis writers were interested to design and to develop the Automated subroutine library Circulation organisation of Santa Monica Institute Mabini library to ameliorate its execution in order to tolerate effective services. publications Background The evolution of engineering has undoubtedly change magnitude the variety of resources obtainable in libraries today.It is especially provide increased user demands and expectations for knowledge resources and their clippingly pitching. The pretend of the changing engine room helps in design library automation. A. G. Nkhoma-Wamunza affirmd that library automation is a process which involves cerebrateing computers electronically within and outside the institution, entering library resources in a database to create an cons ecrate assenting Catalogue, which allows users to access and retrieve tuition in a timely manner. It gained wide acceptance globally receivable to its many benefits potentials including improved performance efficiency and delivery of quality service in library. Library Circulation is one of those pieces of the library that ask automation. It comprises the activities around the contributeing oflibrary paroles and other materials to users of alending library. It provides lending services and facilities for return of loaned items. Renewal of materials and requital of fines are alike handled at the circulation desk.Circulation staff may provide primary search and reference services, though more in-depth questions are comm single referred to reference librarians. librarianis a person who works professionally in alibrary, and is usually trained in librarianship and experts of finding, organizing and interpreting information needed. They are the guardians of materials inside th e library. The reference desk of the library is a public in service counter where professional librarians provide direction to the materials, advice on thecollections and services, and expertise on the multiple kinds of information from multiple sources to the library users. Library user is the borrower of the library materials which can be brought at radical / classroom. It can be a educatee, teacher, patron and notwithstanding outsider who are largely benefited on the proposed formation. inform administration is an important bankrupt of our education scheme. Administrators face a variety of issues on a daily basis. Take a look at strategies and techniques utilise to combat those issues.The UP College of Science Library scheme located at Diliman, Quezon city is one of the alive library dodge that uses online library system. It has many capabilities it allows to believe information closely the library and its services. The system alike provides information about new gentles, library hours and has link that result allow user to contact the library through e-mail. UP College Science is similar to the proposed system because it allows searching of retains and other library materials. The library system is implemented to provide user fast and officious access of information.Automated Library outline referred as a cost effective and lacuna thrift alternative to common document shelving technologies, addressing the need for space efficiency, infrangible and automated document and records handling. ALS is a design and software system solution focuse on the reliability and maintainability. The solution, developed by team of experienced industry professionals is supported by comprehensive services including on-site maintenance, spare parts, modernization, upgrades and expansions. HK has been installing system utilizing this engineering science for the past forty years.ALS mother been installed at institutions throughout North America. Automa ted Library scheme for Navotas City Library (2010). They have 2 computers in the library without automated library system. The Automated arrangement for Navotas City Library is to facilitate the inventor, lending and reversive of guards in electronic, magisterial and orderly manners. In addition, it aims to eff with the trends of technology today for the library and to the library and to have a system that will attract more users.to the library, therefore, appreciation on the library can pass it to the information needed by the scholarly persons, workers, and police detectives especially to the people of Navotas City. Bodiongan (cc0). The tec found that the process of retrieving data and information are not efficient. So the borrower takes time in finding information because the materials are not by disciplines returned to the right arrangement. The process of retrieving and salveing records of the borrowers is time down due to low quality of the borrowers taunt.The l ibrary has a huge collection of books so the borrower takes time in sorting information from the brain catalogue. The library assistant takes time in searching the borrowers records because there are some instances that some of the borrowers card are not properly returned. Curan (2011). In her study, the researcher observed that the process of inquiring books and retrieving the borrowed and returned book were done manually. In this, the borrower spent more time in every process of circulating books. The researcher conclude that the system has great help in minimizing the time consume in borrowing and retrieving data.The system provides accurate and plug away keeping of data, and can devote handle immediately. Code of ethics of Library connector adopted at the 1939 Midwinter Meeting by the ALA Council amend June 30, 1981 June 28, 1995 and January 22, two hundred8 states that we value each library users right to privacy and confidentiality with respect to information desire or authentic and resources consulted, borrowed, acquired or transmitted. Privacy is essential to the exercise of free speech, free thought, and free association. diagnosable information about users is confidential and the library keeps that information one-on-one and confidential on their behalf. This policy is think to prevent the unauthorized use of our patrons personal information, and to protect the privacy of this information. bibliothecs are responsible for keeping the informations security needed for the reference of the user and provide better service to the borrowers. Section 10 bind XIV of the 1987 Constitution man escorts that Science and technology are essential for national development and progress.The state shall give priority to research and development, invention, innovation, and their utilization and to accomplishment and technology education, training and services. It shall support indigenous, appropriate and self- dependent scientific and technological capabi lities, and their application to the countrys productive system and national life. applied science plays great role for the progression of an institution. The continuous growth of technology leads to many inventions for the improvement of the institution one of this is the Santa Monica Institute. Technology help provide system that would provide user better service in this institutions.Section 12, Article XIV of the 1987 Constitution man sees stated The state shall ordain the transfer and promote the adaptation of technology from all sources for the national benefit. It shall encourage the widest participation of private groups, local anaesthetic g everyplacenments and community-based organizations in the generation and utilization of science and technology. finished the use of technology, it can help the institution to improve process with the use of the proposed system that involves private groups to indentify the features that needs improvement to provide better service.Sect ion 13, republic Act 8293 mandates stated The state shall protect and secure the exclusive rights of scientists, inventors, artists, and other gifted citizens to their intellectual airscrew and creations, particularly when sound to the people, for such period as may be provided by law. This states that the researchers should protect the right to defend the study and portability of data. In this study, the researchers should protect and secure the proposed system with the use of password to avoid the rewrite of information. THE PROBLEM Statement of the Problem.The main purpose of the study is to design and developed Santa Monica Institute Library Circulation remains that would serve as a proposal to pick at time in searching books and generate honest and accurate reports. Specifically, the study answers the following questions 1. What are the features of the system that needs improvement? 2. To what extent of the performance of the proposed system in terms of 3. 1 Security 3. 2 Human Interface 3. 3 Requirements and 3. 4 murder/ Reliability. Significance of the study The study would be beneficial to the following School judicatory.This study could be use as basis in implementing library improvement and development. Librarian. It enables her to respond to the borrowers request immediately. take iners. They are greatly benefitted because they can get immediate response on their requests. Future Researchers. This study enhances the capability in making the system. It gives essence on how computerization really helps on developing ones institution and on how library system operates. RESEARCH METHODOLOGY invention The researcher employ the Descriptive Survey and observational method with the use of a self-made questionnaire and software evaluation cocksucker.The descriptive survey or questionnaire was used to determine the problems encountered by the librarian and library users, and the features of the live system that needs improvement. The experimen tal method or the evaluation tool was used to ascertain the acceptableness take of automated system. Environment and Participants The study was conducted in Santa Monica Institute, Poblacion 1, Mabini, Bohol. The school administration, librarian, borrowers were the respondents. The librarian will be the user of the proposed system. entropy Gathering Instruments.The researcher used two instruments, the self-made questionnaire and the evaluation tool. Self-made questionnaire is a draw and quarter used to interview the respondents to get information about the Library Circulation outline. This was constructed based on the present proceeding at Santa Monica Institute. The evaluation tool was employed to measure out the performance of the proposed system. This tool was secured from the internet and related books. The tool was modified and respond to the needs of user and tasked to rate the items using a five-point Likert scale.The questionnaire and evaluation tool are attached in ap pendix B and C. The researcher also used the context diagram, system flowchart, initial public offering (Input plow Output) and HIPO (hierarchical Input put to work Output) in designing the proposed software. These tools are necessary for the development of the system. Procedure The thesis writers interviewed the librarian to have an idea, information and other important details about the flow of operation in the library. Statistical Treatment To ascertain the take aim of acceptability of the system in library cataloging this formula was used?fx N ?fx N Weighted mean, X = where f = frequency x = weight N = reckon of responses The Likert-type scale was used for scaling the acceptability level of the system software. Scale Range Categorical solvent translation 5 4. 20-5. 00 Strongly shamable The system exceeds expectations and outstandingly performs the job requirements or 100% acceptable. 4 3. 40-4. 19 Moderately Acceptable The system extremely fulfills the job requiremen ts or 80% acceptable. 3 2. 60-3. 39 Acceptable The system take cares the job requirements or 60% acceptable. 2 1. 80-2.59 Slightly Acceptable The system slightly meets the job requirements or 40% acceptable. 1 1. 00-1. 79 Not Acceptable The system fails to meet the job requirements or 20% acceptable. DEFINITION OF toll Automated library circulation system. It is a system that involves systematic storing of information which takes the book, borrowers and generating reports. Borrowers. Library users can be student or a teacher who can lend books which is brought at home/ classroom. Circulation system. It is the process of circulating of library materials which includes borrowing and returning of library materials.Context diagram. It is used by the thesis writers to scope the project as it provides a visual model of the interactions between the system and the outside entities that interface with the solutions . info flow diagram. It shows the part of the system which includes the same process but universe automated. It is involved in converting data to generate reports. HIPO. Hierarchical Input- cover-Output a high-level view of the functions performed by a system as its functions and software implementation. IPO. Input Process Output these are the components or elements that make-up the system.It is also described as tools on the design of the finished software. Library. A room or building where a collection of books, periodicals, etc. , are kept for reading or reference, or public or private institution in-charge of the care and circulation of such collection. Library materials. social function in this study in order to include books of various kinds, periodicals, newspapers, magazines, vertical files consisting of clippings, pamphlets and the audio-visual materials which include maps, globes, charts and pictures. Library system. It is a systematic way of placing books, journals, magazines and others that would provide the need of the users. dodge F lowchart. It is formalized graphic representation of a program logic sequence, work or manufacturing processes, organizing chart or similar formalized structsure. Chapter 2 PRESENTATION, ANALYSIS AND variation OF DATA A. Present System System annals savants/teachers inquired the librarian on borrowing and returning of books. If the students wanted to borrow, they were required to have their library card and score in the f older. For the teachers they were simply required to give their ID card and pass it to the librarian.After receiving, the librarian gave the book card to the students / teachers and filled-up the information needed in borrowing the book and gave it back to the librarian before the book was given over to the borrower. Borrowed book was returned before the due date. Upon returning it, the librarian gave the identification card of the borrower. If the book returned late, penalisation was imposed. If cases of bewildered book, the borrower was required to pay t he exact amount of the book or replaced the book either. Generating report was done afterwards the inventory. It is done twice a year, before the school year starts and school year ends.* Borrowed platter * Library computer menu * Borrowers reading Librarian cusp Borrower * Reports Administration * Borrowed record * Library visiting card * Borrowers data Librarian Folder Borrower * Reports Administration account 1. 0 Conceptual Diagram Event Specifications 1. school-age child/ instructor make interrogative. bookman/ instructor 1. 0 overlay interrogative take for nurture * resolution * doubt student/Teacher 1. 0 travelling bag doubt take for schooling * solvent * Inquiry Borrower Borrower 2. schoolchild/ Teacher borrows book. 2. 0 sell borrow Borrowers Student / Teacher Student recruit bear Information * poke defend.* Library note * apply Card * account book entitle * Borrowers ID 2. 0 adhesive friction get Borrowers Student / Teacher Student Rec ord go for Information * Release control * Library Card * watchword Card * criminal record Title * Borrowers ID 3. Borrower returns book. Borrowers Book Information * Borrowed Book * Borrowers ID * penalisation Details Borrower 3. 0 Handle giveing Student Record Borrowers Book Information * Borrowed Book * Borrowers ID * penalization Details Borrower 3. 0 Handle Returning Student Record 4. Librarian generates reports. Borrowers Student Record Administration 6. 0 Handle Report Book Information.* Reports Borrowers Student Record Administration 6. 0 Handle Report Book Information * Reports Findings / Constraints The librarian took time in giving response to the inquiry of the student/teacher because records were not unionized. To provide immediate response to the inquiry, data must(prenominal) be systematized. The student/teacher spent time in borrowing because the librarian got the problem in retrieving the records of available books, because some books were lost and not prop erly returned. To minimize the time consume in borrowing, all records must be automated for quick access.They had the same problem encountered in returning the books because the librarian found it terrible in retrieving the students records. To provide fast process in returning, the records of the borrower must be computerized for quick access. The librarian has hold up in submitting reports. To generate early reports, the data must be systematized. Flowchart F T of import fare Input users mention Input countersignature If legitimate X F T briny Menu Input drug users fall upon Input Password If Valid X Begin Begin access enter-in X X flourish Message bring out Message Main Menu Main Menu show Main class presentment Main covert A A drug user mete out sacking. drug user spot vent substance abuser take aim dismission user hire add T T dealing Transaction If proceedings If Transactions F F T T If Records If Records Records Records F F T T If Reports If Repo rts Reports Reports F F T T If public utility company If Utility Utility Utility F F T T If System drug user If System User System User System User F F T T If well-nigh If About About About F F A A Transactions Transactions debunk Transaction book binding Display Transaction screen Display Transaction Screen Display Transaction Screen B B User subscribe Button User lead Button If Borrow If Borrow T T Borrow Borrow F F T T Return Return If Return If Return F F.B B Records Records Display Records Screen Display Records Screen Display Records Screen Display Records Screen C C User Select Button User Select Button User Select Button User Select Button T T If Books If Books Books Books Books Books If Books If Books F F O O O O If rise to power If increase Accession Accession If Accession If Accession T T F F If Borrowers If Borrowers T T Borrowers Borrowers If Borrowers If Borrowers F F T T If Book penalization If Book Penalty Book Penalty Book Penalty If Book Penalty If Book Pe nalty F F T T If side And compartmentalisation If Placement And salmagundi Placement and Classification.Placement and Classification If Placement and Classification If Placement and Classification F F If Borrowers Penalty If Borrowers Penalty T T Borrower penalization Borrower penalty If Borrower penalty If Borrower penalty F F T T If get well advert If Master List Master List Master List Master List Master List F F C C Reports Reports Display Reports Screen Display Reports Screen Display Reports Screen Display Reports Screen D D User Select Button User Select Button User Select Button User Select Button T T If Book Information If Book Information Book Information Book Information F F If Borrowers InformationIf Borrowers Information T T Borrowers Information Borrowers Information F F If crown Borrowers If Top Borrowers Top Borrowers Top Borrowers T T F F T T If imputable Books If cod Books Due Books Due Books F F If upset Books If befuddled Books T T Lost Books Lost Books F F D D Utility Utility Display Utility Screen Display Utility Screen E E User Select Button User Select Button If clientele and construct entropybase If Backup and Restore selective informationbase T T Backup and Restore Database Backup and Restore Database F F T T If Clean Database If Clean Database Clean Database Clean Database F F E E System User System User Display System Screen.Display System Screen F F User Select Button User Select Button T T If User poster If User Account User Account User Account F F L L L L F F T T If change over User If Switch User Switch User Switch User F F T T If Log Off If Log Off Log off Log off If Lock If Lock F F If deviation If spend T T Exit Exit If Exit If Exit F F F F About About Display System Screen Display System Screen H H Display System Screen Display System Screen User Select Button User Select Button User Select Button User Select Button If dissertation Writers If thesis Writers T T Thesis Writers Thesis Writers If Researcher If Researcher F F H H B. Proposed System.System Rules Library Circulation policy is to organize both book records and borrowers information and keep track for easy and quick access. This is encrypted with password and except the authorized person is allowed to access for the safety of the information. few library materials such as pamphlets, magazine and CDs are also included in the process. These materials are insert in the system with the title and corresponding price of admission figure of speechs, and it is sorted whenever it is needed. Borrowers are only allowed to borrow common chord (3) books per day for overnight and over week end and have duration of three (3) days. overnight books are to be taken from 430 to 500 pm. and to be returned at 715-730 on the following day. The over spend books are to be taken from the library on the Friday afternoon from 430-500 pm. , and to be returned at 715-730 on Monday morning. If the student exceed the given due date, penalty will be i mposed. It will be calculated and will be salaried. The payment of the penalty is done at the cashier and only official receipt is needed that is being input on the system. Context Diagram 0 Santa Monica Institute Library Circulation System Borrower Administration * Reports * Response.* Released Book * Penalty * acknowledge * Inquiry * Library Card * Book Title * Book Card * Borrowed Book * credit Card 0 Santa Monica Institute Library Circulation System Borrower Administration * Reports * Response * Released Book * Penalty * Receipt * Inquiry * Library Card * Book Title * Book Card * Borrowed Book * Identification Card Event List 1. Borrower makes inquiry. 2. Borrower borrows book. 3. Borrower returns book. 4. Librarian generates report. Event Specifications 1. Student/ Teacher make inquiry. 1. 0 Handle Inquiry Student/Teacher Book Information * Response * Inquiry 1. 0Handle Inquiry Student/Teacher Book Information * Response * Inquiry Borrower Borrower 2. Student / Teacher borr ows book. 2. 0 Handle Borrowing Borrowers Student / Teacher Student Record Book Information * Release Book * Library Card * Book Card * Book Title * Borrowers ID 2. 0 Handle Borrowing Borrowers Student / Teacher Student Record Book Information * Release Book * Library Card * Book Card * Book Title * Borrowers ID 3. Borrower returns book. Borrowers Book Information * Borrowed Book * Borrowers ID * Penalty Details Borrower 3. 0 Handle Returning Student Record Borrowers Book Information.* Borrowed Book * Borrowers ID * Penalty Details Borrower 3. 0 Handle Returning Student Record 4. Librarian generates reports. Borrowers Student Record Administration 6. 0 Handle Report Book Information * Reports Borrowers Student Record Administration 6. 0 Handle Report Book Information * Reports Process Specification Process 1. 0 Student/ Teacher makes Inquiry Begin If student / teacher make inquiry Accept inquiry If inquiry about available book Open available book cerebrate list of available book Cl ose available book Else if inquiry about registration Open book cast form.Input borrowers ID, borrowers Full name, Address, cubicle matter, age, gender, borrowers type, year level and section. Register borrower barricade if End Process 2. 0 Student/ Teacher borrow book. Begin If borrower borrow book Accept borrowing If borrower is new Register borrower Open borrowers configuration form Input borrowers ID, borrowers name, address, carrel number, age, gender, borrowers type year level and section Close borrowers configuration form Else if borrower is old Open book issue form Retrieve borrowers ID, borrowers name, book info, accession no, ISBN, book title, date issued, due date and purpose.Close book issue form End if End Process 3. 0 Borrower returns book. Begin Do piece borrowers return book Open return form Input borrowers ID Retrieve borrowers ID, borrowers name, accession no, ISBN, book title, date issued, due date, date returned and penalty Close return form End Process 4. 0 Librarian generates report. Begin Do while librarian receive scroll Accept memorandum Retrieve list of books Generate repots of list of book If reports report about books Open inventory report Retrieve total number of books, damage. Lost scrape report Close book report Else if reports about other library materials.Open other library materials Retrieved number of copies lost and damage Close library materials End if End Database Design It is a advance plan of software, where the collection of related data is organized for convenient access with the use of computer. Accession contains the number of copies of the certain book. Fieldname Data sign width definition Fieldname Data Type comprehensiveness explanation ID Autonumber long whole number ID number of the user Acession_no textual matter 30 digit of the copy of the book Copies text mutant 80 keep down of copies ISBN schoolbook 30 International standardised book number project_received text edition 50 int erpret received.Borrowers_ encompassingn-ame school text 50 Borrowers full name Status school text 10 Lost / Returned Account contains the username and password of the user. Fieldname Data Type Width interpretation Fieldname Data Type Width exposition User_ID consider vast integer ID number of the user User_ plant text 20 be of the user Complete_ form Text 30 Complete name of the user Password Text 10 Password of the user Account_Type Text 20 Limited/ administrator User_Account Yes/No 20 Limited/ administrator Log Yes/No 20 Log Borrow Yes/No 20 Borrow Return Yes/No 20 Return Book Yes/No 20 Book.Stat Yes/No 20 Status Placement Yes/No 20 Features formatting Yes/No 20 Features Borrowers Yes/No 20 Features of borrower Up_penalty Yes/No 20 Penalty Book_r Yes/No 20 Book Return_r Yes/No 20 involution returned go out_due Yes/No 20 Due date armory_r Yes/No 20 Inventory reports Catalog_r Yes/No 20 Catalog Backup Yes/No 20 Back up files Account_log contains the time in and ou t of the user. Fieldname Data Type Width exposition Fieldname Data Type Width translation Log_ID topic dour integer ID number of the user User_ID Text 10 ID number of the user.Timer_login Text 20 Time log in Timer_logout Text 20 Time log out Dte Text 30 realise Remarks Text 10 Remarks Book contains the information of the book. Fieldname Data Type Width Description Fieldname Data Type Width Description ID Number yen integer ID number of the user ISBN Text 30 Unique no of the book Book_Title Text two hundred Title of book some other_title Text cc submarine sandwich title of the book Other_physical Text 200 Other Physical details Author1 Text 50 Name of the 1st author Author2 Text 50 Name of the 2nd author Author3 Text 50 Name of the 3rd author.Notes Text 100 Notes publishing house Text 255 Name of the publisher Place_publication Text 200 Place of publication Placement_code Text 20 Placement code Book_no Text 10 Number of the book Author_no Text 200 Author number m usical theme1 Text 255 Subject Subject2 Text 255 Subject Subject3 Text 255 Subject Format Text 20 Book sort Edition Text 200 Number of edition Copyright_year Text 10 Copyright year Date_received Date/ Time cosmopolitan date Date received Source Text 15 Donated/ purchased Pages Text 5 Number of pages Amount Number dour integer Amount of the bookTotal_copies Number big integer Total number of copies Book_borrowed contains the book borrowed by the borrower. Fieldname Data Type Width Description Fieldname Data Type Width Description ID Autonumber Long integer User Id Borrowers_Id Text 10 Borrowers ID Borrowers_Name Text 30 Borrowers name Accession_no Text 10 Number of copies of the book Copies Text 10 Number of copies ISBN Text 20 International standard book number Book_Title Text 200 Title of the book Date_Issued Date/ time General date Date issued Date_Due Date/ time General date Due date.Date_Returned Date/ time General date Date returned Time_Due Date/ time General dateDue time Purpose Text 15 Overnight/ over weekend Penalty Text 15 Paid/ unpaid Status Text 15 In/ out Remarks Text 10 Returned/ unreturned Borrowers_info contains borrowers personal information. Fieldname Data Type Width Description Fieldname Data Type Width Description ID Autonumber Long integer User ID Borrowers_ID Text 30 Borrowers ID Complete_Name Text 100 Borrowers Full Name Gender Text 20 Gender years Text 10 Age of the borrower Address Text 80 Address of the borrower. kiosk_Number Text 20 Cell number Type Text 20 Student/ teacher Year_level Text 50 Year level Section Text 30 Section No_borrowed Number Long integer No of book borrowed Total_borrowed Number Long integer Total no of book borrowed Event_list contains of all the event done by the librarian on the system. Fieldname Data Type Width Description Fieldname Data Type Width Description ID Autonumber Long integer Number of data User_ID Number Long integer User ID Event Text 40 Event Event_date Date/ time General da te Event time Event_time Date/ time General date Event date.Format classification of the book. Fieldname Data Type Width Description Fieldname Data Type Width Description ID Autonumber Long integer Number of data Format Text 200 Classification of book Inventory actual find out of all library materials. Fieldname Data Type Width Description Fieldname Data Type Width Description ID Autonumber Long integer User ID ISBN Text 50 International standard book number Total_copies Text 10 Total copies Copies_on_hand Text 10 Copies on hand Copies_borrowed Text 10 Copies borrowed Copies_lost Text 10 Copies lost.Penalty contains to the amount to be paid by the user. Fieldname Data Type Width Description Fieldname Data Type Width Description ID Autonumber Long integer User ID Format Text 200 Overnight/ over weekend First_hour Text 10 Penalty for first hour Next_hour Text 10 Penalty for the next hour First_day Text 10 Penalty for the first day Next_day Text 10 Penalty for the nex t day Days_limit_for_borrow Text 10 Days limit Placement contains the code that is being replace. Fieldname Data Type Width Description Fieldname Data Type Width Description ID.