This chapter presents a brief discussion of the literature reviewed by the researcher which further enriched the conceptualization of the study and helped in describing the cognitive design that guided the conduct of the researcher. The researcher conducts several review in order to gather information about the present existing condition of the Custodian' Inventory knowing its problem and enhancing it by developing Computerized Inventory System.
Review of related Conceptual Literature In today’s growing market many businesses are turning toward computerize systems to perform their everyday tasks. As stated by R. M. Stair (2001), a database is an organized collection of facts and information. An organizations database can contain facts and information on customers, employees, inventory, competitors, sales information and much more.
Most Managers and executive believe a database is one of the most valuable and important parts of a computer-based Information System However, companies are increasingly employing Inventory System. A computer start with an inventory counts in memory. Withdrawals are recorded by the computer as they are made, and the inventory balance is constantly revised. When the recorded point is reached, the computer automatically places an order, when this new order is received, the recorded balance is increased.
Retail stores have carried this system quite far, each item has magnetic codes, and as on item is checked out and it passes over an electronic reader, which then adjusts the computers inventory balance, at the same time the price is fed to cash register tape. When the balance drops to the recorder point, an order is place. Stated by Brigman (2000). According to Taylor(2000), the database processing is one common operator performed on computer today. In fact, only word processing and spreadsheet packages outrank database management systems among the most popular business tools.
Companies keep track of their customers. Product inventories employees, and capital assets in database, business, governments, and organization around the world grind to halt without database. Users are the reason for the season, the season of designing, creating, implementing and maintaining any database. The needs of the user are taken into consideration when the database is designed, and the final goal in implementing a database is making it available to users who in turn utilize the database that you and possibly many others have had in developing.
Catinding's Hat Merchandise Inventory System was developed to replace the manual system. The proposed aimed system controlled and monitored proper requisition of stocks and avoided variance and over stocking. It offered a more convenient way of fast means of retrieving data and generating reports. The system used Visual fox pro as a database management system. (Catinding's Hat Merchandise Inventory System, Lazaro and Diomedes, 2002)
The system, "Regalo atbp. Sales and Inventory System " will monitor and record the purchased or sold product. The goal of this system is to develop an effective and convenient for Regalo atbp. Sales and Inventory System such as adding, viewing and updating the records in the database. stated by Esguerra et. Al (2006).
Review of related Research and Studies
The thesis entitled A Proposed Inventory System (LAN Based) of Design Ligna INC. by Cobrado, Deade and Ortega (March 2002), stated that inventory System was essential in a growing business company, it helped organize, list make plans for, and records equipments and supplies. It kept track of the assets of the company, its liabilities and also their profits. It also showed the margin of error in production, the high and lows of sales and the list of supplies to produce one single item. The software used was Visual Basic 6.0 and Microsoft Access 2000.
The thesis entitled Computerized Inventory System for ARB Commercial by Alcano and Dumalaya(march 2001) aimed to monitor the ins and outs of the stocks which were home appliances and furniture. It can process the inventory and generate reports at any given time and can provide helpful functions and printed copy of reports at any given time and can provide helpful functions and printed copy of reports required by the primary users. The software was Visual Foxpro version 6.0.
The thesis entitled A Proposed Computerized Inventory System for San Pedro Mini-mart by Vergara and Vega (March 2002) stated that the system helped the company respond quickly to customers demand, which was an important elements of competitive strategy. The more effective a company's inventory is, the better it is to manage its resources and to complete effectively. The system was a collection of people, equipments and procedures that function to keep account of the quantity of each items and to determine which item to buy or what quantities to produce. The software that has been used was Visual Basic 6.0 which was simple to use and provided many tools to develop an effective application. It also has powerful performance and user-friendly interface.