Week 1

Site:	Newgate University Minna - Elearning Platform
Course:	Data Management
Book:	Week 1

Printed by:	Guest user
Date:	Sunday, 14 June 2026, 4:01 AM

Description

Teaching and Learning Methods to be Employed

1. Introductory illustrated lecture

2. Interactive discussion: Where do we encounter databases in Nigeria daily?

3. Demonstration: Opening a sample database in MySQL Workbench

4. Think-Pair-Share: Differences between a file system and a database

Learning Outcomes / Objectives

By the end of this week, students should be able to:

1. Define data, information, and knowledge and explain their relationship.

2. Explain the concept of information management and its importance.

3. Distinguish between a file-based system and a database system.

4. Define a database and a Database Management System (DBMS).

5. List the key advantages of the database approach over file-based systems.

1.1 Data, Information, and Knowledge
1.2 Information Management Concepts
1.3 File-Based Systems vs. Database Systems
1.4 What is a Database?
1.5 What is a Database Management System (DBMS)?
1.6 Advantages of the Database Approach

1.1 Data, Information, and Knowledge

These three terms are often used interchangeably but have distinct meanings:

Term	Definition	Nigerian Example
Data	Raw, unprocessed facts and figures without context	'08023451234', '45000', 'Minna', '2024-01-15'
Information	Data processed and organised to provide meaning	'Customer Chukwuemeka in Minna transferred ₦45,000 on 15 January 2024'
Knowledge	Information interpreted and applied to make decisions	'Customers in Minna transfer more funds on weekdays, schedule more agents then'

The progression from data → information → knowledge is central to information management. Organisations like the Central Bank of Nigeria (CBN) collect millions of raw transaction data points and transform them into economic indicators and policy knowledge.

1.2 Information Management Concepts

Information Management (IM) is the systematic process of collecting, organising, storing, maintaining, retrieving, and distributing information to support organisational decision-making. Key IM activities include:

1. Information Capture — Collecting data from various sources (forms, sensors, transactions)

2. Information Representation — Encoding data in structured formats (tables, XML, JSON)

3. Information Storage — Persisting data reliably on storage media

4. Information Retrieval — Finding and extracting relevant data quickly

5. Information Indexing — Creating structures that speed up retrieval

6. Information Privacy and Security — Protecting data from unauthorised access

Nigerian Context: Nigeria's National Identity Management Commission (NIMC) manages over 100 million identity records. This is an enormous information management challenge involving: capturing biometric data at enrolment centres, representing it in a structured database, storing it securely across multiple data centres, and retrieving it instantly when a citizen needs identity verification at a bank, airport, or government office.

1.3 File-Based Systems vs. Database Systems

Before databases, organisations stored data in flat files, separate files maintained by each department. This file-based approach led to serious problems:

Problem with File-Based Systems	Example from Nigeria
Data Redundancy: Same data stored in multiple files	A student's address stored in separate files for bursary, registry, and library all must be updated when they move
Data Inconsistency: Different files have different values for the same data	Student's phone number differs between the admissions file and the hostel file
Difficulty in Accessing Data: Each query requires custom programs	IT staff must write a new program every time management needs a new report
Data Isolation: Data scattered across many files in different formats	Combining data from HR (Excel) and Payroll (text files) requires manual effort
Integrity Problems: Hard to enforce rules across separate files	No automatic check that a staff payment doesn't exceed the budgeted amount
Security Problems: Difficult to control access at a fine-grained level	Either everyone can access the entire HR file or no one can
Concurrency Problems: Multiple users modifying files simultaneously causes corruption	Two clerks updating the same student record simultaneously corrupt the file

1.4 What is a Database?

A database is a shared collection of logically related data and a description of this data, designed to meet the information needs of an organisation.

Key aspects of this definition:

1. SHARED: Multiple users and applications access the same data

2. LOGICALLY RELATED: Data is organised to reflect real-world relationships

3. DESCRIBED: The database includes metadata (data about the data) called the schema

4. ORGANISED: Data is structured for efficient storage and retrieval

EXAMPLES OF DATABASES IN NIGERIA:

Organisation	Database Content
NNPC (Nigerian National Petroleum Corporation)	Oil well locations, production data, pipeline maintenance records, revenue
FRSC (Federal Road Safety Corps)	Driver licence records, vehicle registrations, accident reports
WAEC (West African Examinations Council)	Student registrations, examination results, school accreditation records
Flutterwave	Merchant accounts, transaction records, payment routes, exchange rates
Nigerian Prison Service	Inmate records, sentence information, release schedules

1.5 What is a Database Management System (DBMS)?

A DBMS is a software system that enables users to define, create, maintain, and control access to a database. It acts as an intermediary between users/applications and the physical data stored on disk.

Popular DBMS products include:

DBMS	Type	Common Use Cases in Nigeria
MySQL	Relational (Open Source)	Web applications, fintech, e-commerce (Jumia, Konga)
PostgreSQL	Relational (Open Source)	Enterprise systems, geospatial applications
Oracle Database	Relational (Commercial)	Banking (most major Nigerian banks), telecoms
Microsoft SQL Server	Relational (Commercial)	Government systems, ERP implementations
MongoDB	Document (NoSQL)	Mobile apps, real-time analytics, content platforms
SQLite	Relational (Embedded)	Mobile apps (Android/iOS), embedded systems

1.6 Advantages of the Database Approach

Advantage	Explanation
Controlled Data Redundancy	Data is stored once; redundancy is minimised and controlled
Data Consistency	Single source of truth eliminates conflicting values
Data Sharing	Multiple users and applications access the same data simultaneously
Improved Data Security	DBMS enforces access control — users see only what they are authorised to see
Data Integrity	Rules (constraints) are enforced automatically by the DBMS
Data Independence	Applications are insulated from changes in data storage structure
Concurrent Access	DBMS manages multiple simultaneous users safely
Backup and Recovery	DBMS provides mechanisms to recover data after failures
Reduced Application Development Time	Developers use DBMS services rather than writing data management code

Reading List / References

Ramakrishnan, R. & Gehrke, J. (2003). Database Management Systems, Chapter 1. McGraw-Hill.

Silberschatz, A., Korth, H. F., & Sudarshan, S. (2020). Database System Concepts, Chapter 1. McGraw-Hill.

Connolly, T. & Begg, C. (2015). Database Systems, Chapter 1: Introduction. Pearson.

Activities

Self-Assessment Quiz: 1. Define data, information, and knowledge. Give your own Nigerian example of each. 2. List FOUR problems with file-based data storage systems. 3. What is a DBMS? Name THREE commercial and TWO open-source DBMS products. 4. Why is 'data sharing' an important advantage of the database approach?

Group Activity: In groups of 3-4, identify ONE Nigerian organisation (government, private, or NGO). Research and discuss: (a) What types of data does this organisation manage? (b) What would happen if their database system failed for 24 hours? (c) What DBMS do you think they might use and why? Present a 3-minute summary.