Computerized System Essay

7.1 Architectural Design 7.1.1 Entity-Relationship Diagram Fig. 7.1.1 Database model On the figure above, the table â€Å"item_description† contains information about the items in the inventory. This is where the data for new items will be stored and updating of information of existing items takes place. Notice that, the table â€Å"critical_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 focuses on list of items and its total price. 7.2 System Function 7.2.1 Physical Data Flow Diagram Fig. 7.2.1 Physical DFD The 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 added by the management and the master item record is updated as such. A process computes the total price for the items ordered 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 both 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 Interface Fig. 7.2.2.1 Main Menu This is the interface where the user has access to all function of the system (Fig. 7.2.2.1). The first thing that will show 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 sub 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 buttons of Inventory is where the user viewing of inventory and critical items ( if there’s 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 Sale Lastly, 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 side and then a message will prompt if he want to add another or not if he doesn’t want to add another item the uwser will require to input the customer’s 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.