In earlier days, data was stored manually using pen and paper, but after computer was invented, the same task could be done using files. A file system is a method for storing and organizing files and the data they contain to make it easy to find and access them. A computer file is a resource that uniquely records data in a storage device in a computer. The File Processing System (FPS) is the traditional approach to keep individual data whether it is on shelf or on the drives. Prior, people used the FPS to keep records and maintain data in registers. In the early days of FPS usage heralded as major advances in data management. As applications in computing have grown in complexity however, it has quickly become less-than-ideal solution. In most ways, FPS systems resemble the conceptual framework provided by common operating systems like Windows and Linux. Files, directories, and metadata are all accessible and able to be manipulated. Database Management System (DBMS) serves as most modern application management but there are certain use cases where an FPS may be useful, most notably in Rapid Application Development and some disparate cases of data analysis, Generally, FPS architecture involves the input, process and output. During this Covid 19 pandemic, there are still existing FPS usage to support current operations in organizations. This is due to the files for storing various documents can be from many users or departments. In addition, all files are grouped based on their categories, and are arranged properly for easy access. If the user needs to insert, delete, modify, store or update data, he/she must know the entire hierarchy of the files
(a) Design ONE (1) diagram that combines your proposed scenario in 1(a) and the FPS drawback in 1(b). Your diagram should consider the data access from different users.
(6) The difficulties arising from the FPS prompted the development of a new approach to manage a large amount of organisational information called the database approach. When an organization uses the database approach, many programs and users share the data in the database. When a user is working with the database, the DBMS provides an environment that is both convenient and efficient for the user to retrieve and store information. Application program accesses the data stored in the database by sending requests to the DBMS. Due to the distributed nature of organizational units, most organizations in the current times are subdivided into multiple units that are physically in distributed locations. Each unit requires its own set of local data. Thus, the overall database of the organization becomes distributed
i) The database engineer has been instructed to change the data management from the FPS into the distributed DBMS. Suggest the BEST distributed DBMS strategy, and explain how this strategy can be executed.
i
Justify THREE (3) reasons for the suggestion of the distributed DBMS strategy in your answer 2(d)i.