Database Design Activities of Bela Pinga Ltd

0 Comment

The aim of the company is to evolve in E-commerce solutions and making full use of the database. However, as a started firm, it has very limited resources and a small customer base. This carried out many problems and difficulties in developing and improving the company. As the managing director said, “these manual statements are very time consuming to operate, untidy in appearance and difficult to amend" (Baptista, 2007).
There is no integrity between the three offices (Sales, Purchase and Logistics). As a result, time consuming, inefficiency and hardware cost are problems in the company. For example, Customers might order something that is out of stock, because the sales department has no idea about the stock and there is no constant update with current inventory. Besides that, the paper-based system effect the employee speed of response as well as the accuracy of the information which indirectly forces the company’s customers to shift to other competitors with a better customer service system (Elmasri, 2000). Also, there is no centralized location to store the information, therefore, the employees spend a long time to find the information they need. For example, customer information is stored manually in papers. thus it is difficult for the sales staff to go through papers to find the details required for advertisement. Also, employees at logistic and sales departments need to go down and check if they have the order issued by the customer which is quite an annoying process and time-consuming. The same problem is faced during the purchase order process, thus it will be quite useful to have a database which alarms the purchasing department to make orders when required rather than waiting for logistic department notification.
In the sales department, customers need to wait for a long time to get their orders due to paper-based procedures. In addition, if any customer has a question regarding an order, the employee needs to search in a huge amount of papers in order to find the invoice and serve the customer.&nbsp.