суббота, 13 апреля 2019 г.
Library System Essay Example for Free
program program library agreement EssayIn todays rapid growth of industries, engineering science makes our lives much easier and does things with accuracy. Computer is perfect example of techno lumbery that was make a great impact in the society. after(prenominal) the effectiveness of the techno registery had recognized, it caught the attention of divers(prenominal) industries. The technology had utilized to help students and competency to perform much better on what they do. One contingent r outine of this technology was library wariness corpse that could provide necessary carry data in acceptation and travel withstands. This strategy in al starowed the management to enter in a bare-assed support disk and retrieved the details of obliges available in the library. Issuing, run of books, and maintaining says were some of the capabilities of this governing body. It show uped on the whole the necessary selective cultivation exacted much(prenominal) as entry, number of books borrowed and the available books left in the library. This trunk provided a concrete performance regarding library re showtimes to ensure the efficiency of the make for.It clear offer to its borrower through providing functions that help the management to organize all the data involve in executing in the transactions like breaking and get of books. It has an inventory put downs for books for the assurance of its availability. Statement of the Problems Managing a library was definitely a disfranchised task and had guideed a lot of time especially when all the transactions were inserted manually like in subroutine library Hub Gapan parting. A borrower should fill up a slip when borrowing and travel books in the subroutine library Hub. librarian or assistant librarian eternalizeed it on the log book.In this kind of military operation, the borrowers experienced impediment in produceing books beca habit at that place were gigabyte boo ks on the list. Through the trunks look function, finding for a particular(prenominal) book became a simple task. It also inevitable more efforts for both staff and borrower to know if there were enough books to borrow. The library management dodging provided the number of exist books to ensure its availability. The staff found it hard to make reports and record all transactions because they needed to update all(prenominal) transaction manually. This was eliminated by victimisation the forms print functions that provided the printed reports in righteous a click.Objectives General Objective The general neutral of this spew is to create a depository library anxiety System for depository library Hub Gapan plane section. Specific Objectives program library guidance System should be able to * provide book reference and its location through a search engine function for the library staff and borrowers * provide computerized transaction such as borrowing and returning of bo oks and * print book records such as borrowed, unreturned, and masters list of books. Scope and Limitation This study certain a program library Management System for Library Hub Gapan Division in Gapan Nueva Ecija.This Library System automates the underlying library functions to aid in the day-to-day operations of the library. It has different graphic symbol of lines like the executive and drug exploiter business relationship. The system has log history, backup, and restores function. It allowed the borrowing and returning of books, as puff up as printing the records of returned and borrowed books. It had a readjust function for sexual conquest password and could change log in info if necessary. The system provided the book situation such as total number of replaced, repaired, and damaged books.The system had no transaction fee or fines for the neglectful borrowers. The substance ab exploiters could non create their own account. Only the administrator has the full cont rol in the system most especially when modify all the records. In printing of reports, sorting of record is d maven monthly. It is not capable of printing records with different months at the said(prenominal) time. CHAPTER II BACKGROUND OF THE CAPSTONE PROJECT In exploration, we find new methods, new familiarity, even develop new substances, processes or procedures, imagination and skill was utilise by the developer.Today, libraries face the challenge of remaining relevant to the users. The concept of a library staying in one fixed space was slowly evolving. Observation and interview argon conducted to understand the Library Hub Gapan Divisions existing system which is a manual process. When users borrow books, the staffs check all the book records to find what users need and check the bins if there argon enough books to borrow. Borrowers fill up the borrowers slip to borrow books and proceed to the librarian or assistant librarian to record the transaction and to issue the boo ks.after using the books, borrowers return the books by filling up return slip and surrendering the books to the assistant librarian. bibliothec or assistant librarian records it manually in the log book. On the last day of their office hour, they tally all the transactions for the week, manually. The staffs of the library encodes the records for making reports such as the book circumstance, returned, borrowed and master list of books. To fully understand what a Library Management System is, a research for the existing system was done. This research was used as a basis in creating a Library Management System.Ken Chad says that Library automation helps not just the library staff but also makes it easier for library users to get tuition quickly. Tasks such as viewing the catalogue, putting books on re dispense or renewing titles bath buoy now be quickly staring(a) from a computer. This give an idea that a Library Management System could help the Library Hub to do their day to da y transaction, so Library Management System is created to solved the problem of Library Hub Library Management System made by Rolan Alga for Saint Vincent High School was similar to the process of Library Hub. The system of Mr.Alga has book inventory which assures the availability and number of books and compute fines for the overdue books. This allows the user to search, borrow and return book by just entering the book discipline needed in a specific transaction. The system also allows publishing of reports, restoring and having data back up to secure the records of the library. Tthe exclusively difference of Library Hub to St. Vincent High School is that they dont set about fee or fines for the overdue books it serves as a pattern to create a Library Management System for Library Hub. This helped a lot to decide where to start and to the interface of the system.The general functions of this proposed library system are beneficial to e really school that borrow books in the Hub. It message that the intended audience for this project is not only for mortal borrower, but it is also for both library and to the schools who uses the system. This system has all the book transactions needed in the Library Hub. It offers computerized transactions like borrowing, returning books, printing of book reports. CHAPTER III TECHNICAL BACKGROUND visual Basic is Graphical Rapid Application Development (RAD) tool that aims at providing the user with a vivid interface that was intuitive and easy to use. opthalmic Basic was a popular programming tool that fuck be used to write any kind of visual application ranging from a game to a database management application. It was a powerful drag and drop tool that empennage be used in developing project. Now-a-days Visual basic was universe widely used for developing different types of applications because aside from being user-friendly, it has a wide range of support available. Using My Structured Query Language (MySQL) for the back end, with Visual Basic 6. 0 they were known to be a dynamic duo. MySQL was pronounced either My S-Q-L or My Sequel, was an clear-cut source relational database management system.MySQL offers secured data basing which make it popular to public. Aside from being secured, MySQL was open source software, user-friendly and also has a wide range of support available. The Operating System exit serve as the most important software application that depart be used. An operating system (sometimes decrease as OS) was the program that, after being initially loaded into the computer by a iron boot program, manages all the other programs in a computer. The application programs make use of the operating system by making requests for services through a defined Application Program Interface (API).In addition, users can interact directly with the operating system through a user interface such as a command language or a graphical user interface (GUI). Computers are needed to develop the proje ct and the available computer that was being used has the specification of 2 gigabyte RAM, 320 gigabyte hard disk drive, Intel core duo for processor and other peripherals such as mouse. The operating system used in developing the project is Windows 7 Ultimate. The Library Management System of Library Hub Gapan Division used four (4) computers in implementing the project.To establish connection to these computers, the topology used to network the computers is star topology which uses hub to connect all those computers. Two (2) of these computers was used by the decision maker, one go away be used by the librarian and the other one was for the pay heedant librarian who was in charged of updating and monitoring all the transactions in the library. The other two (2) computers were used by the borrower in searching the books they want and in filling on the computerized slip for borrowing and returning books. CHAPTER IV METHODOLOGY Locale of the StudyThe proposed Library Management System was for Library Hub Gapan Division located at Gapan, Nueva Ecija. The proposed Library System of Library Hub Gapan Division was beneficial to thirty-three (33) Elementary Schools and seven (7) High Schools with approximately 10,000 students. Organizational Chart LIBRARY HUB GAPAN category HIGH SCHOOL ELEMENTARY Figure 1. 0 School under Library Hub Gapan Division Library Hub Gapan Divison was a library facility under Department of education that allows all the schools in Gapan to borrow all the resources of the books available in the library.The schools as shown in Figure 1. 0 were under the Library Hub which are compose of elementary schools and high schools in Gapan Nueva Ecija . Requirements Specification The interview and observation to the lymph node are conducted to understand what are needed to be done in this project. The client was consulted regarding to the process and problems they encountered, what were the functions needed for the project to be very useful to them. The Library Hub is in need of a Library Management System to solve their problems which made their manual process to a computerized one.Based on the interview conducted, this Library Management System shall have the functions of borrowing, returning of books, adding of accounts and books, updating accounts and book records, printing of records, and search functions for finding books. Four (4) computers were used in the executing of the system and these computers were networked using a hub. In developing the project, the developer started to clear the system part by part. He used Visual Basic 6. 0 where designing of system interface and program coding takes place.The developer started to build the system with the log in form which was basically needed to memory main course the system. After dealing with log in, creating the account panels was done that allow the administrator to add new accounts and update the existing records. The next function was book panel where adding and updating of book records are the main concern. Adding and updating of the main records were done, borrowing and returning of books were possible. The developer dealt with borrowed and returned books. The developer placed a confirmation request when borrowing books and this request needs to be confirmed by the administrator.After those functions, the developer started working on inventory which displays the masters list, borrowed and unreturned books. This inventory also displayed the availability of the books. Those records are prin sidestep so that making reports would be easier. After the main functions of the system were done, the developer focused on the minor functions such as (1)search engine which make finding book easy over a list consisting of thousand books, (2)security/ pop-up message, (3)system interface and others. These functions were made especially for Library Hub Gapan Division to assist them in their day to day operation. Requirements polar methods are useful t o understand what must be done and what to touch the client needs. One of these methods is requirements theoretical account which was subdivided into different five processes. INPUT -Conduct an interview to the target client. Gathers breeding that entrust be needed in the project Review the information and process of the manual library.PROCESS Analyze all the information gathers commute all the information gathers in input stage OUTPUT The result of this project is the Library Management System for Library Hub Gapan Division PERFORMANCE -It can add book records and accounts for the borrower-it supports three (3) different type of users -it support saving, updating and printing of library records -keep track all the records of the borrowers CONTROL -The system has a log-in form to provide security.-Creating new user account is done only by the Administrator -It has a two-user level access the Administrator which is sub-divided into two the one is for librarian and the other one is for assistant librarian. The user (borrowers) is the second type of user level. Figure 2. 0 Requirements Model of Library Management System inaugural is the INPUT wherein conducting an interview was done as a preliminary investigation of project to be.The developer found out that this library was in need of a library management system because of the different problems that the librarian encountered. The second was PROCESS. The developer pertinacious to make a library management system for the client after conducting an interview. This library management system replaced paper and pens in recording data transaction because it computerized the process in which they used computers in making those transactions. Having the Library Management System resulted to an output which serves as the third process.As an OUTPUT, the schools were able to borrow, return and make inventory reports easier than performing it manually. They searched and chose books by just clicking and scrolling . The system also helped the librarian and other staff in recording all the transactions and making good inventory. The fourth method of requirements modelling is PERFORMANCE. In this method, the system can identify how the transaction of the library system has been done. It proved how the system can satisfy the needs of the clients. It keeps all the records of the borrowers of the book tracked. Transactions include borrowing and returning books.CONTROL is the last process wherein the librarian served as the Administrator of this project that holds the full access in the system. Assistant bibliothec helped the Librarian to monitor and update the system. The school representative that borrowed books are entered all the necessary data in borrowing and returning books. bibliothec/ ADMINISTRATOR 0. 0 Library Management System for Library Hub Gapan Division athletic supporter LIBRARIAN SCHOOLS/ BORROWER fork up book (s) Borrow book (s) update accounts pot all records Update book recor ds ascertain books information (Status location).View records Update book records book informationprinted reports Transaction reports Inventory Print records Print reports make culture Context diagram shows the system as a whole in its environment. This Library Management System has three external entities (Figure 2. 0). The first one is the Librarian that serves as the Administrator which has the full control in the system.The administrator can update all accounts and book records, borrow and return books, confirmed book request and print records. The Assistant Librarian has all the functions of the administrator except for updating accounts. Borrowers can only view, borrow and return books. LIBRARIAN/ ADMINISTRATOR 0. 0Library Management System for Library Hub Gapan Division ASSISTANT LIBRARIAN SCHOOLS/ BORROWER hold back book (s) Borrow book (s) Update accounts View all records Update book records View books information (Status location) View records Update book records boo k information printed reports Transaction reports Inventory Print records Print reports accommodate Information Figure 3. 0 Context draw of Library Management System for Library Hub Gapan Division Data Flow draw is a means of representing a system at any level. The Figure 3 shows the catamenia of data in the system. The Administrators can update accounts and book records directly in the system.Through the system, they can borrow and return books, generate computerized books reports as well as printing of book records was all possible. In return, the system provides book information, transaction records, inventory, and printed reports. The system also provides book records that used by the borrowers in searching, borrowing and returning books in the system. LIBRARIAN accounting system confirmation 1. 0 Log in accounts Tbl_ACCOUNTS DB depict Confirmation Input Log in information Log in Information account information 2. 0 Update Accounts Account information Account found List of account Updated Account information.Use account 3. 0 Adding books word of honor information Account information List of books Updated make information moderate information DB Tbl_ allbooks make records 4. 0 View record List of books phonograph recording information Book records Use Book information Book record Book information 5. 0 Search books Searched Book information Search book record A Figure 4. 0 Data Flow plot (Librarian) DB A returned book records bribe Books Print record 8. 0 Confirm request Returned Books information All book records Borrowed books Borrowed book records Return books 9. 0 Print infixs 10. 0 Tbl_borrowbooks DB Book supplicate Printed records A.6. 0 Borrow Books Book Record Borrowed books Confirm request Book request Book information 7. 0 Reserved Books LIBRARIAN Book information DB Tbl_ borrowedbooks Borrowed books Tbl_ allbooks Book information DB Figure 4. 1 Data Flow Diagram (Librarian) Figure 4. 0 and 4. 1 shows the track down of data using th e account of the librarian, he/she needs to log in first to access the system which the log in information was retrieve from the database table accounts. When the Administrator log in to the system, it can create account for the borrowers and update these accounts that are saved from the same database table.After having account, adding of books and update record are can be done and saved in the database table allbooks . These records are can be viewed by all type of accounts which used in borrowing books. When they borrow books a request bequeath send that needs to be confirmed by the administrator and this request can serves as a reservation request. If the request were finally confirmed by the admin it saves to the database table borrowedbooks. In returning books, the data in the table borrowedbooks is being retrieved for it to be returned and this was save into the database table returnedbooks with the date returned.For any borrowed books, this were mechanically subtracted to t he total number of books in the database and when the books was returned the number of books borrowed were added to the total number of books. The Administrator can print the records on database tables borrowed, returned and allbooks for the reports of the library. LIBRARIAN 2. 1 Add Accounts DB Tbl_ accounts Inputted account Information account record 2. 3 Update account Book record account Information Updated account record Old account record 2. 2 delay account Input account information Checked information Account status Account Information.Updated Account Information Figure 5. 0 Decomposing Diagram (Adding of Accounts -Librarian) The Decomposing Diagram of adding accounts (Figure 5. 0) shows the process on how the librarian will add or edit account information to the system. The Librarian will input the account information given by the borrowers and the system will check the entered information from the database table accounts if there was an existing record. Then if there was n o record found it will be saved on the same database table. Librarian can update that account information on the database. LIBRARIAN 3. 1 Input book information.DB Tbl_ allbooks Inputted Book Information Book record 3. 3 Update book record Book record Book Information Updated Book record Old Book record 3. 2 Check book record Book information Updated book list Figure 6. 0 Decomposing Diagram (Adding of Books -Librarian) The Decomposing Diagram of adding books (Figure 6. 0) shows the process on how the librarian will add or edit book information to the system. The Librarian will input the book information on the book he/she want to borrow and the system will check the inputted information from the database table allbooks if there was an existing record.Then if there was no record found it will be saved on the same database table. Librarian can update that book records on the database. Book information LIBRARIAN 6. 1 Input book information DB Tbl_ allbooks Inputted account Information Account record Account Information Check book record 6. 2 Borrowed book information 6. 3 DB Tbl_ borrowbooks Submit Borrowing Borrowed book request Request Figure 7. 0 Decomposing Diagram (Borrowing Books -Librarian) The diagram above (Figure 7. 0) shows the process on how the Librarian can borrow books using the system.The Librarian input the book information will be borrowed accordingly the system checks the records in the allbooks if there are available books to borrow and if there are enough books, the entered information serves as a request and this will be saved on database table borrowbooks which need to be confirmed. DB Tbl_ borrowbooks Borrowed Book record 7. 1 Select borrowed books Book information Book record LIBRARIAN Selected borrowed books information 7. 2 Confirmed Request list Approve Request Approved Book request DB Tbl_ borrowedbooks Check book record Figure 8. 0. Decomposing Diagram (Confirm Book Request(Librarian).The diagram (Figure 8. 0) shows the process on how the Librarian will confirm the book request of the borrowers. The Librarian will select a book request of send by the borrower and then click the confirm button. The confirmed request will be saved on the database table borrowedbooks which need to be confirmed. Borrowed Book record Borrowed book information 8. 1 Select Borrowed book DB Tbl_ borrowbooks Borrowed Book information LIBRARIAN Returned Book Information Borrowed Book information DB Tbl_ returnedbooks 8. 2 Complete Return slip Returned Book information Borrowed Book information DB Tbl_ allbooks Figure 9.0 Decomposing Diagram (Return Book -Librarian) The diagram (Figure 9. 0) shows the process on how to return book. The Librarian will select a book record and then click the return button to complete the information needed in returning books. This will be saved on the database table returnedbooks and the numbered of books borrowed is added available books on the table allbooks as part of the inventory.Book information Lis t of books Updated List of books New Book information Book information Searched Book information Book information Log in Information Input Log in information Account Confirmation Account confirmation Bookinformation Old Book information Book record Book records Updated Book record Book information Updated Book record Book records Book records ASSISSTANT LIBRARIAN.1. 0 Log in Account Tbl_ACCOUNTS DB DB Tbl_ allbooks 2. 0 Add books 3. 0 Update Information 4. 0 View record 5. 0 Search books A Figure 10. 0 Data flow Diagram (Assistant Librarian) DBTbl_allbooks A returned book records Return Books Print record 8. 0 Confirm request Returned Books information All book records records Borrowed books Borrowed book records Return books 9. 0 Print Records 10. 0 Book Request Printed records A 6. 0 Borrow Books Book Record Borrowed booksConfirm request Book Request Book information 7. 0 Reserved Books ASSISSTANT LIBRARIAN Book information Input book information Borrowed books DB Tbl_ borrowedboo ks Tbl_borrowbooks DB Figure 10. 1 Data flow Diagram (Assistant Librarian) Assistant librarians account was around like the account of head librarian he/she must log in first to access all the functions of the system. When the Assistant Librarian was successfully log in to the system it can add new book record which save on the database table allbooks. From this table, the book information was being retrieved for updates and it will be saved on the same database table.This account can borrow books and confirmed book request. After the borrowing books and the request was confirmed, it can return the books which will be saved on the database table returnedbooks. The records in the table returnedbooks is retrieve to view the summary of books returned. It can print records such as borrowed, unretuened and master list of books which will retrived records on different database table. This account is not capable of updating account records and reset borrowers password, as well as the view ing the log history of the system as shown in Figure 10. 0 and 10. 1. LIBRARIAN/ASSISTANT LIBRARIAN.5. 0 Return books Borrowed books Tbl_borrowedbooks DB Returned books Request confirmed Borrowed book books Tbl_returnedbooks DB 2. 0 View available books BORROWER Account found Log in Information Input Log in information Account Confirmation Account confirmation 1. 0 Log in account Tbl_ACCOUNTS DB 3. 0 Search books 4. 0 Borrow books Book information books Book records Request book Tbl_allbooks DB Book information 5 Confirmed request Request information Figure 11 Data flow Diagram (Borrower) The account of User can search, borrow and return books which were the basic transaction in the Library Hub.This type of account was capable of viewing all the available books in the Library. User account can search for a specific book to locate, view its availability and information. In borrowing books, the user will fill up the computerized borrower slip and wait for the administrators confirmati on to validate the borrowers request. interlock Topology A network topology describes the arrangement of systems on a computer network. It defines how the computers, or nodes, indoors the network are arranged and connected to each other. Figure 12. 0 Network Topology for Library Management SystemThe topology used in the implementation of the project was star topology which see to the situation because this topology was a server based network. The system needed a server and client computers to be more effective. To establish connection between the computers, hub was used. The server was placed on the table of decimal point Librarian and Assistant Librarian. When the client preferred to use one server for the librarian or the administrator, one computer for the assistant librarian and two computers for the libraries client, star topology is used to establish connection to the computers will be used.Programming Environment Front End Microsoft Visual Basic 6. 0 serves as the front-e nd in developing this project. This is the marginal tool that used to create this Library Management System. Visual Basic (VB) is a programming environment which was called the drag and drop tool because it contains built in tools like the buttons. The proponent decided to use this drag-and-drop buttons on the window directly to the form to design its interface and code the data structures of the proposed system because Visual basic is user-friendly and has a wide support in both text books and in the web.The front end serves as a tool for creating the different forms and interface of the Library Management System. back End MySQL serves as the back-end in developing this project. This serves as the data storage of all the information needed to be recorded in the database. MySQL is very fast reliable and flexible Database Management System. MySQL serve as data or record storage of all the transaction of the Library Management System. For every transactions made in the system, data w ill be saved on the different database table. This database table is where all of the information is stored and retrieved in its operation.To make those database tables, the proponent used WAMP server which has PHPMyAdmin that allows creating and managing the database. It uses a web browser to access it features and manipulate records. Testing In the development of every project, the developer must not commit any shortcomings, problems and/or mistakes. One of the best ways to avoid problems was through conducting a system quizing where in it prisees the system. This helped the project to improve and meet its objective. The twenty (20) individual was asked to test the project through an evaluation instrument provided. The developer time-tested the whole system if bugs exist.If bugs are present, the developer fixed it and makes another test until theres no take in of errors. After the developer test the system, he asked at least seven (7) IT students to test the system because the y have knowledge in this field, at least seven (7) individuals which has a course outside or not related to information technology to ensure its simplicity and understandability. One (1) Head Librarian, one (1) Department of Education prescribed in Gapan and two (2) Assistant Librarian because they were the one who used the system and to get suggestions to improve system functionalities.The evaluation instrument was used to determine what to change and what to add on the system. Lastly, two (2) member of IEAT faculty assessed the whole system and determined the systems performance. The Head Librarian from the Library Hub, Department of Education official and the proponent from IEAT faculty used the administrator account to evaluate the system the assistant librarian used the intended account for them which will be the Administrator 2. And the other respondent used the user/borrower account.In short, twenty (20) respondents are asked to test and assess the system. evaluation instru ment guided/helped the proponent to test the whole system. This helped a lot to evaluate the system for Library Hub. This was trial and error basis, when the respondent find errors/bugs on every question, it must fixed the errors first. The developer 1. Set evaluation instrument and set the units used in the system evaluation and testing. The developer networked the units used. 2. Discussed first all the function of the system and all the information needed to use the system. 3.Actual demonstration on how to use the system by using its every single function. 4. Assist the respondent when they test and evaluate the system. 5. Asked every respondent for their suggestions to make the system perform it full potential. 6. Analysed every suggestions comment and then apply the one that will make the system better. After the system had been assess through the provided evaluation instruments, answers and suggestions have been summarized. Those useful comments and suggestions were applied. T hrough this evaluation the system performed its function to its full potential.After these changes, the developer ensured that the changes made are seen by the respondent to check if it is correct and satisfy them. Through the use of Evaluation Instrument to test and assess the system, data are collected data were analysed to interpret the result of the system evaluation. The evaluation of the system used three (3) sets of evaluation questionnaires that use the different account level which were the account of Head Librarian, Assistant Librarian and Borrowers that had been summarized to use in analysing the results.