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

Bela Pinga Ltd Company - Essay ExampleDatabase focusing System (DBMS) can achieve this. By doing this Bela Pinga Ltd. business will achieve Speed of response, Accuracy of Information, cost-efficient Transaction, Low Overheads and Maintaining Service Standards.This report will analyze the gross gross revenue processing (Sales Department) of the Bela Pinga Ltd, which is located in commercial-grade Street, Sheffield, receives and processes sales hostelrys from customers. In the initial section, the application domain of the potential user(s) and requirement analysis of the sale way will be presented. After that, E-R Model and Relational Data Model (RDM) will be examine 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 ground 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 want 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 secernate Processing View of Bela Pinga Ltd. The four major entity identified are Customer, Order, Wine Details, and Invoice.