IRM4723 ASSIGNMENT 3 2025 – FULLY ANSWERED (DUE AUGUST 2025)

Description

IRM4723 Assignment 3 Memo | Due August 2025. All questions fully answered. Question 1 [28] Regardless of the organisation, the database’s predominant role is to support managerial decision making at all levels in the organisation while preserving data privacy and security. 1.1 Describe each of the three levels of management that usually exist in an organisation. 6 1.2 What kind of decision support does a database management system (DBMS) give to the first level YOU mentioned? NB: Name the level first and then provide the answer in each case. 10 1.3 What kind of decision support does a database management Systems (DBMS) give to the second level YOU mentioned? 6 1.4 What kind of decision support does a database management Systems (DBMS) give to the third level YOU mentioned? 6 Question 2 [11] In DBMS, locking methods are one of the most common techniques used in concurrency control because they facilitate the isolation of data items used in concurrently executing transactions. 2.1 What is concurrency control? 2 2.2 A deadlock is a condition where two or more transactions wait indefinitely for the other to release the lock on a previously locked data item. Give and briefly describe three ways in which you can control deadlocks in a DBMS. 9 4 Question 3 [33] In terms of database management strategies, a distributed database management system (DDBMS) approach is particularly desirable because centralised database management often faces significant problems. Distributed database concepts and components are likely to play a key role in future database development, especially for specialised mobile and location-aware applications, as internet bandwidth improves. The success of the Internet and mobile technologies may further encourage the use of distributed databases, reducing bandwidth-related bottlenecks. 3.1 What is a distributed database management system (DDBMS)? 3 3.2 Despite its desirability, a DDBMS has both advantages and disadvantages. Briefly identify and describe the advantages of a DDBMS. 16 3.3 Provide and briefly describe the disadvantages of a DDBMS. 14