Computerized System Essay

7.1 Architectural Design7.1.1 Entity-Relationship DiagramFig. 7.1.1 Database modelOn the figure above, the table item_description contains information almost the items in the schedule. This is where the data for new items leave be stored and updating of information of existing items takes place. Notice that, the table censorious_items has only two attribute which is status that identifies the critical item if it is low or not. The transaction table is where the system stores data regarding individual transaction while item_trans table foc characters on list of items and its bestow price.7.2 governing body Function7.2.1 Physical Data Flow DiagramFig. 7.2.1 Physical DFDThe system mainly consists of functions for sales and inventory management. A customer orders an item and the system checks the inventory by accessing the master item table. New items can be worked by the management and the master item record is updated as such. A process computes the total price for the items ord ered by using the input from the customer and data(prices) from the inventory master table. After the transaction, receipt will be given to the customer and two the inventory record and sales record are updated. If the system detects any item to be at critical level, a notification will be sent to the management.7.2.2 User InterfaceFig. 7.2.2.1 Main MenuThis is the interface where the exploiter has access to every function of the system (Fig. 7.2.2.1). The first thing that will raise up when the user runs the system is the button with a text of V. When the user clicks the V button the five buttons and upon clicking the inventory and report button their gunslinger items will also appear and when the user clicks one of these buttons (Point of Sale, View Inventory, Update Inventory, Add Inventory, Critical Items, View Sales Report, and View Inventory report) the visibility of all buttons will be disabled and then the desired form of the user will appear on the gray space.The sub b uttons of Inventory is where the user reckon of inventory and critical items ( if theres any ), update, and adding of inventory. The sub buttons of reports is where the user views the sales and inventory report of the system, the help button mainly focuses on how to use it or what we call user manual and about the system.Fig. 7.2.2.2 Point of SaleLastly, this form is where the transaction between the manager and the customer takes place. First thing that the user will do is choose an item code and then the quantity for the item and it will automatically compute for the price after that, he will have to click the add item button then the item will appear on the white space on the right expression and then a meat will prompt if he want to add another or not if he doesnt want to add another item the uwser will require to input the customers payment and clicking the complete transaction button will prompt another message if the user is sure about the transaction. And then if the user is sure, the system will prompt another message if he want to print the receipt or not.