Hardware Order Billing System
Essay Preview: Hardware Order Billing System
Report this essay
Table of ContentsI. Introduction : Background of the study……………………………………page 1-3Data Flow Diagram………………………………………………….……page 4Fishbone Diagram………………………………………………….……….page5-7Theoretical Frame Work…………………………………………….………page 8Objectives, Scoop and limitation & Significance of the study…….……page 9-10II. Review of Related Studies & Literature & Methodology………………..page 10-17Methods……………………………………………………………………..page 18-19Screenshot………………………………………………………………….page 20-21III. Discussion of Proposed / Computerized System &Use Case Diagram…………………………………………………………..page 22-25Data Flow Diagram……………………………………………………….…page 26Database Design: Tables…………………………………………………..page 27Data Dictionary………………………………………………………………page 28Entity Relationship Diagram……………………………………………….page 29Reports………………………………………………………………………page 30IV. Summary, Conclusion and Recommendation………………………page 31-32IntroductionBackground of the study Inventory is basically the total amount of goods and materials held in stock by a factory, store and other business. An inventory system is a process whereby a business keeps track of the goods and material it has available. In its simplest sense it can be done manually by a count at the end of each day. In this way it is possible to keep a record of the goods coming in to the business and goods being sold. (Chapter 1 Inventory System, 2011)Since manual inventory consumes a lot of time and is prone to errors, it would be helpful to build a system that will computerize the transactions from obtaining of the product description to updating the inventory database. The computerized inventory system will improve employees work efficiency by computerizing regularly and time consuming tasks such as the time spent in taking down product information. As a result, the time can be used in more productive activities. The accuracy of the current system will also be improved, since the computerized inventory system would eliminate the need of continuously encoding long details of products by having an inventory database.Monitoring includes the tracking of individual processes, so that information can be easily seen, and data on the performance of one or more process can be provided.The Hardware Order Billing Inventory System is a proposed system that will provide the production of correct reports, fast retrieval of correct informations and data, reduce the amount of paper works used for recording. Some benefits of the system are to produce a computer-based information system for the current inventory and monitoring, to lessen the manual processes, and to make the system store and generate effective report such as product name, customer name product id, name of the supplier etc.
The proposed system will provide the needed and storing information in a faster, more convenient way by storing file of the informations and data in a computer system that will lessen the effort of owner in storing files from time to time.Data Flow diagram[pic 1] Re-counting Ordered product [pic 2][pic 3][pic 4][pic 5] product [pic 6][pic 7][pic 8][pic 9] Stock Product [pic 10][pic 11][pic 12][pic 13][pic 14] Generate[pic 15][pic 16] Chosen pro- product order [pic 17][pic 18] duct[pic 19][pic 20][pic 21][pic 22][pic 23][pic 24][pic 25][pic 26][pic 27][pic 28][pic 29] Order[pic 30][pic 31][pic 32][pic 33] Payment Record Confirmation Item bought[pic 34] Recipient[pic 35][pic 36] Product count Order [pic 37][pic 38] [pic 39]Figure 1 Data Flow DiagramFishbone Diagram [pic 40][pic 41][pic 42][pic 43][pic 44] Less experience[pic 45] Lack of training [pic 46]