"Database System Concepts and Its Application in Modern Banking" Chapter 1: Introduction to Data and Database by Joyanta Chandra Samadder BSO, ONE Bank PLC

“Database System Concepts and Its Application in Modern Banking”
written by Joyanta Chandra Samadder, BSO, ONE Bank PLC.

Chapter 1: Introduction to Data and Database

1.1 Introduction

In the modern digital era, data has become the most valuable asset for every organization — especially for the banking sector, where millions of financial transactions, customer records, and digital interactions happen every second. Managing this enormous amount of data efficiently, securely, and reliably is the core function of a Database Management System (DBMS).

Banks today depend heavily on database systems to store customer details, process transactions, monitor loans, manage credit cards, and ensure smooth day-to-day operations. Without a strong database backbone, no modern bank can operate successfully or maintain customer trust.

1.2 What is Data?

Data refers to raw facts, figures, or symbols that represent information but have no meaning until they are processed.
Example:

• Customer Name: Joyanta Chandra Samadder

• Account Number: 123456789

• Transaction Amount: ৳ 5,000

Individually, these are just pieces of data. But when combined meaningfully — like Joyanta deposited ৳5,000 into account 123456789 — it becomes information.

Types of Data

1. Structured Data: Organized in tables or spreadsheets (e.g., customer details in Excel or SQL).

2. Unstructured Data: Texts, emails, videos, or scanned documents.

3. Semi-structured Data: JSON, XML — used in modern web-based banking systems.

1.3 Information and Its Importance in Banking

Information is processed data that helps in decision-making. In banking:

• Managers use information to track credit risk.

• Sales officers (like you, Joyanta) use data to analyze customer eligibility for credit cards or loans.

• The head office uses aggregated data to make strategic financial decisions.

Example:

Data	Information
“500 customers applied for a credit card this month.”	“Credit card sales increased by 20% compared to last month — success of current marketing strategy.”

So, databases help transform raw data into meaningful insights for the banking industry.

1.4 What is a Database?

A Database is a systematic collection of related data that can be easily accessed, managed, and updated.

Definition (by C.J. Date):

“A database is a collection of persistent data that is logically related and shared among multiple users.”

In Banking Context:

A database stores:

• Customer personal information

• Account balances

• Transaction histories

• Credit card records

• Loan repayment schedules

Example:
When you open a customer profile in ONE Bank’s system, you are actually retrieving data from the Core Banking Database (CBS).

1.5 Characteristics of a Good Database System

1. Data Integrity: Accuracy and consistency of data (no duplicate accounts).

2. Security: Protects sensitive data (e.g., PIN, account number).

3. Data Independence: Application changes don’t affect stored data.

4. Concurrency Control: Multiple users can access the same database safely.

5. Backup and Recovery: In case of power failure or system crash.

6. Scalability: Ability to handle increasing data (important for growing banks).

1.6 Database Management System (DBMS)

A DBMS is software that allows users to store, retrieve, and manage data efficiently.

Examples:

• Oracle Database (used by many large banks)

• MySQL / MariaDB

• Microsoft SQL Server

• PostgreSQL

• MongoDB (for NoSQL and analytics)

• Finacle and Temenos T24 (Core Banking Systems)

Functions of a DBMS:

1. Data storage, retrieval, and update

2. User access control

3. Data security

4. Transaction management

5. Backup and recovery

6. Query processing (SQL)

1.7 Importance of Database Systems in Banking

Purpose	Description
Customer Management	Store detailed customer information securely.
Transaction Management	Track deposits, withdrawals, fund transfers in real-time.
Loan and Credit Card Processing	Automate approvals and repayments.
Fraud Detection	Analyze suspicious activities using data analytics.
Reporting and Compliance	Generate reports for Bangladesh Bank or auditors.
Decision Making	Help management forecast risks and profits.

Example:
If ONE Bank wants to analyze which branch has the highest number of credit card sales, the branch-wise database will provide that insight instantly.

1.8 From Manual Records to Digital Databases

Traditional System:

Earlier, banks used paper ledgers to record transactions. It was:

• Time-consuming

• Error-prone

• Difficult to search or analyze

Modern System:

With the help of DBMS and Core Banking Systems (CBS):

• All branches are connected through a central database.

• Customers can access their accounts from any branch or ATM.

• Data is updated in real-time.

This transformation is the heart of digital banking evolution.

---

1.9 Example: ONE Bank PLC Database Workflow

1. Customer opens an account → data entered into central CBS.

2. Data is stored in Oracle or SQL Server database.

3. Every deposit, withdrawal, or credit card transaction updates the database in real-time.

4. Reports are generated daily for the Head Office.

So, every operation — from account opening to transaction monitoring — depends on an accurate and efficient database.

1.10 Summary of the Chapter

• Data = raw facts; Information = processed, meaningful data.

• Database stores data systematically and ensures easy access.

• DBMS is the software that manages these databases.

• Banking systems rely entirely on database technology for daily operations, customer management, and security.

• The shift from manual records to digital databases has revolutionized modern banking.

1.11 Key Terms

Term	Meaning
Data	Raw facts and figures
Information	Processed data that provides meaning
Database	Organized collection of related data
DBMS	Software used to manage databases
Data Integrity	Accuracy and reliability of data
SQL	Structured Query Language used to interact with databases
Core Banking System	Centralized platform connecting all bank branches

1.12 Exercise

1. Define “Data” and “Database” in your own words.

2. What are the main characteristics of a good database system?

3. Why is a DBMS essential in the banking industry?

4. Explain how databases improve decision-making in banks.

5. Give an example of data transforming into information in banking.