IRM4723 Assignment 3 (100% COMPLETE ANSWERS) 2025

Database Systems IV - IRM4723 Assignment 3 2025 - DUE August 2025; 100 % TRUSTED workings, Expert Solved, Explanations and Solutions. For assistance call or W.h.a.t.s.a.p.p us on ...(.+.2.5.4.7.7.9.5.4.0.1.3.2)........... 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. Distribute