Order entry transaction consists of three steps. First it starts by entering the customers’ details by the sales person then specify the orders quantity and price by reading the order table. According to the figure, delivery transaction engages reading the customer table to find the address and other detail then moves to read the order table to get the order belongs to the customer and via the order line more detail about the order is found such as the quantity. The above figure shows the view product information transaction.
This transaction helps the sale staff to get ordered product information such as the price and stock name by reading the order line table to find the products consisted in the order. Prototype Description: After analysing the size, volatility and transaction analysis, the development of the prototype has taken place. The prototype covers the sale department view with respect to user requirements. Several techniques are used to create the prototype’s interface and functionality such as MS Access and Oracle. Users of this prototype are the staff in sale department using the system regularly to assist them in their job completion.
For example, the system provides the user with friendly interface to carry out different duties and tasks which used to consume their time and efforts. The system has replaced the manual tasks into automated functions represented. The Main screen includes order, customer, product and sales person buttons. This system facilitates critical functions such as: Reports: Different reports consisting figures and business progress are available for the user to print. For example, customer, order, sales person and product reports. Invoice:
The system enables the user printing customer invoice showing significant information about customer and order like customer name, price and quantity. Automatic serial ID: Efficiency and accuracy can be increased by applying automated serial ID number. For example, when a user adds an order an automatic increment in ID field is appeared. Add, delete and edit records: User can add or delete customers, orders and products records in the database. Moreover, easy data editing is approved in this system. Refresh: Along with editing in previous point, the refresh button is used to update data in the system. Search and View:
User can search for specific information regarding each customer, order, and product by means of identifying customer ID, order ID and stuff ID. Back button: The user can easily navigate the system. Save and exist: Save and exist button has been created to prevent user losing data wrongly. Security and Consistency: In general, the system has a consistent functionality (no conflict) and appearance that require short period of time to learn. For example, button layout, positioning and color scheme of the pictures are being designed appropriately. Security is an issue in this system where the users gave a unique password to access.