Abstract The purpose of this study is to apply a MySQL database-equipped inventory system to a sample cellphone retail store where it would manage the store’s product inventory and improve the physical-writing of daily/monthly inventory reports for them to examine. It will be a process integration where we will install a computer system to help them generate an inventory report that they’ll just have to input certain data and the system would provide them of a formatted document.
We haven’t actually produced any results yet since we are starting to process the system’s requirements and interface of a cellphone store and thus, this section of the abstract would be improve until the important data for this report is already obtained. II. Acknowledgements We would like to acknowledge the help of our Software Engineering course professor, Mr. Rolando Fajardo, for motivating us to strive hard and gave us the necessary sample materials to complete and further understand the completion of this documentation of our project.
We would also like to acknowledge the help and support that we got from our fellow colleagues here at Far Eastern University – Makati for the guidance and certain help they gave us while conducting and making this documentation III. Dedication We dedicate this documentation for all our batch mates and our fellow Information Technology students here at Far Eastern University – Makati as this documentation may inspire them to strive hard and further improve their skills as the future’s next leading programmers, designers and all other types of workers in the field of Information Technology.
While it is somehow proven that physically-written reports are mostly fool-proof evidence of a legitimate or official document in certain businesses, it really takes too much time and effort for people to actually write these kinds of reports for their business. With a generation that mostly relies on technology nowadays, we do not consider anymore this kind of process of making it and now depending on computer to make one for us with just simply placing data in a certain program that would generate a well-designed report to be examined by people. Background of the Study
In our technology-dependent generation right now, it is easy to say that written documents are already out of style right now since some computer applications or software are now integrated to analyse, formulate and produce documents that are well-formatted and well-designed by these programs. Our MySQL database-equipped cellphone inventory system would integrate the usual paper-recording of product inventory in certain store in which, we will apply this for a cellphone inventory store that usually updates their inventory for their stock availability, products sold and stock left in their store.
We will integrate their system of updating it through a software inventory system that’s powered by a MySQL database to ease the burden of writing/recording and making an inventory report for daily or monthly sales report for their store. Research Paradigm Input Process Output New Product/Item (Details) Adding of New Item in Inventory (w/ Details) Report that a new item was added New Stock for Products Updating Inventory for new stock (Stock column) Report that stock column has been updated with new stock quantity Edit details of product Editing Inventory for details of a product Report that product details has been edited
Delete product from Inventory Removal of Item/Product from Inventory Report that product has been removed from inventory Daily Sales Data Processing of store’s transactions Written/Formatted Report of Daily Sales Monthly Sales Data Processing of store’s transactions (w/in the whole month) Written/Formatted Report of store’s Monthly Sales Statement of the Problem The focus of this study is whether an inventory system equipped with a MySQL database would work for a cellphone store storing, updating, and deleting their products and its details for easy-completion of their store inventory.
Significance of the Study We are motivated to pursue this study because of the application of an inventory system equipped with MySQL database for a cellphone store to integrate their store’s inventory system and to ease the paperwork usually needed to record the all of the products that go to their inventory Scope and Delimitation The scope of this study covers the adding, updating/editing, removing and other necessary tasks that a cellphone retail store does for their inventory management.
This system integrates the written documents that were usually used before in writing an inventory report of their products and additional details that is necessary for it. The delimitation of this system is that it only covers the basic inventory process that these stores need for their inventory management. Additional features would be optional since our system would only be focusing on the main inventory process of the business. Added features are expected not to work efficiently or perfectly as of this moment since we are just integrating the basic functions of their inventory process. Definition of Terms
Inventory – an itemized list of current assets: as a catalogue of the property of an individual or estate or a list of goods on hand Inventory Management – is vitally important for any business that sells a physical product. Cellular phone/Cellphone – portable phone: a portable telephone operated through a cellular radio network Database – collection of data on computer: a systematically arranged collection of computer data, structured so that it can be automatically retrieved or manipulated MySQL – MySQL is an open source relational database management system (RDBMS) based on Structured Query Language (SQL).
VI. Chapter 2 REVIEW OF RELATED LITERATURE AND STUDIES Foreign Literature(both should be from 2009-2014) Foreign Studies Local Literature Local Studies VII. Chapter 3 RESEARCH METHODOLOGY Specification of Research Design Respondents of the Study Research Instrument Data-Gathering Procedure/Source of Data VIII. Chapter 4 SUMMARY, CONCLUSIONS AND RECOMMENDATIONS Summary of FindingsConclusionsRecommendations Further for Further Studies BIBLIOGRAPHY APPENDICES Letter of Request for Permission to Conduct Survey Questionnaire Curriculum Vitae USER’s MANUAL ( separate document)