100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached 4.2 TrustPilot
logo-home
Exam (elaborations)

IRM4723 Assignment 3 Memo | Due August 2025

Rating
-
Sold
-
Pages
9
Grade
A+
Uploaded on
18-07-2025
Written in
2024/2025

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

Show more Read less
Institution
Course









Whoops! We can’t load your doc right now. Try again or contact support.

Connected book

Written for

Institution
Course

Document information

Uploaded on
July 18, 2025
Number of pages
9
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers

Subjects

Content preview

, PLEASE USE THIS DOCUMENT AS A GUIDE TO ANSWER YOUR ASSIGNMENT

 Question 1

1. 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.

Top-level management
Top-level management is responsible for making strategic decisions within the organization. This
level involves high-level planning, policy creation, and setting long-term goals. To support these
activities, the database must provide access to both internal and external data, helping identify
growth opportunities and determine the organization's future direction. It also helps in formulating
and enforcing organizational policies that align with business rules at lower levels. The database aids
in monitoring the achievement of strategic goals, ultimately aiming to improve returns on investment
by enhancing cost management and productivity.

Middle management
Middle management is focused on making tactical decisions and translating the organization’s
strategic goals into specific plans and actions. The database plays a crucial role here by supplying the
data needed to monitor and allocate resources, assess departmental performance, and guide
day-to-day operations. Additionally, it ensures the security and privacy of organizational data,
offering a structured way to manage and control information flow between various departments.

Operational management
Operational management is responsible for making day-to-day decisions that ensure the smooth
functioning of the organization. At this level, the database needs to be highly adaptable to support
ongoing operations. It must be capable of handling large volumes of transactions quickly and
efficiently while maintaining performance standards. The database also helps improve short-term
operations by providing real-time data for tasks such as customer support and application
development. Its ability to handle frequent, high-volume transactions is key to supporting daily
business activities and maintaining operational efficiency.

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.

Top-level management
For Top-level management, a database management system (DBMS) provides decision support by:

 Supplying the necessary information for strategic decision-making, including strategic
planning, policy formulation, and goal setting.
 Offering access to both external and internal data, enabling management to identify growth
opportunities and determine the direction of the organization’s growth, whether as a service
provider, manufacturer, or a combination of both.
 Supporting the creation and enforcement of organizational policies, which are then translated
into business rules at lower levels.
 Enhancing the potential for a positive return on investment by helping to find ways to reduce
costs and increase productivity within the organization.
 Providing feedback to track the achievement of the organization’s strategic goals and adjust as
necessary.

Get to know the seller

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
Aimark94 University of South Africa (Unisa)
Follow You need to be logged in order to follow users or courses
Sold
6575
Member since
6 year
Number of followers
3168
Documents
1326
Last sold
1 month ago
Simple & Affordable Study Materials

Study Packs & Assignments

4.2

520 reviews

5
277
4
124
3
74
2
14
1
31

Recently viewed by you

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Frequently asked questions