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 (ANSWERS) 2025 - DISTINCTION GUARANTEED

Rating
-
Sold
-
Pages
12
Grade
A+
Uploaded on
15-07-2025
Written in
2024/2025

Well-structured IRM4723 Assignment 3 (ANSWERS) 2025 - DISTINCTION GUARANTEED. (DETAILED ANSWERS - DISTINCTION GUARANTEED!)... 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 Question 4 [32] Cloud computing has become a “game changer” for database technologies because it eliminates financial and technological barriers so organisations can leverage database technologies in their business processes with minimal effort and cost. Cloud computing has revolutionised database technologies by removing financial and technological obstacles, allowing organisations to integrate these technologies into their business processes with minimal effort and cost. It has hence become a “game changer”. Nevertheless, it has a number of advantages and disadvantages, even though the advantages definitely outweigh the disadvantages. 4.1 Give the definition of cloud computing according to the National Institute of Standards and Technology (NIST) 4 4.2 Identify and briefly describe each of the main advantages and disadvantages of cloud computing in terms of the services it can provide. 28 IRM4723/103/3//2024 5 Part B: Assignment 03 (self-assessment: Do not submit) Question 1 [27] 1.1 Identify the main phases of the database lifecycle and the actions associated with each of them. [12] 1.2 With respect to database transaction management and concurrence control, discuss the ACID test. [8] 1.3 Discuss the relationship between DBMS performance tuning and query optimisation. [7] Question 2 [8] 2.1 What is the difference between metadata and metadata management? [4] 2.2 What are the advantages of metadata management to organisations? [4]

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 15, 2025
Number of pages
12
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers

Subjects

Content preview

IRM4723Assignment 3 2025
Unique Number:
Due date: August 2025
PART A

QUESTION 1

Question 1.1 – Description of the Three Levels of Management

In any typical organisation, there are three hierarchical levels of management that carry
different responsibilities:

 Top-level management is responsible for strategic decision-making, including setting
the overall goals, vision, and direction of the company. These managers are involved
in long-term planning and policy development.

 Middle-level management translates the strategic goals from top management into
actionable plans and oversees departments or divisions. They make tactical decisions
focused on medium-term goals and allocate resources effectively.

 Operational-level management handles the day-to-day activities of the organisation.
They are responsible for direct supervision of employees and ensure that tasks and
processes are carried out efficiently to meet short-term objectives.

DISCLAIMER & TERMS OF USE
 Educational Aid: These study notes are intended to be used as educational resources and should not be seen as a
replacement for individual research, critical analysis, or professional consultation. Students are encouraged to perform
their own research and seek advice from their instructors or academic advisors for specific assignment guidelines.
 Personal Responsibility: While every effort has been made to ensure the accuracy and reliability of the information in
these study notes, the seller does not guarantee the completeness or correctness of all content. The buyer is
responsible for verifying the accuracy of the information and exercising their own judgment when applying it to their
assignments.
 Academic Integrity: It is essential for students to maintain academic integrity and follow their institution's policies
regarding plagiarism, citation, and referencing. These study notes should be used as learning tools and sources of
inspiration. Any direct reproduction of the content without proper citation and acknowledgment may be considered
academic misconduct.
 Limited Liability: The seller shall not be liable for any direct or indirect damages, losses, or consequences arising from
the use of these notes. This includes, but is not limited to, poor academic performance, penalties, or any other negative
consequences resulting from the application or misuse of the information provided.

, For additional support +27 81 278 3372

PART A

QUESTION 1

Question 1.1 – Description of the Three Levels of Management

In any typical organisation, there are three hierarchical levels of management that
carry different responsibilities:

 Top-level management is responsible for strategic decision-making,
including setting the overall goals, vision, and direction of the company. These
managers are involved in long-term planning and policy development.

 Middle-level management translates the strategic goals from top
management into actionable plans and oversees departments or divisions.
They make tactical decisions focused on medium-term goals and allocate
resources effectively.

 Operational-level management handles the day-to-day activities of the
organisation. They are responsible for direct supervision of employees and
ensure that tasks and processes are carried out efficiently to meet short-term
objectives.



Question 1.2 – DBMS Decision Support at the Top-Level Management

At the top-level of management, a Database Management System (DBMS)
provides decision support by enabling strategic data analysis and long-term
planning. Specifically, it:

 Provides information for strategic decision-making by delivering
summaries, trend analyses, and forecasts based on both internal and external
data sources.

 Supports strategic planning and policy formulation by offering a
centralised system to access reliable and up-to-date data required to define
long-term goals.

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.
Edge
Follow You need to be logged in order to follow users or courses
Sold
9680
Member since
2 year
Number of followers
4252
Documents
2661
Last sold
2 days ago

4.2

1176 reviews

5
663
4
236
3
177
2
27
1
73

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