Traditionally, data was organized into files and sub files which are managed by individuals. This implies enormous data storage facilities, the bulkiness of files and the process of retrieving data is major challenge.
Database systems improve efficiency of existing processes. This is achieved through automating processes that were initially manual. Eventually, new processes are developed that are capable of transforming business into digital entities.
It boosts decision making process. Access provides various reports on given criteria i.e. The Queen’s Inn in St. Johns data file has been used to categories data into various fields e.g. Rooms visited and rates can be used to determine customer’s response to varying services and prices.
DBMS are real time application used in the day to day running of business enterprises. It can be used to provide reports on a firm’s current performance, collect data from different functions and store data in single central data repository. DBMS is more powerful in resolving problems related to fragmented data. The Queen’s Inn in St. Johns data table contains raw data. The data can be manipulated to show different variables of interest using query function in Access. The various queries can be used to generate a clear outline report on various entities as illustrated in the access files.
Data is key element in decision making for every firm. Tracking each element is necessary in order to derive concrete answers to arising problems within an organization, i.e. The Queen’s Inn in St. Johns raw data illustrates simple hotel management system. It may be important to analyze each element in the data table and draw modules on the trends. The trend can be used to generate new ideas, decisions and improve in terms of services.
Data administration, information policy and data quality assurance is essential for managing the firm’s data resources.