Library Systemconclusion Essay
Library is a topographic point where people focus their attending in reading and doing research which can assist everyone additions knowledge. It is organized and maintained for the usage of public organic structure. establishment. corporation. or private person. The school library provides chances for the persons with the focal point on the rational content and information literacy to the scholar. It contains books and other mention stuffs made available to the users for reading. analyzing and acquiring mentions.
The books and mention stuffs are arranged on shelves harmonizing to the categorization system used for the convenience of the users. Puting similar stuffs in one location helps the users find multiple points on a given topic more expeditiously than those some points scattered within the library. The coevals of computing machine age can be really utile in bridging the demand for library services and ability to supply these services. Deciding the most effectual plan for set uping an automated circulation system is a undertaking that confronts librarian today.
There are major library jobs experienced around the universe. Aside from Philippines. India and other states libraries suffer from deficiency of proper library installations and confronting the job of hapless services. and most significantly unorganised circulation system and procedure of recovering informations is non efficient. Local libraries besides faced several jobs these are deficiency of fiscal resources and high cost of computing machine accoutrements has reduced the tendencies in the acceptance of automated library system in school libraries while such has limited entree to a assortment of information on stored informations.
The thesis authors observed that the procedure of asking books and recovering the borrowed and returned book were done manually in Santa Monica Institute. In this. the borrower spent more clip in every procedure of go arounding books in Santa Monica Institute. Thus. the thesis authors were interested to plan and to develop the Automated Library Circulation System of Santa Monica Institute – Mabini library to better its operation in order to supply effectual services. Literature Background The development of engineering has doubtless increased the assortment of resources available in libraries today.
It is particularly fueling increased user demands and outlooks for information resources and their timely bringing. The impact of the altering engineering helps in planing library mechanization. A. G. Nkhoma-Wamunza stated that “library mechanization is a procedure which involves associating computing machines electronically within and outside the establishment. come ining library resources in a database to make an Open Access Catalogue. which allows users to entree and recover information in a timely mode.
” It gained broad credence globally due to its many benefits potencies including improved public presentation efficiency and bringing of quality service in library. Library Circulation is one of those subdivisions of the library that needs mechanization. It comprises the activities around the loaning of library books and other stuffs to users of a loaning library. It provides loaning services and installations for return of loaned points. Renewal of stuffs and payment of mulcts are besides handled at the circulation desk.
Circulation staff may supply basic hunt and mention services. though more in-depth inquiries are normally referred to cite bibliothecs. Librarian is a individual who works professionally in a library. and is normally trained in librarianship and experts of happening. forming and construing information needed. They are the defenders of stuffs inside the library. The mention desk of the library is a public in service counter where professional bibliothecs provide way to the stuffs. advice on the
aggregations and services. and expertness on the multiple sorts of information from multiple beginnings to the library users. Library user is the borrower of the library stuffs which can be brought at place / schoolroom. It can be a pupil. instructor. frequenter and even outsider who are greatly benefited on the proposed system. School disposal is an of import portion of our instruction system. Administrators face a assortment of issues on a day-to-day footing. Take a expression at schemes and techniques used to battle those issues.
The UP College of Science Library System located at Diliman. Quezon metropolis is one of the bing library system that uses online library system. It has many capablenesss it allows to see information about the library and its services. The system besides provides information about new rubrics. library hours and has link that will let user to reach the library through electronic mail. UP College Science is similar to the proposed system because it allows seeking of books and other library stuffs. The library system is implemented to supply user fast and speedy entree of information.
Automated Library System referred as a cost effectual and infinite salvaging alternate to common papers postponing engineerings. turn toing the demand for infinite efficiency. secure and automated papers and records managing. ALS is a design and package solution focused on the dependability and maintainability. The solution. developed by squad of experient industry professionals is supported by comprehensive services including on-site care. trim parts. modernisation. ascents and enlargements. HK has been put ining system using this engineering for the past 40 old ages.
Amyotrophic lateral sclerosiss have been installed at establishments throughout North America. Automated Library System for Navotas City Library ( 2010 ) . They have two computing machines in the library without automated library system. The Automated System for Navotas City Library is to ease the discoverer. loaning and returning of books in electronic. systematic and orderly manners. In add-on. it aims to get by with the tendencies of engineering today for the library and to the library and to hold a system that will pull more users.
to the library. hence. grasp on the library can lend it to the information needed by the pupils. workers. and research workers particularly to the people of Navotas City. Bodiongan ( 2000 ) . The research worker found that the procedure of recovering informations and information are non efficient. So the borrower takes clip in happening information because the stuffs are non decently returned to the right agreement. The procedure of recovering and maintaining records of the borrowers is clip devouring due to low quality of the borrower’s card.
The library has a immense aggregation of books so the borrower takes clip in screening information from the card catalogue. The library helper takes clip in seeking the borrower’s records because there are some cases that some of the borrower’s card are non decently returned. Curan ( 2011 ) . In her survey. the research worker observed that the procedure of asking books and recovering the borrowed and returned book were done manually. In this. the borrower spent more clip in every procedure of go arounding books. The research worker conclude that the system has great aid in minimising the clip consume in adoption and recovering informations.
The system provides accurate and unafraid maintaining of informations. and can bring forth study instantly. Code of moralss of Library Association adopted at the 1939 Midwinter Meeting by the ALA Council ; amended June 30. 1981 ; June 28. 1995 ; and January 22. 2008 provinces that “we protect each library user’s right to privateness and confidentiality with regard to information sought or received and resources consulted. borrowed. acquired or transmitted. ” Privacy is indispensable to the exercising of free address. free idea. and free association.
Identifiable information about users is confidential and the library supports that information private and confidential on their behalf. This policy is intended to forestall the unauthorised usage of our patrons’ personal information. and to protect the privateness of this information. Librarians are responsible for maintaining the information’s security needed for the mention of the user and supply better service to the borrowers. Section 10 Article XIV of the 1987 Constitution mandates that: Science and engineering are indispensable for national development and advancement.
The province shall give precedence to research and development. innovation. invention. and their use ; and to science and engineering instruction. preparation and services. It shall back up autochthonal. appropriate and self- reliant scientific and technological capablenesss. and their application to the country’s productive system and national life. Technology plays great function for the betterment of an establishment. The uninterrupted growing of engineering leads to many innovations for the betterment of the establishment one of this is the Santa Monica Institute. Technology aid supply system that would supply user better service in this establishments.
Section 12. Article XIV of the 1987 Constitution authorizations stated: The province shall modulate the transportation and advance the version of engineering from all beginnings for the national benefit. It shall promote the widest engagement of private groups. local authoritiess and community-based organisations in the coevals and use of scientific discipline and engineering. Through the usage of engineering. it can assist the establishment to better procedure with the usage of the proposed system that involves private groups to indentify the characteristics that needs betterment to supply better service.
Section 13. Republic Act 8293 authorizations stated: The province shall protect and procure the sole rights of scientists. discoverers. creative persons. and other gifted citizens to their rational belongings and creative activities. peculiarly when good to the people. for such period as may be provided by jurisprudence. This states that the research workers should protect the right to support the survey and portability of informations. In this survey. the research workers should protect and procure the proposed system with the usage of watchword to avoid the change of information. THE PROBLEM Statement of the Problem.
The chief intent of the survey is to plan and developed Santa Monica Institute Library Circulation System that would function as a proposal to minimise clip in seeking books and generate dependable and accurate studies. Specifically. the survey answers the undermentioned inquiries: 1. What are the characteristics of the system that needs betterment? 2. To what extent of the public presentation of the proposed system in footings of 3. 1 Security ; 3. 2 Human Interface ; 3. 3 Requirements ; and 3. 4 Performance/ Reliability. Significance of the survey The survey would be good to the followers: School Administration.
This survey could be used as footing in implementing library betterment and development. Librarian. It enables her to react to the borrower’s petition instantly. Borrowers. They are greatly benefitted because they can acquire immediate response on their petitions. Future Researchers. This survey enhances the capableness in doing the system. It gives kernel on how cybernation truly helps on developing one’s establishment and on how library system operates. RESEARCH METHODOLOGY Design The research worker used the Descriptive Survey and Experimental method with the usage of a self-made questionnaire and package rating tool.
The descriptive study or questionnaire was used to find the jobs encountered by the librarian and library users. and the characteristics of the bing system that needs betterment. The experimental method or the rating tool was used to determine the acceptableness degree of machine-controlled system. Environment and Participants The survey was conducted in Santa Monica Institute. Poblacion 1. Mabini. Bohol. The school disposal. librarian. borrowers were the respondents. The librarian will be the user of the proposed system. Data Gathering Instruments.
The research worker used two instruments. the self-made questionnaire and the rating tool. Self-made questionnaire is a usher used to interview the respondents to acquire information about the Library Circulation System. This was constructed based on the present minutess at Santa Monica Institute. The rating tool was employed to measure the public presentation of the proposed system. This tool was secured from the cyberspace and related books. The tool was modified and react to the demands of user and tasked to rate the points utilizing a five-point Likert graduated table.
The questionnaire and rating tool are attached in appendix B and C. The research worker besides used the context diagram. system flow chart. IPO ( Input Process Output ) and HIPO ( Hierarchical Input – Process – Output ) in planing the proposed package. These tools are necessary for the development of the system. Procedure The thesis authors interviewed the librarian to hold an thought. information and other of import inside informations about the flow of operation in the library. Statistical Treatment To determine the degree of acceptableness of the system in library cataloging this expression was used:
? fx N? fx N Weighted mean. X = where: degree Fahrenheit = frequence x = weight N = figure of responses The Likert-type graduated table was used for scaling the acceptableness degree of the system package. Scale| Range| Categorical Response| Description| 5| 4. 20-5. 00| Strongly Acceptable| The system exceeds outlooks and outstandingly performs the occupation demands or 100 % acceptable. | 4| 3. 40-4. 19| Reasonably Acceptable| The system extremely fulfills the occupation demands or 80 % acceptable. | 3| 2. 60-3. 39| Acceptable | The system meets the occupation demands or 60 % acceptable. | 2| 1. 80-2.
59| Slightly Acceptable| The system somewhat meets the occupation demands or 40 % acceptable. | 1| 1. 00-1. 79| Not Acceptable| The system fails to run into the occupation demands or 20 % acceptable. | DEFINITION OF TERMS Automated library circulation system. It is a system that involves systematic storing of information which includes the book. borrowers and bring forthing studies. Borrowers. Library users can be pupil or a instructor who can impart books which is brought at home/ schoolroom. Circulation system. It is the procedure of circulating of library stuffs which includes adoption and returning of library stuffs.
Context diagram. It is used by the thesis authors to scope the undertaking as it provides a ocular theoretical account of the interactions between the system and the outside entities that interface with the solutions. Data flow diagram. It shows the portion of the system which includes the same procedure but being automated. It is involved in change overing informations to bring forth studies. HIPO. Hierarchical Input-Process-Output a high-ranking position of the maps performed by a system as its maps and package execution. IPO. Input Process Output these are the constituents or elements that make-up the system.
It is besides described as tools on the design of the full package. Library. A room or edifice where a aggregation of books. periodicals. etc. . are kept for reading or mention. or public or private establishment in-charge of the attention and circulation of such aggregation. Library stuffs. Use in this survey in order to include books of assorted sorts. periodicals. newspapers. magazines. perpendicular files dwelling of cuttings. booklets and the audio-visual stuffs which include maps. Earths. charts and images. Library system. It is a systematic manner of puting books. diaries. magazines and others that would supply the demand of the users.
System Flowchart. It is formalized in writing representation of a plan logic sequence. work or fabrication procedures. forming chart or similar formalistic structsure. Chapter 2 PRESENTATION. ANALYSIS AND INTERPRETATION OF DATA A. Present System System Narrative Students/teachers inquired the bibliothec on adoption and returning of books. If the pupils wanted to borrow. they were required to hold their library card and topographic point in the booklet. For the instructors they were merely required to give their ID card and base on balls it to the bibliothec.
After having. the librarian gave the book card to the pupils / instructors and filled-up the information needed in borrowing the book and gave it back to the librarian before the book was given to the borrower. Borrowed book was returned before the due day of the month. Upon returning it. the librarian gave the designation card of the borrower. If the book returned late. punishment was imposed. If instances of lost book. the borrower was required to pay the exact sum of the book or replaced the book either. Generating study was done after the stock list. It is done twice a twelvemonth. before the school twelvemonth starts and school twelvemonth ends.
* Borrowed Book * Library Card * Borrower’s Information Librarian Folder Borrower * Reports Administration * Borrowed Book * Library Card * Borrower’s Information Librarian Folder Borrower * Reports Administration Figure 1. 0 Conceptual Diagram Event Specifications 1. Student/ Teacher make enquiry. Student/Teacher 1. 0 Handle Inquiry Book Information * Response * Inquiry Student/Teacher 1. 0 Handle Inquiry Book Information * Response * Inquiry Borrower Borrower 2. Student/ Teacher borrows book. 2. 0 Handle Borrowing Borrowers Student / Teacher Student Record Book Information * Release Book.
* Library Card * Book Card * Book Title * Borrower’s ID 2. 0 Handle Borrowing Borrowers Student / Teacher Student Record Book Information * Release Book * Library Card * Book Card * Book Title * Borrower’s ID 3. Borrower returns book. Borrowers Book Information * Borrowed Book * Borrower’s ID * Penalty Details Borrower 3. 0 Handle Returning Student Record Borrowers Book Information * Borrowed Book * Borrower’s ID * Penalty Details Borrower 3. 0 Handle Returning Student Record 4. Librarian generates studies. 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 clip in giving response to the enquiry of the student/teacher because records were non organized. To supply immediate response to the enquiry. informations must be systematized. The student/teacher spent clip in adoption because the librarian got the job in recovering the records of available books. because some books were lost and non decently returned. To minimise the clip consume in borrowing. all records must be automated for speedy entree.
They had the same job encountered in returning the books because the librarian found it difficult in recovering the students’ records. To supply fast procedure in returning. the records of the borrower must be computerized for speedy entree. The bibliothec has delayed in subjecting studies. To bring forth early studies. the information must be systematized. Flowchart F T Main Menu Input User’s Name Input Password If Valid X F T Main Menu Input User’s Name Input Password If Valid X Begin Begin Log-in Log-in X X Display Message Display Message Main Menu Main Menu Display Main Screen Display Main Screen A A User Select Button.
User Select Button User Select Button User Select Button T T Transaction Transaction If Transactions If Transactions F F T T If Records If Records Records Records F F T T If Reports If Reports Reports Reports F F T T If Utility If Utility Utility Utility F F T T If System User If System User System User System User F F T T If Approximately If About About About F F A A Transactions Transactions Display Transaction Screen Display Transaction Screen Display Transaction Screen Display Transaction Screen B B User Select Button User Select 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 Accession If Accession 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 Penalty If Book Penalty Book Penalty Book Penalty If Book Penalty If Book Penalty F F T T If Placement And Classification If Placement And Classification 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 punishment Borrower punishment If Borrower punishment If Borrower punishment F F T T If Master List 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 Information
If Borrowers Information T T Borrowers Information Borrowers Information F F If Top Borrowers If Top Borrowers Top Borrowers Top Borrowers T T F F T T If Due Books If Due Books Due Books Due Books F F If Lost Books If Lost 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 Backup and Restore Database If Backup and Restore Database 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 Account If User Account User Account User Account F F L L L L F F T T If Switch 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 Exit If Exit 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 Thesis 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 form both book records and borrower‘s information and maintain path for easy and speedy entree. This is encrypted with watchword and merely the authorised individual is allowed to entree for the safety of the information. Some library stuffs such as booklets. magazine and CD’s are besides included in the procedure. These stuffs are input in the system with the rubric and matching accession Numberss. and it is sorted whenever it is needed. Borrowers are merely allowed to borrow three ( 3 ) books per twenty-four hours for nightlong and over hebdomad terminal and have continuance of three ( 3 ) yearss.
Overnight books are to be taken from 4:30 to 5:00 autopsy. and to be returned at 7:15-7:30 on the undermentioned twenty-four hours. The over weekend books are to be taken from the library on the Friday afternoon from 4:30-5:00 autopsy. . and to be returned at 7:15-7:30 on Monday forenoon. If the pupil exceed the given due day of the month. punishment will be imposed. It will be calculated and will be paid. The payment of the punishment is done at the teller and merely official reception 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 * Receipt * Inquiry * Library Card * Book Title * Book Card * Borrowed Book * Identification 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 enquiry. 2. Borrower borrows book. 3. Borrower returns book. 4. Librarian generates study. Event Specifications 1. Student/ Teacher make enquiry. 1. 0 Handle Inquiry Student/Teacher Book Information * Response * Inquiry 1. 0
Handle Inquiry Student/Teacher Book Information * Response * Inquiry Borrower Borrower 2. Student / Teacher borrows book. 2. 0 Handle Borrowing Borrowers Student / Teacher Student Record Book Information * Release Book * Library Card * Book Card * Book Title * Borrower’s ID 2. 0 Handle Borrowing Borrowers Student / Teacher Student Record Book Information * Release Book * Library Card * Book Card * Book Title * Borrower’s ID 3. Borrower returns book. Borrowers Book Information * Borrowed Book * Borrower’s ID * Penalty Details Borrower 3. 0 Handle Returning Student Record Borrowers Book Information.
* Borrowed Book * Borrower’s ID * Penalty Details Borrower 3. 0 Handle Returning Student Record 4. Librarian generates studies. 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 pupil / teacher do enquiry Accept enquiry If enquiry about available book Open available book Retrieve list of available book Close available book Else if enquiry about enrollment Open book constellation signifier.
Input borrower’s ID. borrower’s Full name. Address. cell figure. age. gender. borrower’s type. twelvemonth degree and subdivision. Register borrower End if End Process 2. 0 Student/ Teacher borrow book. Get down If borrower borrow book Accept adoption If borrower is new Register borrower Open borrower’s constellation signifier Input borrower’s ID. borrowers name. reference. cell figure. age. gender. borrower’s type twelvemonth degree and subdivision Close borrower’s constellation signifier Else if borrower is old Open book issue signifier Retrieve borrower’s ID. borrower’s name. book info. accession no. ISBN. book rubric. day of the month issued. due day of the month and intent.
Close book issue form End if End Process 3. 0 Borrower returns book. Get down Do while borrower’s return book Open return signifier Input borrower’s ID Retrieve borrower’s ID. borrowers name. accession no. ISBN. book rubric. day of the month issued. due day of the month. day of the month returned and punishment Close return signifier End Process 4. 0 Librarian generates study. Get down Do while librarian receive memoranda Accept memoranda Retrieve list of books Generate repots of list of book If studies study about books Open stock list study Retrieve entire figure of books. harm. Lost Print study Close book study Else if studies about other library stuffs.
Open other library stuffs Retrieved figure of transcripts lost and harm Close library stuffs End if End Database Design It is a preliminary program of package. where the aggregation of related informations is organized for convenient entree with the usage of computing machine. Accession – contains the figure of transcripts of the certain book. Fieldname Data Type Width Description Fieldname Data Type Width Description | | | | ID| Autonumber| Long integer| ID figure of the user| Acession_no| Text| 30| Number of the transcript of the book| Copies| Text| 80| Number of copies| ISBN| Text| 30| International Standard book number| Date_received| Text| 50| Date received| .
Borrowers_fulln-ame| Text| 50| Borrower’s full name| Status| Text| 10| Lost / Returned| Account – contains the username and watchword of the user. Fieldname Data Type Width Description Fieldname Data Type Width Description | | | | User_ID| Number| Long integer| ID figure of the user| User_Name| Text| 20| Name of the user| Complete_Name| 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| Format| 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| Date returned| Date_due| Yes/No| 20| Due date| Inventory_r| Yes/No| 20| Inventory reports| Catalog_r| Yes/No| 20| Catalog | Backup| Yes/No| 20| Back up files| Account_log – contains the clip in and out of the user. Fieldname Data Type Width Description Fieldname Data Type Width Description | | | | Log_ID| Number| Long integer| ID figure of the user| User_ID| Text| 10| ID figure of the user| .
Timer_login| Text| 20| Time log in | Timer_logout| Text| 20| Time log out| Dte| Text| 30| Date| Remarks| Text| 10| Remarks| Book – contains the information of the book. Fieldname Data Type Width Description Fieldname Data Type Width Description | | | | ID| Number| Long integer| ID figure of the user| ISBN| Text| 30| Unique no of the book| Book_Title| Text| 200| Title of book| Other_title| Text| 200| Sub rubric 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| Publisher| 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| Subject1| Text| 255| Subject| Subject2| Text| 255| Subject| Subject3| Text| 255| Subject| Format| Text| 20| Book classification| Edition| Text| 200| Number of edition| Copyright_year| Text| 10| Copyright year| Date_received| Date/ Time| General date| Date received| Source| Text| 15| Donated/ purchased| Pages| Text| 5| Number of pages| Amount| Number| Long integer| Amount of the book|
Total_copies| Number| Long integer| Total figure 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| Borrower’s ID| Borrowers_Name| Text| 30| Borrower’s name| Accession_no| Text| 10| Number of transcripts 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 date|Due 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 borrower’s personal information. Fieldname Data Type Width Description Fieldname Data Type Width Description | | | | ID| Autonumber| Long integer| User ID| Borrowers_ID| Text| 30| Borrower’s ID| Complete_Name| Text| 100| Borrower’s Full Name| Gender| Text| 20| Gender| Age| Text| 10| Age of the borrower| Address| Text| 80| Address of the borrower| .
Cell_Number| Text| 20| Cell figure | 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 bibliothec 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 date| Event clip | Event_time| Date/ time| General date| Event date| .
Format – categorization 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 – existent numeration of all library stuffs. 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| .
Punishment – contains to the sum 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 hr | Next_hour| Text| 10| Punishment for the following hour| First_day| Text| 10| Punishment for the first day| Next_day| Text| 10| Punishment for the following day| Days_limit_for_borrow| Text| 10| Days limit| Placement – contains the codification that is being replace. Fieldname Data Type Width Description Fieldname Data Type Width Description | | | | ID| .