Learning Objectives

By the end of this chapter, you will be able to:

  • Explain why almost every modern business process depends on a database.
  • Describe how databases are applied in major sectors such as banking, retail, healthcare, education, and government.
  • Distinguish transaction processing (OLTP) databases from analytical (OLAP) databases.
  • Evaluate the business benefits and risks of database applications.

What is a Database Application?

A database application is a software program whose main job is to store, retrieve, and update data held in a database. The user works with forms, screens, or an app, while a Database Management System (DBMS) such as MySQL, Oracle, PostgreSQL, or Microsoft SQL Server manages the data underneath.

For example, when a cashier scans a product at a supermarket, the billing screen is the application. Behind it, the DBMS looks up the product’s price, reduces the stock count, and records the sale.

flowchart LR
  U[User: cashier, customer, officer] --> APP[Database Application: forms, app, website]
  APP --> DBMS[DBMS: MySQL, Oracle, SQL Server]
  DBMS --> DB[(Database)]
  DB --> RPT[Reports and Dashboards]

Figure 1: How a user reaches data through a database application

Two Kinds of Database Workload

Aspect OLTP (Online Transaction Processing) OLAP (Online Analytical Processing)
Purpose Run day-to-day operations Support analysis and decision-making
Typical activity Insert, update, delete individual records Summarize large volumes of historical data
Example Recording a deposit at a bank counter Comparing branch deposits over five years
Users Clerks, customers, front-line staff Managers, analysts, executives
Data Current and detailed Historical and aggregated

Most organizations run an OLTP database for operations and copy its data into a data warehouse for OLAP analysis (covered in Unit 10).

Database Applications by Sector

1. Banking and Financial Services

  • Core Banking Systems (CBS) keep every account, balance, loan, and transaction in a central database, so a customer can deposit in Pokhara and withdraw in Kathmandu.
  • ATM, mobile banking, and QR payments query the same database in real time to check balances before approving a transaction.
  • Digital wallets such as eSewa and Khalti record every top-up, transfer, and bill payment.

2. Retail and E-Commerce

  • Inventory management: stock levels update automatically with each sale, and reorder alerts fire when items run low.
  • Point of Sale (POS): product prices, discounts, and VAT are pulled from the database at billing.
  • Online stores such as Daraz store product catalogues, customer accounts, orders, and delivery status.

3. Healthcare

  • Hospital Information Systems store patient records, appointments, lab results, prescriptions, and billing.
  • Doctors can see a patient’s history instantly instead of searching paper files.

4. Education

  • Student Information Systems handle admissions, enrolment, attendance, exam results, and fee payments.
  • Learning Management Systems such as Moodle or Google Classroom store courses, submissions, and grades.

5. Government (E-Governance)

  • National ID and civil registration records support services delivered through the Nagarik App.
  • Tax systems at the Inland Revenue Department store PAN registrations and returns.
  • Vehicle and driving licence registries at the Department of Transport Management.

6. Travel, Hospitality, and Transport

  • Reservation systems for airlines, buses, and hotels prevent the same seat or room from being sold twice.
  • Booking platforms show live availability by querying the database on every search.

7. Telecommunications and Utilities

  • Operators such as Nepal Telecom and Ncell store subscriber details, call records, data usage, and recharge history.
  • Electricity and water utilities keep meter readings and generate monthly bills from the database.

8. Human Resources and Payroll

  • Employee records, attendance, leave, salary, tax deductions, and provident fund contributions are all held in HR databases, so payroll can be generated automatically.

9. Customer Relationship Management (CRM)

  • CRM databases store every customer interaction, purchase, and complaint, allowing businesses to personalize offers and measure customer loyalty.

Business Benefits of Database Applications

  • Speed: thousands of transactions are processed every second.
  • Accuracy and consistency: one central record avoids conflicting copies of the same data.
  • Sharing: many users and branches work on the same data at the same time.
  • Security: access rights control who can view or change each record.
  • Better decisions: stored data feeds reports, dashboards, and forecasts.
  • Customer service: staff can answer queries instantly from complete records.

Risks and Challenges

  • Data breaches: a single database can expose millions of customer records if poorly secured.
  • Downtime: if the database fails, the whole business process can stop, so backups and recovery plans are essential.
  • Cost and skills: licences, servers, and trained database administrators are expensive.
  • Data quality: wrong or duplicate data entered once is repeated in every report (“garbage in, garbage out”).
  • Privacy compliance: organizations must protect personal data and use it only for its stated purpose.

Summary

Database applications sit behind nearly every service people use daily, from bank transfers and online shopping to exam results and government services. OLTP databases run daily operations, while analytical (OLAP) systems turn the same data into insight for managers. The value they deliver depends on good security, reliable backups, and accurate data entry.

Key Takeaways

  • A database application is the user-facing program; the DBMS manages the data behind it.
  • OLTP handles day-to-day transactions; OLAP supports analysis and decision-making.
  • Banking, retail, healthcare, education, government, travel, telecom, HR, and CRM all depend on database applications.
  • Benefits include speed, accuracy, sharing, and better decisions; risks include breaches, downtime, and poor data quality.

Review Questions

  1. What is a database application? Explain with an example from a business you use regularly.
  2. Differentiate between OLTP and OLAP with suitable examples.
  3. Explain how a bank uses a database to let customers transact from any branch or ATM.
  4. Describe any four sector-wise applications of databases in Nepal.
  5. What risks does an organization face when it depends heavily on a single database, and how can they be reduced?