Lesson 3.

1: Introduction to IT Business
Information Technology (IT) in business refers to the use of computers,
networks, software, and other digital tools to manage information and
support decision-making. Businesses today rely on IT to improve efficiency,
reach customers, and stay competitive.

Key Points:

 IT helps businesses store and process information.

 IT improves communication within the organization and with

customers.

 IT enables online transactions (e-commerce).

 IT supports decision-making through data analysis.

Examples:

 Online stores like Shopee or Amazon use IT to sell products, track

inventory, and process payments.

 Banks use IT for online banking apps that allow customers to

transfer money instantly.

 Restaurants use IT systems for online food delivery apps like

Foodpanda or Grab.

Lesson 3.2: Features of IT in Business

IT provides unique features that make businesses more effective. These
features allow organizations to operate faster, more accurately, and at lower
cost.

Key Features:

1. Speed and Efficiency – Computers process large amounts of data

quickly.

o Example: Airline companies use IT to manage thousands of daily

flight bookings instantly.

2. Accuracy – Reduces human errors in business transactions.

o Example: Payroll systems automatically compute salaries, taxes,

and deductions.
 3. Connectivity – Improves communication across locations.

o Example: Companies use Zoom or Microsoft Teams for

meetings with global teams.

4. Automation – Routine tasks can be done by IT systems.

o Example: Supermarkets use self-checkout systems for faster

service.

5. Cost-Effectiveness – Reduces expenses by automating manual tasks.

o Example: Online advertising is cheaper than traditional TV or

print ads.

Lesson 3.3: Intranet, Extranet, Internets as Emerging Tools for

Information Technologies
Businesses use different types of networks to share information securely and
effectively.

Key Concepts:

 Intranet – A private network within an organization.

o Example: A school’s portal where teachers upload grades and

students check announcements.

 Extranet – A private network shared with external partners like

suppliers or customers.

o Example: A manufacturing company giving suppliers access to

its inventory system, so they know when to deliver materials.

 Internet – A global public network that connects everyone worldwide.

o Example: Using email, social media, and e-commerce

platforms to reach customers anywhere in the world.

These tools improve communication, collaboration, and customer

service in modern businesses.

Lesson 3.4: Data Warehouse

A Data Warehouse is a large collection of data gathered from different
sources in a business, stored in one central location. It is mainly used for
analysis and decision-making, not day-to-day operations.

Key Points:

 Stores historical data (past transactions).

 Organizes data from sales, marketing, HR, and finance into one
system.

 Helps managers see the “big picture.”

Examples:

 A retail company can analyze data in its warehouse to find which

products sell best during Christmas.

 A bank can use a data warehouse to study customer loan patterns

and create better financial products.

Lesson 3.5: Data Mining

Data Mining is the process of discovering patterns, trends, and useful
information from large sets of data. It is like “digging for gold” in business
information.

Key Techniques:

 Classification: Sorting data into groups.

o Example: Banks classify customers into low-risk or high-risk

loan applicants.

 Prediction: Forecasting future trends.

o Example: An online store predicting which customers are

likely to buy again.

 Market Basket Analysis: Finding product combinations often bought

together.

o Example: Supermarkets notice people who buy bread also often

buy butter.

Helps businesses make smarter decisions, increase sales, and reduce risks.
Lesson 3.6: Competitive Advantages in Business
A competitive advantage is what makes a business stand out from its
competitors. IT helps businesses gain and keep this advantage.

Ways IT Creates Competitive Advantages:

1. Cost Leadership – Reducing costs with IT systems.

o Example: Lazada uses automated warehouses to lower delivery

costs.

2. Differentiation – Offering unique products/services.

o Example: Netflix recommends personalized movies using data

analysis.

3. Innovation – Creating new products or processes.

o Example: Tesla uses IT in self-driving car technology.

4. Customer Relationship – Building stronger ties with customers.

o Example: Starbucks app gives rewards and personalized offers.

5. Global Reach – Expanding markets worldwide through IT.

o Example: Small businesses using social media marketing to

reach international customers.
Lesson Topic: Types of Information Systems and Their Categories by
Organizational Level

Information Systems (IS) are organized combinations of hardware, software,

data, people, and procedures that collect, process, store, and distribute
information to support decision-making, coordination, control, analysis, and
visualization in an organization.
Different levels of management require different types of information
systems depending on their responsibilities and decision-making needs.

Categories of Information Systems by Organizational Level

Information systems are typically divided into four major categories based on
the level of management they serve:

1. Operational Level Systems

2. Knowledge Level Systems

3. Management Level Systems

4. Strategic Level Systems

Operational Level Systems

Purpose: Support day-to-day business operations, record routine

transactions, and ensure smooth workflow.
Users: Frontline employees, clerks, cashiers, production workers.
Output: Highly detailed reports and transaction records.

Main Type: Transaction Processing System (TPS)

 Records daily business transactions such as sales, receipts, payroll,

and inventory movements.

 Acts as the foundation for higher-level systems.

Examples:

 Point-of-Sale (POS) systems in supermarkets.

 Payroll systems calculating employee salaries.

 Airline reservation systems processing ticket bookings.

  ATM systems for banking transactions.

Real-Life Example:
At McDonald’s, POS systems record every order and automatically update
inventory and sales reports in real-time.

4. Knowledge Level Systems

Purpose: Support knowledge workers and facilitate knowledge sharing and

information management.
Users: Engineers, designers, office staff, analysts.
Output: Documents, databases, and communication platforms.

Main Types:

1. Office Automation Systems (OAS) – improve communication and

document handling.

o Examples: Microsoft Office, Google Workspace.

2. Knowledge Management Systems (KMS) – store and retrieve

organizational knowledge.

o Examples: Wikis, SharePoint, company knowledge bases.

3. Expert Systems (ES) – replicate human expert reasoning for specific

problems.

o Example: Medical diagnosis systems suggesting possible

diseases based on symptoms.

Real-Life Example:
At Toyota, KMS tools store lessons learned from engineers so future projects
avoid repeating design mistakes.

5. Management Level Systems

Purpose: Support middle management in monitoring, controlling, and

decision-making using summarized data from operational systems.
Users: Department heads, supervisors, middle managers.
Output: Reports, summaries, dashboards, exception alerts.

Main Types:
 1. Management Information Systems (MIS) – provide periodic,
structured reports based on TPS data.

o Example: Monthly sales performance reports.

2. Decision Support Systems (DSS) – analyze data and models to

assist in problem-solving and forecasting.

o Example: A system that projects product demand based on sales

trends.

Real-Life Example:
At Coca-Cola, MIS provides regional managers with daily and weekly sales
reports to identify which areas need marketing adjustments.

6. Strategic Level Systems

Purpose: Support senior executives in long-term planning, goal setting, and

overall strategy.
Users: Top management and executives (CEO, CFO, COO).
Output: Summarized, trend-based, and external data analysis.

Main Type: Executive Support System (ESS)

 Combines internal and external information for strategic decisions.

 Provides dashboards, charts, and projections.

Examples:

 Corporate performance dashboards.

 Market trend analysis systems.

 Systems integrating competitor, economic, and policy data.

Real-Life Example:
At Amazon, ESS helps executives analyze global e-commerce trends and
make investment decisions for logistics and technology expansion.

Organizatio Main Real-Life

Type of System Example Use
nal Level Purpose Example

Operational Transaction Record daily Processing POS at

Processing System McDonald’
Organizatio Main Real-Life
Type of System Example Use
nal Level Purpose Example

(TPS) transactions sales, payroll s

Knowledge
Management Manage and
Documentation, Toyota
Knowledge System (KMS), share
design KMS
Office Automation information
System (OAS)

Management
Information System Support Performance
Coca-Cola
Management (MIS), Decision tactical reports,
MIS
Support System decisions forecasts
(DSS)

Support
Executive Support Market trend Amazon
Strategic strategic
System (ESS) analysis ESS
decisions
Lesson Topic: The Role of Database in Application Development

A database is an organized collection of structured information or data

stored electronically. In application development, a database serves as the
core system for storing, managing, and retrieving data used by
software applications.

Core Roles of Databases in Application Development

1. Data Storage

o Applications generate and process large volumes of data (e.g.,

user profiles, transactions, messages).

o Databases provide a structured way to store this data using

tables, records, and fields.

o Example: A banking app stores account balances and transaction

histories in a relational database.

2. Data Retrieval and Querying

o Databases allow applications to fetch specific data using query

languages like SQL.

o Example: An e-commerce website retrieves product details when

a user searches for an item.

3. Data Manipulation

o Applications use databases to perform Create, Read, Update, and

Delete (CRUD) operations.

o Example: A social media app lets users update their profiles or

delete old posts, which are direct database operations.

4. Data Integrity and Consistency

o Databases ensure accuracy and reliability through constraints,

validation, and transactions.

o Example: A payroll system prevents salary duplication by

enforcing data consistency rules.

5. Data Security
 o Databases manage user access, encryption, and authentication
to protect sensitive information.

o Example: Healthcare apps restrict patient data access only to

authorized personnel.

6. Scalability and Performance

o Databases are designed to handle increasing amounts of data

and users without performance drops.

o Example: Streaming platforms like Netflix use distributed

databases to handle millions of user requests simultaneously.

7. Backup and Recovery

o Databases provide mechanisms to back up data and restore it in

case of failure.

o Example: Online learning platforms regularly back up student

records to prevent data loss.

8. Data Relationships

o Relational databases organize data into linked tables to reduce

redundancy and improve organization.

o Example: In a school system, a “Students” table can be linked to

a “Courses” table through a student ID.

9. Integration with Applications

o Databases act as the backend storage for applications,

connected through APIs or frameworks.

o Example: Mobile apps connect to databases via APIs that fetch

data from cloud-based servers.

10. Analytics and Decision-Making

 Databases enable the collection of large datasets for analysis and

reporting.

 Example: A retail store uses database reports to analyze sales trends

and restock inventory efficiently.

Types of Databases Used in Application Development

 1. Relational Databases (SQL)

o Use structured tables and relationships.

o Examples: MySQL, PostgreSQL, Oracle Database.

o Common in: Business systems, ERP, financial apps.

2. NoSQL Databases

o Use flexible schemas; store unstructured or semi-structured

data.

o Examples: MongoDB, Cassandra, Firebase.

o Common in: Real-time apps, IoT, big data systems.

3. Cloud Databases

o Hosted and managed online; accessible via the internet.

o Examples: Amazon RDS, Google Cloud Firestore, Microsoft Azure

SQL.

o Common in: Scalable web and mobile apps.

Real-Life Examples

 Facebook: Uses MySQL and Cassandra to manage user data,

messages, and activity logs.

 Amazon: Uses multiple databases for product catalogs, customer

accounts, and order tracking.

 YouTube: Uses Google’s Bigtable for storing and managing large-scale

video metadata.

 Banking Systems: Store account balances, customer information,

and transaction logs in secure databases.

 Hospital Management Systems: Maintain patient records, billing

data, and appointment schedules.
Lesson Topic: Data Modeling Basics

Data modeling is the process of designing a structured framework that

defines how data is stored, organized, and related within a database system.
It provides a clear blueprint for database creation and application
integration.

The main goal of data modeling is to represent real-world entities and

their relationships logically before physical implementation.

Purpose of Data Modeling

1. Clarify Data Requirements – Ensures all needed data elements are

identified before building the database.

2. Prevent Data Redundancy – Reduces duplication by organizing data

efficiently.

3. Improve Data Integrity – Enforces accuracy and consistency through

structure and rules.

4. Facilitate Communication – Provides a visual reference between

developers, analysts, and stakeholders.

5. Support Database Design – Acts as the foundation for building

relational or NoSQL databases.

Key Components of a Data Model

1. Entities

o Represent real-world objects or concepts to be stored in the

database.

o Example: In a school database, entities can be Students,

Teachers, and Courses.

2. Attributes

o Describe the properties or details of each entity.

o Example: The Student entity may have attributes like

Student_ID, Name, Age, and Grade_Level.

3. Relationships
 o Define how entities are connected or associated with one
another.

o Example: A Student “enrolls in” a Course; a Teacher “teaches” a

Course.

4. Primary Key (PK)

o A unique identifier for each record in a table.

o Example: Student_ID uniquely identifies each student.

5. Foreign Key (FK)

o A field that links records from one table to another, establishing

relationships.

o Example: Course_ID in the Enrollment table refers to Course_ID

in the Courses table.

Types of Data Models

1. Conceptual Data Model

o High-level overview that defines entities and relationships

without technical details.

o Used for initial planning and discussion with stakeholders.

o Example: A simple diagram showing Customers, Orders, and

Products with their relationships.

2. Logical Data Model

o Specifies entities, attributes, and relationships in more detail

using business rules.

o Does not include physical implementation details like storage or

indexing.

o Example: Defines Customer_ID as primary key and Order_ID as

foreign key in relationships.

3. Physical Data Model

o Translates the logical model into actual database structures.

 o Includes tables, column types, indexes, and constraints used by
the DBMS.

o Example: SQL table creation scripts defining data types like

VARCHAR, INT, or DATE.

Common Relationship Types

1. One-to-One (1:1)

o One entity instance relates to only one instance of another.

o Example: Each Employee has one Company ID Card.

2. One-to-Many (1:M)

o One entity relates to multiple instances of another.

o Example: One Teacher teaches many Students.

3. Many-to-Many (M:M)

o Multiple instances of one entity relate to multiple instances of

another.

o Example: Students can enroll in many Courses, and Courses can

have many Students.

o Implemented through an intermediate table, e.g., Enrollment.

Normalization

Normalization is the process of organizing data to reduce redundancy and

improve integrity.

 Example: Splitting a Customer table into separate tables for Customers

and Addresses instead of repeating address data for each customer.

 Common forms:

o 1NF (First Normal Form): Each field contains only atomic

values.

o 2NF (Second Normal Form): No partial dependencies on

primary keys.
 o 3NF (Third Normal Form): No transitive dependencies.

Real-Life Examples

1. E-commerce System

o Entities: Customers, Orders, Products, Payments

o Relationships: Customers place Orders; Orders include Products.

o Data model helps avoid duplicating customer or product data.

2. Hospital Management System

o Entities: Patients, Doctors, Appointments, Billing

o Relationships: Patients schedule Appointments with Doctors.

o Enables efficient patient record management.

3. University Database

o Entities: Students, Courses, Professors, Departments

o Relationships: Students enroll in Courses; Professors belong to

Departments.

o Supports academic record tracking.

4. Banking System

o Entities: Customers, Accounts, Transactions, Branches

o Relationships: Customers own Accounts; Accounts have

Transactions.

o Maintains secure and consistent financial data.

Lesson Topic: Database Life Cycles

The Database Life Cycle (DBLC) is the structured process that defines how
a database is planned, designed, implemented, maintained, and retired.
It provides a systematic approach to ensure that the database meets
business requirements, maintains data integrity, and performs efficiently
throughout its use.

Purpose of the Database Life Cycle

1. Ensures proper planning and organization of data systems.

2. Reduces costly design errors and data inconsistencies.

3. Provides clear documentation for maintenance and future updates.

4. Establishes standards for security, performance, and scalability.

5. Supports business decision-making through reliable data management.

Phases of the Database Life Cycle

1. Database Planning

 Determines the overall purpose, goals, and scope of the database.

 Identifies what problems the database will solve and what data it must
handle.

 Defines roles, budget, resources, and project timelines.

Example:
A hospital identifies the need for a centralized system to manage
patient records, appointments, and billing data.

2. System Definition and Requirements Analysis

 Defines what the system must do and the data it must support.

 Gathers requirements from stakeholders, users, and system analysts.

 Identifies data inputs, outputs, and expected processes.

Example:
In a university system, stakeholders specify that the database must
track student grades, class schedules, and faculty assignments.
3. Database Design

 Translates requirements into a logical and physical structure.

 Includes three levels:

o Conceptual Design: Defines entities, attributes, and

relationships.

o Logical Design: Converts the conceptual model into detailed

table structures and keys.

o Physical Design: Determines how data will be stored, indexed,

and accessed in the database system.
Example:
An online store creates entities such as Customers, Orders,
Products, and Payments, and defines relationships among them.

4. Database Implementation

 Converts the database design into an actual working system using a

DBMS (Database Management System).

 Includes creating tables, defining keys, setting up relationships, and

writing SQL scripts.

 Involves loading initial data and testing performance.

Example:
Developers use MySQL or PostgreSQL to create and populate tables for
an inventory management system.

5. Testing and Evaluation

 Validates that the database meets design and performance

requirements.

 Tests include:

o Functional Testing: Checks CRUD operations.

o Performance Testing: Verifies response time under load.

o Security Testing: Ensures access control and data protection.

Example:
A banking system undergoes stress testing to ensure the
database can handle high transaction volumes without failure.

6. Operation and Maintenance

  Database is deployed for real use.

 Regular monitoring, backups, updates, and optimization occur.

 Handles bug fixes, security patches, and data migrations.

Example:
An airline’s reservation database is monitored continuously to update
flight data, manage customer bookings, and prevent data loss.

7. Database Backup and Recovery

 Implements data protection strategies to prevent loss due to system

failure or human error.

 Regular backups are scheduled; recovery plans are tested.

Example:
A hospital database performs nightly backups to secure patient data
and restore it in case of a system crash.

8. Database Security and Access Control

 Establishes user roles and privileges to prevent unauthorized access.

 Includes encryption, auditing, and compliance with data privacy laws.

Example:
A government database restricts access so that only authorized
personnel can view confidential records.

9. Database Upgrading and Evolution

 As business needs change, databases evolve through version upgrades

or schema modifications.

 Ensures compatibility with new applications and technologies.

Example:
A retail database is upgraded to include online order tracking and real-
time inventory updates.

10. Database Retirement

 Occurs when a database is no longer useful or has been replaced by a

newer system.

 Involves archiving data for legal or historical purposes and securely

deleting unnecessary data.
Example:
 A legacy payroll database is retired after the organization migrates to a
new HR management system.

Real-Life Examples of DBLC in Practice

1. E-commerce Platform (Amazon, Lazada)

o Planning: Define need for product, user, and order management.

o Design: Create schemas for customers, products, and

transactions.

o Implementation: Deploy cloud-based databases like Amazon

RDS.

o Maintenance: Monitor system uptime and user transaction logs.

2. Healthcare System

o Planning: Identify data requirements for patients and doctors.

o Implementation: Use a relational database for patient health

records.

o Maintenance: Securely store and update medical data in

compliance with privacy regulations.

3. Banking Application

o Design: Define entities for accounts, customers, and

transactions.

o Implementation: Use high-availability database clusters.

o Backup: Schedule automated daily backups to prevent financial

data loss.

4. Education Management System

o Design: Model entities for students, teachers, subjects, and

grades.

o Implementation: Use cloud-based databases for scalability.

o Evolution: Add new features for online class attendance tracking.