Inventory system theoretical framework Essay

2.1 IntroductionThe theoretical framework gives information about concepts, together with their commentary which are applyd in the proposed arrangement. This chapter give be giving the family of the existing theories given below to the proposed system.2.2 Transaction Processing SystemA transaction moveing system, or TPS, is a system to capture and border the detailed information necessary to update info on the heavy operations of an organization. A transaction is essentially a single topic that changes something. There are many different types of transactions. For example, customer orders, receipts, invoices, payments, etc. The developed processing of transactions accepts the collection, editing, manipulation and storage of data. The result of processing a transaction is that the records of an organization are updated to reflect the new conditions at the epoch of the last processed transaction. http//education-portal.com/academy/lesson/transaction-processing-systems-tps TPS provide be the type of grammatical construction of the proposed system where it git help the owner and staff to process galactic amount of items data in the union and to process of transactions in the customer.2.3 Inventory Management SoftwareInventory circumspection bundle is a computer- found system for tracking inventory levels, orders, trades and deliveries. It tail assembly alike be used in the manufacturing industry to hold a work order, bill of materials and otherwise production-related documents. Companies use inventory management software to avoid product overstock and outages. It is a tool for organizing inventory data that before was generally stored in hard-copy form or in spreadsheets. It is often associated with and is similar to distribution software, as distributors that kindle compete with less money tied up in inventories have a distinct payoff over their competitors.http//en.wikipedia.org/wiki/Inventory_management_softwareThe proposed system is inventory management software for Miguels rest home Merchandise. This is the software where can be store and monitor items data.2.4 Point of Sale (POS)Point of sale ( likewise called POS or checkout, during computerization subsequent becoming electronic decimal bit of sale or EPOS) is the place where a retail transaction is completed. It is the point at which a customer makes a payment to the merchant in exchange for goods or services. At the point of sale the retailer would calculate the amount owed by the customer and go away options for the customer to make payment. The merchant will also normally topic a receipt for the transaction. http//en.wikipedia.org/wiki/Point_of_saleThe proposed system will provide a point of sale system for Miguels Home Merchandise. It will help the company for faster and organize customer transaction.2.5 Microsoft Office entreeMicrosoft approach, also know as Microsoft Office Access, is a database management system from Microsoft that combines the relational Microsoft small fry Database Engine with a lifelike user interface and software-development tools. It is a piece of the Microsoft Office suite of applications, included in the professional and higher editions or sold separately. Microsoft Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases.Software developers and data architects can use Microsoft Access to develop application software, and power users can use it to build software applications. Like other Office applications, Access is supported by optic introductory for Applications, an object-oriented scheduling language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports expose their methods and properties in the VBA computer programming environment, and VBA statute modules ma y declare and callWindows operating system functions. http//en.wikipedia.org/wiki/Microsoft_AccessMicrosoft Office Access will be the database management system that the proponents will be utilize to store and monitor all items information and also use for miserliness all reports.2.6 Visual base 6.0Visual Basic is a programming language and development environment created by Microsoft. It is an extension of the introductory programming language that combines BASIC functions and commands with visual controls. Visual Basic provides a graphical user interface GUI that allows the developer to drag and drop objects into the program as well as manually write program scratch.Visual Basic, also referred to as VB, is designed to make software development easy and efficient, mend still being powerful enough to create advanced programs. For example, the Visual Basic language is designed to be human readable, which means the address tag can be understood without requiring lots of comme nts. The Visual Basic program also includes features like IntelliSense and Code Snippets, which automatically generate code for visual objects added by the programmer. Another feature, called AutoCorrect, can debug the code trance the program is bucket alongning.Programs created with Visual Basic can be designed to run on Windows, on the Web, within Office applications, or on unsettled devices. Visual Studio, the most comprehensive VB development environment, or IDE, can be used to create programs for all these mediums. Visual Studio .NET provides development tools to create programs based on the .NET framework, such as ASP.NET applications, which are often deployed on the Web. Finally, Visual Basic is available as a streamlined application that is used primarily by beginning developers and for educational. http//www.techterms.com/definition/visualbasicVisual Basic 6.0 is providing GUI and it is easily to use because of its drag and drop function. It would be use for all the proc ess of the Miguels Home Merchandise. According to history VB 1.0 was introduced in 1991. Thedrag and drop design for creating the user interface is derived from a standard form generator develop by Alan Cooper and his company called Tripod. Microsoft undertake with cooper and his associates to develop Tripod into a programmable form system for Windows 3.0, under the code name cherry-red (no relation to the Ruby programming language)Tripod did not include a programming language at all. Microsoft decided to combine Ruby with the Basic language to create Visual Basic.The Ruby interface generator provided the visual part of Visual Basic and this was combined with the EB Embedded BASIC engine designed for Microsofts abandoned Omega database system. Ruby also provided the ability to load dynamic link libraries containing additional controls (the called gizmoz), which later became the VBX interface.2.7 methodologySoftware prototyping refers to the activity of creating prototypes of s oftware applications, incomplete versions of the software program being developed. It is an activity that can occur in software development and is same to prototyping as known from other fields, such as mechanical plan or manufacturing.http//istqbexamcertification.com/wp-content/uploads/2012/01/Prototyping-model.jpg Figure 1 Prototyping ModelProponents choose this type of methodology because this type of method can improve the quality and efficiency of the proposed system by examen the code and module in integration testing repeatedly to find the errors in the system before to go to the acceptation and installation, deployment and go to maintenance. This method requires the involvement of the user and they can tell and move or to give feedback to the development team and know what to change in the system. The development team and the user feedback can provide more changes and improvements in the system.2.8 SummaryIn summary, inventory management software and point of sale would be the goal of the proposed system. It would include the all process of companywherein the proponents will be making an Inventory System with POS for Miguels Home Merchandise.The proponents will be making use of the following software to come up with the system Visual Basic 6.0 and Microsoft Access for the database.