Question

Read the scenario below and answer all questions thereafter:
ABC Bank is a large financial institution with millions of customers and thousands of employees.
The bank has a centralised database system that stores all customer information, account data
and transaction records. However, the bank's management team has identified a need for a more
robust and comprehensive data management system that can provide better insights into
customer behaviour, market trends, and business performance.
To address this need, the bank has decided to implement a data warehousing and data mart
system. The data warehouse will serve as a centralised repository for all the bank's data, while the
data marts will be tailored to specific business units or functions within the bank. For example,
there may be a data mart for retail banking, commercial banking, investment banking and risk
management.
Q.3.1 Discuss any three reasons for implementing a data warehouse and data mart
system at ABC Bank
(6)
Q.3.2 Based on the scenario above;
Q.3.2.1 Suggest any three tables that can be found in the ABC database. (3)
Q.3.2.2 For each table identified in Q.3.2.1, list three fields and their data types. (9)
Q.3.3 With the aid of a clearly labelled illustration, explain a relational database model
and its components.
Note: Use any drawing tool e.g., Word, Visio, etc.
(6)
Q.3.4 Discuss two concerns associated with the use of distributed databases using
relevant examples from the scenario.