Bela Pinga Ltd Company Essay Example | Topics and Well Written Essays - 1500 words

Bela Pinga Ltd Company - Essay Example Database Management System (DBMS) can achieve this. By doing this Bela Pinga Ltd. business will achieve Speed of response, Accuracy of Information, Cost-Effective Transaction, Low Overheads and Maintaining Service Standards. This report will analyze the sales processing (Sales Department) of the Bela Pinga Ltd, which is located in Commercial Street, Sheffield, receives and processes sales orders from customers. In the initial section, the application domain of the potential user(s) and requirement analysis of the sale office will be presented. After that, E-R Model and Relational Data Model (RDM) will be analyzed for sale office system. In the last section of the report database overview and screenshots of the database (Microsoft Access Database System) made will be shown. The Information (Database) System will be made in Microsoft Access database system for sales order processing views for â€Å"Bela Pinga Ltd†. This will serve as the prototype for the final version that will be based on a combination of Linux, Apache, MySQL, and PHP. This Information system will be used by for the sales order processing view. The potential user of the Information system will be customers who place orders and the sales assistants who check the availability of the desired type of wine in Bela Pinga Ltd stores at the Logistics Department in Nottingham Street, Pitsmoor, Sheffield. However, if the quantities of the desired type of wines are not available, then sales assistants notifies it to the Purchasing Department, which is further taken care by the Purchasing department and is out of scope for this assignment (assumption). Figure 1 shows the E-R Model for the Sale Order Processing View of Bela Pinga Ltd. The four major entity identified are Customer, Order, Wine Details, and Invoice.