Information Systems Assessment Test II
Information Systems Assessment Test II
CO’s Bloom’s
[Link] Questions
Level
PART A
1. What is RDBMS? CO3 K2
2. List down the advantages of data warehouse. CO3 K1
3. What do you understand by data mining? CO3 K2
4. Define structured query language. CO3 K1
5. State the importance of Data mart. CO3 K1
6. Write a note on the term sniffing. CO3 K2
7. What is HDBMS? CO3 K1
CO’s Bloom’s
[Link] Questions
Level
Part – B
1. What is data mart? What are the reasons for creating a data mart? CO3 K3
Explain the emerging concept and applications of object-oriented CO3
2. K4
database management system.
3. Define data warehouse. Explain its components and benefits. CO3 K3
Discuss the different types of DBMS with their structure and CO3
4. K4
applications.
Describe the need, importance and process of concurrency CO3
5. K4
management.
CO’s Bloom’s
[Link] Questions
Level
Part C
Information systems is transforming business. Comment whether it is
1. CO3 K5
essential for running and managing a business today. What is their
relationship to globalization.
2. Illustrate the construction and working of RDBMS with an example. CO3 K5
Q. CO’s Bloom’s
Questions
No Level
Part A
1 Define disaster management. CO4 K1
2. What is Intranet? CO4 K1
3. Write a short note on role of cyber safety and security. CO4 K2
4. Define IOT. CO4 K2
5. List down the drawbacks of software audit. CO4 K1
6. What is ethical hacking in IT? CO4 K2
7. Write a short note on user interface and design. CO4 K2
List down the ethics one should follow while dealing with information CO4
8. K2
systems.
9. What example can you find for software audit process? CO4 K1
10. Interpret the term computer crimes. CO4 K1
11. How error detection work done in data link. CO4 K1
12. What is system testing? CO4 K2
13. List the ethics to be followed in an information system. CO4 K2
14. Write the significance of wireless networks. CO4 K2
15. How is intranet different from internet. CO4 K1
RDBMS
RDBMS (Relational Database Management System) is a software system that manages
data stored in a relational (table-based) format.
It organizes data into rows and columns (tables) and uses primary and foreign keys to
establish relationships between tables.
Examples: MySQL, Oracle, PostgreSQL, and SQL Server.
Advantages of data warehouse
• Integrated Data: Combines data from multiple sources into a single repository.
• Improved Decision-Making: Provides historical and trend analysis for better
business decisions.
• High Query Performance: Optimized for fast retrieval of large volumes of data.
• Data Consistency: Ensures uniform data formats and definitions.
• Supports Business Intelligence (BI): Useful for reporting, data analysis, and
forecasting.
• Time-Variant Data Storage: Maintains historical data for comparison and trend
analysis.
Data Mining
Data Mining is the process of discovering hidden patterns, correlations, and useful insights
from large datasets using statistical, mathematical, and machine learning techniques.
Example: Predicting customer purchasing behavior from sales data.
Structured query language.
Structured Query Language (SQL) is a standard programming language used to store,
manage, and retrieve data from relational databases.
Functions of SQL:
• DDL (Data Definition Language): CREATE, ALTER, DROP
• DML (Data Manipulation Language): SELECT, INSERT, UPDATE, DELETE
• DCL (Data Control Language): GRANT, REVOKE
Importance of Data mart.
Faster Access: Provides quick access to relevant information for specific departments.
Cost-Effective: Smaller and easier to manage than a full data warehouse.
Improves Decision-Making: Enables focused analysis for specific functions.
Enhances Performance: Reduces load on the main data warehouse.
Term sniffing.
Sniffing refers to the process of monitoring and capturing network traffic to analyze data
transmitted over a network.
HDBMS
HDBMS (Hierarchical Database Management System) organizes data in a tree-like
structure, where each record (child) has only one parent, but a parent can have multiple
children.
Example: IBM’s IMS (Information Management System).
1. Relational DBMS
It is the most common type of DBMS to create, update, and delete relational databases . A
relational database stores and manages data in a tabular form – rows and columns. It is based
on the relational model developed by E.F. Codd in the 1970s.
Every table in a database is connected to the other tables. Each table row is called a tuple or
record, and a collection of records/tuples is called the table's cardinality. Furthermore, each
column is called an attribute or field, and a collection of columns is called the arity of a table.
Pros
• Easy data handling
• Secure and flexible
• Faster data handling
• Fault-tolerance
• Ensures data integrity
• Avoids data redundancy
Cons
• High cost due to expensive hardware and software
• More memory and power are required for scaling
• Only supports structured data
Some famous examples include MySQL, Oracle, and Microsoft SQL Server.
2. Hierarchical DBMS
This database model organizes data in the hierarchy of relationships. The data takes the form
of a tree-like structure, where each record has one parent and multiple children. It is a
collection of tables observed as segments forming a hierarchical relationship. The segment
without any parent is the root node, and the one with no children is the leaf node.
Each parent node can have multiple children, but a child node cannot have multiple parent
nodes. The relationship between nodes is one-to-one and one-to-many.
Pros
• Simple and easy to understand and navigate because of its tree-like structure.
• Ensures data integrity (Any changes in the parent node reflect in the child nodes).
• Data security.
• Easy data sharing.
Cons
• Complex relationships between nodes.
• Removing a parent node removes all child nodes.
• Lacks flexibility.
• No specific implementation standards.
Popular examples include Information Management System (IMS) by IBM and NOMAD by
NCSS.
3. Network DBMS
It is the generalization of the hierarchical type and is based on the network data model. Here,
each record in a database can relate to multiple primary and secondary records, unlike the
hierarchical one. Also, the data takes the structure of a graph rather than a tree. Records
(nodes) take one-to-many and many-to-many relationships.
Pros
• Easier and simpler to design and understand than the hierarchical model.
• Ensures data integrity.
• Data independence.
• Faster and easier data access than the hierarchical model.
Cons
• More complex implementation.
• Inefficient operation management.
• Non-flexible database structure.
Examples of network DBMSes are Integrated Data Store (IDS), Raima Database Manager,
Univac DMS-1100, and IDMS (Integrated Database Management System).
4. Object-Oriented DBMS
Often abbreviated as OODBMS, an object-oriented database management system couples the
concept of object-oriented programming with databases. It stores data in the form of objects,
which are the instances of classes. Each object has different properties and methods.
Pros
• Fast queries with complex data.
• The database structure is close to the programming structure, making the source code
simpler and lighter.
Cons
• Not popular as other DBMSes.
• They do not have a standard query language.
• Difficult to understand.
Popular examples include Versant Object Database, Objectivity/DB, ObjectStore, Caché, and
ZODB.
1. Users of DBMS
• General Users: Interact with the database using application programs.
• Application Programmer (AP): Uses system calls to access the database.
• Database Administrator (DBA): Designs and manages the database schema.
Security, Testing, Error detection, Controls, IOT – RFID, Disaster Management, Computer
Crimes, Cyber Safety and Security- Cryptography, Intranets and Wireless Networks, Software
Audit, Ethics in IT, User Interface and reporting.
Disaster management
It refers to the process of protecting, backing up, and restoring data and IT systems during or
after a disaster (like system failure, cyberattack, or natural calamity).
Intranet
An Intranet is a private network within an organization that uses internet technologies to share
information, resources, and communication tools among employees securely. It helps improve
internal collaboration and access to organizational data.
IOT.
Internet of Things (IoT) is a network of interconnected devices that communicate and exchange
data with each other through the internet without human intervention. These devices—such as
sensors, appliances, and machines—collect and share information to improve efficiency,
automation, and decision-making in various fields like healthcare, transportation, and smart
homes.
Software audit.
Drawbacks of Software Audit:
1. Time-consuming: Conducting a detailed software audit requires significant time and
effort.
2. High cost: It may involve additional expenses for tools, auditors, and resources.
3. Disruption of work: Regular operations can be interrupted during the audit process.
4. Data privacy concerns: Sensitive information may be exposed if not handled securely.
5. Resistance from staff: Employees may feel monitored or threatened, causing
reluctance to cooperate.
Ethical hacking in IT refers to the authorized practice of testing and identifying vulnerabilities
in computer systems, networks, or applications to improve security. Ethical hackers, also
known as “white-hat hackers,” use their skills to find and fix weaknesses before malicious
hackers can exploit them.
User Interface and Design focus on creating the visual layout and interactive elements of a
software application or website. A good UI ensures that users can easily navigate and interact
with the system. It involves designing buttons, menus, icons, and screens that are visually
appealing, consistent, and user-friendly, ultimately enhancing the overall user experience (UX).
Ethics to Follow While Dealing with Information Systems:
1. Honesty: Use and share information truthfully without manipulation.
2. Privacy: Respect the confidentiality of users’ personal and organizational data.
3. Integrity: Avoid unauthorized access or alteration of information.
4. Accountability: Take responsibility for actions and decisions related to information
use.
5. Intellectual property respect: Do not copy or use software, data, or content without
proper authorization.
6. Security: Protect information systems from misuse, theft, or damage.
A company conducts a software license audit to ensure all installed applications are legally
purchased and properly licensed. During the audit, the IT team uses tools to scan all systems,
compares the installed software with purchase records, identifies any unlicensed or outdated
programs, and removes or updates them. This helps the organization stay compliant, avoid legal
issues, and manage software costs effectively.
Computer crimes refer to illegal activities that involve the use of computers or networks to
commit offenses such as stealing data, spreading viruses, hacking systems, identity theft, or
online fraud. These crimes exploit technology to harm individuals, organizations, or
governments by damaging information, disrupting services, or stealing confidential data.
Error detection in the data link layer works by identifying any errors that occur during data
transmission between two nodes in a network. It uses special techniques such as:
1. Parity Check: Adds an extra bit to detect single-bit errors.
2. Checksum: Calculates a value based on data bits and compares it at the receiver’s end.
3. Cyclic Redundancy Check (CRC): Uses polynomial division to detect burst errors. If
an error is found, the receiver requests the sender to retransmit the data, ensuring accurate
communication.
System testing is the process of evaluating an entire integrated software system to ensure it
meets the specified requirements. It tests the complete functionality, performance, and
reliability of the system as a whole to identify any defects before deployment. This type of
testing verifies that all components work together correctly in the real operating environment.
2. WWAN (Wireless Wide Area Network): Covers large areas using mobile networks.
3. WPAN (Wireless Personal Area Network): Short-range networks like Bluetooth.
4. WMAN (Wireless Metropolitan Area Network): Connects multiple LANs in a city.
Features of Wireless Networks:
• Mobility: Users can move freely within the coverage area.
• Scalability: Easy to expand without complex wiring.
• Connectivity: Supports laptops, smartphones, IoT devices, etc.
Advantages of Wireless Networks:
1. Flexibility and mobility for users.
2. Reduced installation cost compared to wired setups.
3. Accessibility in remote areas.
4. Supports modern applications like IoT, cloud computing, and mobile communication.
Limitations:
• Susceptible to interference and signal loss.
• Security risks such as hacking and unauthorized access.
• Slower data speed compared to wired connections.
Significance in Information Management
Both intranets and wireless networks are vital for effective information management:
• Intranets ensure secure, organized, and centralized data access.
• Wireless networks enable real-time communication and data sharing from any location.
Together, they promote efficiency, collaboration, and innovation in modern
organizations.
Different Types of Computer Crimes
With the rapid growth of technology and internet use, crimes involving computers have also
increased. Computer crimes, also known as cybercrimes, refer to illegal activities that use
computers, networks, or digital devices as tools, targets, or both. These crimes can harm
individuals, organizations, and governments by stealing data, damaging systems, or disrupting
services.
Definition
According to the U.S. Department of Justice, computer crime refers to any illegal act requiring
knowledge of computer technology for its perpetration, investigation, or prosecution.
In simple terms, it includes any criminal activity carried out using a computer or network.
Types of Computer Crimes
(a) Hacking
Hacking involves gaining unauthorized access to computer systems or networks. Hackers
exploit system vulnerabilities to steal information, install malware, or disrupt operations.
Example: Breaking into a company’s server to steal customer data.
(b) Phishing
Phishing is a fraudulent attempt to obtain sensitive information such as passwords, credit card
numbers, or bank details by pretending to be a trustworthy entity via email, message, or website.
Example: Fake emails from “banks” asking users to update account details.
(c) Identity Theft
In identity theft, criminals steal someone’s personal information (like Aadhaar number, PAN,
or credit card data) to commit fraud or make unauthorized transactions.
Example: Using another person’s identity to apply for loans or make purchases online.
(d) Virus and Malware Attacks
Malware (malicious software) includes viruses, worms, Trojans, and ransomware designed to
damage, disrupt, or gain control of computer systems.
Example: Ransomware encrypts files and demands payment for decryption.
(e) Cyberstalking and Harassment
This involves using electronic communication to threaten, harass, or stalk individuals. It can
cause emotional distress and violate privacy.
Example: Sending repeated threatening emails or messages.
(f) Software Piracy
Software piracy is the illegal copying, distribution, or use of copyrighted software without
proper authorization.
Example: Downloading and using paid software without purchasing a license.
(g) Online Fraud and Financial Crimes
These crimes involve using the internet to commit financial fraud, such as online banking
scams, credit card fraud, and auction fraud.
Example: Fake online shopping sites collecting money without delivering goods.
(h) Cyber Espionage
Cyber espionage involves unauthorized access to confidential information from governments
or corporations for political or financial gain.
Example: Hacking government databases to steal defense or intelligence information.
(i) Denial of Service (DoS) Attacks
In this attack, hackers flood a network or website with excessive traffic, causing it to crash or
become unavailable to users.
Example: Targeting e-commerce sites during peak seasons to disrupt operations.
(j) Child Exploitation and Cyber Pornography
These involve producing, sharing, or accessing illegal and inappropriate content involving
minors or explicit material. Such activities are serious criminal offenses under cyber laws.
Impact of Computer Crimes
• Financial loss to individuals and organizations.
• Loss of privacy and exposure of personal data.
• Damage to reputation and customer trust.
• National security threats through cyber terrorism and espionage.
Prevention and Control
• Use of firewalls and antivirus software.
• Regular software updates and strong password policies.
• User awareness and cyber ethics education.
• Implementation of cyber laws such as the Information Technology (IT) Act, 2000 in
India.
Different levels (layers) of the Internet of Things (IoT) — detailed discussion
IoT systems are commonly described using layered models. Layers help separate
responsibilities, standardize design and deployment, and clarify where functions (sensing,
transport, processing, application, management) occur. Below I explain the most-used models
(3-, 4-, 5-layer) and a more granular 7-layer viewpoint, giving functions, technologies,
examples, security concerns and challenges for each layer.
1. The classical 3-Layer IoT Model
This is the simplest model and useful for conceptual understanding.
1. Perception (Physical) Layer
o Function: Sensing and actuating — collects real-world data (temperature,
motion, image, etc.) and performs actions (turn motor on/off).
2.
o Technologies: ADCs, microcontrollers (Arduino, ESP32), basic sensor
interfaces (I²C, SPI).
o Examples: Temperature sensor on a smart thermostat; motion sensor in a
security system.
o Security concerns: Physical tampering, false-data injection, insecure firmware.
3. Network (Transport) Layer
o Function: Transfers data from perception layer to processing/storage (and vice-
versa).
o Components: Gateways, routers, cellular modules, Wi-Fi modules.
o Technologies / Protocols: Ethernet, Wi-Fi, Bluetooth, Zigbee, LoRaWAN, NB-
IoT, MQTT, CoAP, HTTP.
o Examples: A Wi-Fi gateway forwarding sensor data to cloud; LoRaWAN
uplink of agricultural sensors.
o Security concerns: Eavesdropping, man-in-the-middle attacks, insecure
wireless links.
4. Application Layer
o Function: Delivers application-specific services (visualization, alerts, control,
analytics) to end users or other systems.
o Components: Cloud servers, dashboards, mobile apps, analytics engines.
o Examples: Smart-home app showing temperature and allowing thermostat
control; predictive maintenance dashboard for factory machines.
o Security concerns: Data privacy, insecure APIs, unauthorized access to
controls.
2. The 4-Layer Model (adds Processing/Edge focus)
Many practical architectures split the transport layer into two or add an explicit processing
layer:
1. Perception Layer — same as above.
2. Transport Layer — moves raw data to processing nodes.
3. Processing (Middleware / Edge & Cloud) Layer
o Function: Aggregation, filtering, local analytics, storage, device management,
protocol translation.
o Components: Edge gateways, fog nodes, cloud backends, message brokers.
o Technologies: Edge computing platforms (EdgeX, AWS Greengrass),
databases (time-series DBs), stream processors.
o Examples: An edge gateway that filters noise from sensor streams and sends
only anomalies to cloud.
o Security concerns: Secure storage, trusted execution, secure updates.
4. Application Layer — same as above.
3. The 5-Layer IoT Model (widely used in academics & industry)
This expands the 4-layer model to include explicit business/management responsibilities.
1. Perception Layer (sensing & actuating)
2. Transport Layer (data transfer)
3. Processing Layer (edge/cloud processing, analytics, storage)
4. Application Layer (user-facing services)
5. Business Layer
o Function: Business logic, decision making, policy, monetization, reporting,
compliance and management.
o Components: BI tools, CRM/ERP integration, policy engines, dashboards for
executives.
o Example: Using predictive-maintenance outputs to schedule maintenance,
update SLAs, and bill customers.
o Concerns: Regulatory compliance, ethical data use, business continuity
planning.
4. A more granular 7-Layer/Reference Model (useful for large systems)
Some reference architectures break functions further:
1. Sensing Layer — raw sensors and actuators.
2. Access Layer — initial connectivity, local networks, device authentication.
3. Edge/Fog Layer — local processing, low-latency control, protocol translation.
4. Transport Layer — WAN, internet, cellular backhaul.
5. Processing & Storage Layer — cloud processing, big data platforms, ML model
training.
6. Application Layer — domain applications, visualizations, APIs.
7. Collaboration & Management Layer — cross-application workflows, device life-
cycle management, security orchestration.
This model helps map where latency, privacy, and reliability requirements should be met (e.g.,
real-time control at edge; heavy analytics in cloud).
5. Common protocols, platforms and where they fit
• Device / perception: I²C/SPI, BLE (Bluetooth Low Energy)
• Local networking: Zigbee, Z-Wave, Wi-Fi
• Wide area transport: LoRaWAN, NB-IoT, LTE/5G
• Messaging & IoT apps: MQTT, CoAP, AMQP, HTTP/REST
• Processing: Edge frameworks (EdgeX, Azure IoT Edge), cloud IoT platforms (AWS
IoT, Azure IoT Hub, Google Cloud IoT)
• Storage & analytics: Time-series DBs (InfluxDB), data lakes, stream processors
(Kafka)
6. Security & privacy considerations layer-wise
• Perception: Secure boot, tamper detection, hardware identity (TPM/secure elements).
• Network/Transport: Strong crypto (TLS/DTLS), secure key management, certificate
rotation.
• Edge/Processing: Access control, container isolation, patch management.
• Application/Business: Data minimization, role-based access, GDPR/Local
compliance, secure APIs.
7. Challenges per layer
• Sensors: Accuracy, power constraints, calibration.
• Connectivity: Coverage, interference, latency, energy usage.
• Edge/Cloud: Scalability, heterogeneity, data integration.
• Application/Business: Interoperability, cost, regulation, ROI.
8. Real-world mapping (short examples)
• Smart home: Perception = temp/humidity sensors; Transport = Wi-Fi; Processing =
local hub + cloud; Application = mobile app; Business = subscription services.
• Industrial IoT: Perception = vibration sensors on motors; Edge = PLC/gateway for
real-time control; Transport = private 5G or wired Ethernet; Processing = cloud
analytics for predictive maintenance; Business = reduced downtime, SLA management.
A software audit is a systematic review and evaluation of software applications, licenses, and
usage within an organization. It ensures compliance with legal, security, and performance
standards.
Process of Software Audit
The software audit process generally involves the following steps:
1. Planning:
Define the purpose, scope, and schedule of the audit. Identify which software and
systems will be reviewed.
2. Data Collection:
Gather information about installed software, license agreements, usage data, and
purchase records.
3. Verification:
Compare actual software installations with licensing terms and organizational policies.
4. Evaluation:
Assess compliance, security vulnerabilities, software performance, and efficiency.
5. Reporting:
Prepare a detailed report highlighting audit findings, including non-compliance issues,
risks, and improvement areas.
6. Corrective Action:
Take necessary actions such as removing unlicensed software, updating systems, or
renewing licenses.
7. Follow-up:
Reassess after corrective actions to ensure compliance and continuous improvement
4. Development Audit:
Examines software development processes, coding standards, and quality assurance
practices.
5. Internal Audit:
Conducted by the organization’s internal team to ensure policy compliance and system
efficiency.
6. External Audit:
Performed by third-party auditors or software vendors to verify compliance with
licensing or regulatory requirements.
Disaster Management refers to the systematic process of preparing for, responding to, and
recovering from disasters such as system failures, data loss, or cyberattacks.
(b) Preparedness
Ethics in Information Technology (IT) refers to the moral values, standards, and principles
that govern the responsible use of technology and information systems. With the increasing
dependence on digital tools and data, maintaining ethical behavior has become crucial to
ensure fairness, privacy, and security in the digital environment.
Honesty and Integrity
IT professionals and users should always act with honesty and integrity. They must provide
accurate information, avoid data manipulation, and report technical issues truthfully.
Misleading users or concealing system faults can lead to serious ethical and legal consequences.
Protecting the privacy and confidentiality of data is one of the most important ethical
responsibilities in IT. Personal and organizational data should not be accessed, shared, or used
without proper authorization. Professionals must ensure that sensitive information is
safeguarded using secure systems and encryption methods.
Ethical IT use includes respecting intellectual property rights. This means using only licensed
software, giving credit to creators of digital content, and avoiding activities like software
piracy, plagiarism, and illegal downloading. Recognizing the efforts of others encourages
creativity and innovation.
Ethics in IT also involve maintaining strong data security. Users should implement measures
like firewalls, passwords, and regular updates to prevent unauthorized access, hacking, or
cyberattacks. Secure handling of data ensures reliability and builds user trust.
Professional Responsibility
IT professionals have a duty to follow organizational policies and industry standards. They
should use technology in a way that benefits society, avoids harm, and promotes digital well-
being. Acting responsibly helps maintain the reputation and efficiency of the organization.
Transparency and accountability are key ethical principles. IT users and professionals must be
open about how data is collected and used. They should take responsibility for their online
actions and decisions, ensuring that they comply with laws and ethical standards.
Ethical behavior in IT means avoiding harmful actions such as hacking, spreading malware,
cyberbullying, or unauthorized surveillance. Misusing technology for personal or financial gain
not only breaches ethics but can also lead to criminal charges.
Ethical IT practices also involve promoting fair access to technology. Every individual,
regardless of background or position, should have equal opportunity to benefit from
technological advancements without facing discrimination or bias.
7. Elucidate computer crimes and their effect on information system protection with
examples.
Computer crimes, also known as cybercrimes, refer to illegal activities that involve the use of
computers, networks, or digital devices to commit offenses. These crimes exploit
vulnerabilities in information systems to steal, damage, or misuse data and digital resources.
As information systems have become central to organizations and individuals, computer crimes
pose serious threats to data security, privacy, and trust.
A computer crime is any criminal activity that directly targets or uses computers and networks
as tools to perform illegal acts. Such crimes can include unauthorized access, data theft,
spreading viruses, hacking, or online fraud. They not only cause financial loss but also disrupt
operations and damage an organization’s reputation.
There are several types of computer crimes.
To prevent such crimes, organizations should install updated antivirus and firewall systems,
conduct regular data backups and security audits, educate employees about cyber safety, use
strong passwords and two-factor authentication, and implement strict access control and
encryption methods.
In conclusion, computer crimes pose a major threat to the integrity, confidentiality, and
availability of information systems. Effective information security practices, continuous
monitoring, and adherence to ethical technology use are essential to safeguard systems from
cyber threats. By developing a strong cybersecurity culture, organizations can protect their
digital assets and maintain user trust. A computer network is a system that connects two or
more computers and devices to share data, resources, and communication. Networks vary in
size, purpose, and geographical coverage. Depending on the range and connectivity, computer
networks can be classified into different types such as PAN, LAN, MAN, WAN, WLAN, and
VPN.
Each type serves specific communication needs and has distinct examples and applications.
1. Personal Area Network (PAN)
A Personal Area Network is the smallest type of network that connects personal devices within
a limited range, typically a few meters. It is mainly used for communication between devices
owned by a single person. Examples include connecting a smartphone to a laptop via Bluetooth
or using a wireless mouse with a computer. PANs are common in homes and personal
workspaces.
2. Local Area Network (LAN)
A Local Area Network connects computers and devices within a limited area such as an office,
school, or building. It allows users to share files, printers, and applications. LANs use Ethernet
cables or Wi-Fi for connectivity. For example, a computer lab in a college or an office where
all systems are connected to a central server is a LAN. LANs are fast, reliable, and easy to
manage.
3. Metropolitan Area Network (MAN)
A Metropolitan Area Network covers a larger area than a LAN but smaller than a WAN,
typically spanning a city or a large campus. It connects multiple LANs to form a bigger
network. For instance, a network connecting various branches of a bank within a city or the
Wi-Fi network spread across a university campus represents a MAN. It helps organizations
communicate efficiently across multiple locations within a city.
4. Wide Area Network (WAN)
A Wide Area Network connects computers and LANs across cities, countries, or even
continents. It uses communication technologies like satellites, fiber optics, or telephone lines.
The best example of a WAN is the Internet, which connects millions of networks globally.
Multinational companies also use WANs to link their offices in different countries, ensuring
smooth data exchange and communication.
5. Wireless Local Area Network (WLAN)
A Wireless Local Area Network is similar to a LAN but operates without physical cables. It
uses Wi-Fi technology to connect multiple devices within a limited range. WLANs are
commonly found in homes, offices, and public places like airports and cafes. For example,
connecting laptops and smartphones through a Wi-Fi router forms a WLAN.
6. Virtual Private Network (VPN)
A Virtual Private Network is a secure network that allows users to access a private network
over the internet. It encrypts data to ensure privacy and security while transferring information.
Employees working remotely often use VPNs to connect safely to their company’s internal
network. For example, organizations use VPNs to allow remote workers to access office servers
securely.
2313MBC106R - INFORMATION SYSTEMS FOR BUSINESS
ERP
ERP is an integrated software system that combines all major business processes—like
finance, HR, production, sales, and inventory—into a single platform to improve efficiency
and information flow across the organization.
Example: Using SAP ERP, a company can manage accounting, inventory, and customer
orders in one system.
Cloud Computing
Advantages:
Example: Using Google Drive or Microsoft Azure to store and manage business files online.
e-business
E-Business (Electronic Business) refers to the use of the Internet and digital technologies to
conduct all types of business activities, including buying, selling, marketing, customer
service, and business communication. It goes beyond e-commerce by covering both front-end
(sales) and back-end (management) operations.
Advantages:
Example: Amazon and Flipkart conduct their entire business operations online, from order
placement to delivery tracking
Pervasive computing
Pervasive computing is a technology where computing devices are embedded into everyday
objects and environments, allowing them to communicate and perform tasks automatically
without direct human interaction. It aims to make technology seamlessly integrated into daily
life.
Features:
Example: Smart homes where lights, fans, and security systems operate automatically using
sensors and the Internet.
Advantages of E-governance
Advantages:
Example: Digital India portals like DigiLocker and e-Seva provide government services
online conveniently.
Business Intelligence (BI) helps organizations collect, analyze, and interpret data to make
better business decisions. It turns raw data into useful insights that support planning and
performance improvement.
Importance:
Data Mining
Data mining is the process of analyzing large sets of data to discover hidden patterns,
relationships, and trends that can help in decision-making. It helps businesses predict future
outcomes and understand customer behavior.
Importance:
Example: A bank using data mining to detect unusual transactions and prevent fraud.
Cloud computing is divided into different types based on the services it provides. The main
types are:
Blockchain Technology
Blockchain is a digital ledger system that records transactions securely and transparently
across a network of computers. Each transaction is stored in a “block,” and these blocks are
linked together in a chain, making the data tamper-proof.
Key Features:
Example: Bitcoin uses blockchain to record and verify cryptocurrency transactions safely.
Applications of Data Mining in Marketing
Data mining helps marketers analyze customer data to make better business decisions and
improve marketing strategies.
Four Applications:
Example: An online store uses data mining to recommend products customers are likely to
buy together.
Example: A software company following CMM Level 5 ensures high-quality and consistent
project delivery
Advantages of ERP
ERP (Enterprise Resource Planning) integrates all business functions into a single system,
improving overall efficiency and coordination.
Four Advantages:
Example: A company using SAP ERP can track inventory, sales, and accounts in one
platform efficiently.
Importance:
Example: An e-commerce company uses data science to predict which products customers
are likely to buy next.
Main Features:
Example: A company using AWS Cloud can easily scale up storage during high-demand
seasons and pay only for what it uses.
Business Intelligence
Business Intelligence (BI) refers to the technologies and tools used to collect, analyze, and
present business data to support better decision-making. It helps organizations turn raw data
into meaningful insights.
Features / Importance:
Example: A company using Power BI to analyze sales data and identify top-performing
products.
Introduction:
An Enterprise Resource Planning (ERP) system integrates all major business functions—
such as finance, human resources, production, sales, and inventory—into a single, unified
information system. The Information System (IS) plays a vital role in making ERP effective
by enabling smooth data flow, communication, and decision-making across departments.
Information systems help integrate various business operations like purchasing, accounting,
manufacturing, and marketing into one centralized platform.
Example: When a sales order is entered, the system automatically updates inventory and
accounting records.
ERP systems supported by information systems provide real-time data to all departments,
ensuring up-to-date information for better decisions.
Example: A manager can instantly view stock levels or financial reports.
3. Improved Decision-Making:
Information systems in ERP collect and analyze large amounts of business data. This helps
managers make data-driven and timely decisions.
Example: BI dashboards in ERP show sales trends and profit margins instantly.
4. Enhanced Communication:
ERP uses information systems to automate repetitive business processes, reducing human
errors and saving time.
Example: Automatic invoice generation and payment tracking.
Information systems maintain a single database, ensuring all departments use accurate and
consistent data.
Example: Changes in supplier details update automatically across purchasing and finance
modules.
ERP systems supported by information systems help store and analyze customer data,
improving customer satisfaction and loyalty.
Example: Tracking customer purchase history to offer personalized services.
8. Resource Optimization:
Information systems ensure optimal use of resources like materials, manpower, and time by
monitoring and analyzing data.
Example: Production scheduling and resource planning in manufacturing.
9. Cost Reduction:
Information systems provide tools for monitoring performance through real-time reports,
dashboards, and analytics.
Example: Monthly financial and sales reports generated automatically.
ERP information systems assist top management in long-term planning by providing insights
into business trends and performance.
Example: Forecasting future sales or planning new product launches.
Information systems ensure data security and compliance with company policies and legal
regulations.
Example: Access control, audit trails, and data encryption features.
ERP systems supported by information systems can grow with the business and adapt to
changes in technology or structure.
Example: Adding new modules like e-commerce or mobile access as the business expands.
Conclusion:
The Information System is the backbone of ERP. It enables integration, efficiency, and
accuracy across all business functions. By providing real-time, reliable, and centralized data,
it supports effective decision-making and enhances overall organizational performance.
Each transaction in blockchain is encrypted and linked to the previous block, making it
extremely difficult to alter or hack.
Example: In banking, blockchain prevents unauthorized access and fraud in transactions.
2. Transparency:
All participants in the blockchain network can view transactions, which promotes
accountability and trust.
Example: Governments using blockchain for transparent public fund tracking.
3. Decentralization:
There is no single controlling authority; all participants share equal control, reducing the risk
of system failure or manipulation.
Example: Cryptocurrencies like Bitcoin operate without a central bank.
4. Data Integrity:
Once data is entered into the blockchain, it cannot be changed or deleted. This ensures
accuracy and trustworthiness.
Example: Maintaining tamper-proof records in supply chain management.
Blockchain removes intermediaries like banks or brokers, which lowers the cost and time of
transactions.
Example: Direct international payments without involving banks.
6. Faster Transactions:
Unlike traditional systems that take days, blockchain can complete transactions in minutes or
seconds.
Example: Real-time settlement of cross-border payments using blockchain.
7. Traceability:
Blockchain helps trace the movement of goods and verify authenticity at every stage.
Example: Tracking food products from farms to stores to ensure quality and origin.
Smart contracts execute automatically when pre-set conditions are met, reducing human
intervention.
Example: Automatic release of payments once goods are delivered.
Some blockchain networks (like Bitcoin) require significant computing power, leading to
high energy usage.
Example: Bitcoin mining consumes large amounts of electricity.
2. Scalability Issues:
As the blockchain grows, transaction processing becomes slower and less efficient.
Example: Ethereum network congestion during peak activity.
3. Lack of Regulation:
Even though blockchain is secure, all participants can see the transaction details, which might
expose sensitive information.
Example: Business transaction details visible to competitors in a shared blockchain.
5. Complexity and High Initial Cost:
Implementing blockchain requires technical expertise and high setup costs, making adoption
challenging for small businesses.
Example: SMEs struggle to implement blockchain-based financial systems.
Introduction:
Business Intelligence (BI) refers to the process of collecting, analyzing, and presenting
business data to support better decision-making. Database technology provides the
foundation for storing, managing, and retrieving this data efficiently.
The relationship between BI and database technology is strong and interdependent — BI
tools rely on databases to extract meaningful insights from raw data.
Databases act as repositories where all business data from various sources—sales, HR,
finance, marketing, and operations—are stored systematically.
Example: A company’s sales records are stored in a database like Oracle or MySQL, which
BI tools later analyze.
2. Data Integration:
BI systems combine data from multiple databases into a central data warehouse for
analysis.
Example: Combining sales data from different branches into a single warehouse for
company-wide reporting.
3. Data Warehousing:
A data warehouse is a large database specifically designed for analysis, not daily operations.
It supports BI by organizing data for easy access and reporting.
Example: A retail chain uses a data warehouse to store five years of sales history for trend
analysis.
Database technologies (like SQL) enable BI tools to retrieve specific data for reports and
dashboards.
Example: SQL queries extract monthly sales data for performance comparison.
BI tools use database-stored data for data mining, identifying hidden patterns, relationships,
and trends.
Example: Analyzing customer purchasing habits to design targeted marketing campaigns.
Databases ensure data consistency, integrity, and accuracy, which are essential for reliable
BI results.
Example: Duplicate or missing records are eliminated in the database before BI reporting.
Modern databases allow real-time data processing, enabling BI systems to provide up-to-
date insights for quick decisions.
Example: Real-time sales dashboards help managers adjust pricing or promotions instantly.
DBMS software like Oracle, SQL Server, and PostgreSQL support BI by handling large
volumes of data, user access, and security.
Example: A bank uses Oracle DBMS with BI tools to track transaction patterns and detect
fraud.
BI tools such as Power BI, Tableau, or SAP BI use data stored in databases to create visual
reports, charts, and dashboards.
Example: A manager views a bar chart of quarterly profits generated from database queries.
Database systems ensure that only authorized users access sensitive data, maintaining data
security for BI processes.
Example: Only senior managers can access payroll or profit data within BI reports.
BI systems use historical and current data from databases to predict future trends through
statistical models and AI algorithms.
Example: Predicting next quarter’s sales using stored customer and product data.
Data Mining – Architecture and Application in Business
The data mining architecture consists of several layers that work together to collect, clean,
store, and analyze data.
1. Data Sources:
This is the first layer that contains raw data from multiple sources such as databases, data
warehouses, flat files, or online data streams.
Example: Customer transactions, sales records, and social media data.
2. Data Warehouse:
Data from various sources is integrated and stored in a data warehouse for analysis. It
provides a unified view of the organization’s data.
Example: A retail company stores data from all its branches in a central warehouse.
Before analysis, data is cleaned to remove errors, duplicates, and inconsistencies, and then
integrated into a common format.
Example: Removing incomplete customer entries or correcting wrong product codes.
This component manages data storage and provides data access using query languages like
SQL. It supports the extraction of relevant data for mining.
This is the core component that performs various data mining techniques like classification,
clustering, regression, and association.
Example: Identifying customer groups based on buying patterns.
6. Pattern Evaluation Module:
It evaluates and filters the patterns found by the mining engine to identify truly useful
insights.
Example: Filtering out patterns that occur by chance and keeping those with business value.
Provides a user-friendly platform for users to interact with the system, visualize data, and
generate reports.
Example: Dashboards in Power BI or Tableau showing mined data insights.
8. Knowledge Base:
Stores background knowledge such as business rules or previous mining results to improve
the accuracy and relevance of analysis.
Example: A marketing company storing previous customer segmentation results for
comparison.
Data mining is widely used across industries to improve productivity, decision-making, and
customer satisfaction.
Helps businesses understand customer behavior, loyalty, and satisfaction to design better
services.
Example: Telecom companies use data mining to predict which customers may leave and
offer them special plans.
Example: Banks use data mining to identify suspicious credit card transactions.
4. Production and Inventory Management:
Applications of E-Business
E-marketing involves promoting products and services online using emails, social media, and
digital advertisements.
Example: Businesses use Google Ads or Instagram promotions to reach global audiences
instantly.
E-business supports online financial transactions using credit/debit cards, net banking, and
mobile wallets.
Example: Paytm, Google Pay, and Razorpay allow secure, instant payments.
E-business helps integrate suppliers, manufacturers, and distributors through online systems
for better coordination.
Example: Dell Computers tracks supplier inventory and delivery through its online SCM
system.
5. Customer Relationship Management (CRM):
CRM systems help businesses maintain and manage relationships with customers by
analyzing their data and feedback.
Example: Companies use Salesforce or Zoho CRM to track customer complaints and improve
service quality.
Businesses use online platforms to buy raw materials, equipment, or services directly from
suppliers.
Example: A car manufacturer purchases parts from multiple suppliers using an e-procurement
portal.
Companies use online learning systems to train employees and customers on new products or
technologies.
Example: IBM and Microsoft provide e-learning portals for skill development and product
training.
Banks use e-business to offer services such as fund transfer, account statements, and loan
applications online.
Example: SBI and HDFC NetBanking allow customers to manage accounts and make
payments online.
9. E-Governance:
Companies use e-business platforms for hiring, performance tracking, and employee
management.
Example: LinkedIn and [Link] help organizations find suitable candidates online.
Chatbots, emails, and live chat systems enable businesses to offer 24/7 customer assistance.
Example: Amazon’s chatbot handles customer queries and order tracking automatically.
Cloud Computing is a technology that allows users to store, access, and manage data and
applications over the internet instead of on local computers or servers.
Example: Using Google Drive to store files or Microsoft 365 for online applications.
IaaS (Infrastructure as a Service) - Provides virtualized hardware like servers, storage, and
networking to users. Businesses can build and manage their own applications.
PaaS (Platform as a Service) - Provides a platform with tools and frameworks for developers
to build, test, and deploy applications without managing hardware.
SaaS (Software as a Service) - Ready-to-use software delivered via the internet. Users don’t
need to install or maintain it.
Public Cloud - Services offered to the general public and shared among users. Managed by
third-party providers
Hybrid Cloud - Combination of public and private clouds, allowing data and apps to move
between them.
1. Data Collection → Gathering raw data from multiple sources (databases, websites,
transactions, etc.)
2. Data Cleaning → Removing duplicates, correcting errors, and handling missing
values.
3. Data Integration → Combining data from different sources into one consistent
format.
4. Data Selection → Choosing relevant data for analysis.
5. Data Transformation → Converting data into a suitable form (normalization,
aggregation, etc.).
6. Data Mining → Applying algorithms to identify patterns and relationships.
7. Pattern Evaluation → Analyzing the discovered patterns to find useful ones.
8. Knowledge Presentation → Presenting findings in an understandable form (charts,
graphs, reports).
Example:
A bank collects data on customer transactions → cleans and integrates it → uses data mining
to find customers likely to default on loans.
Business Intelligence (BI) refers to the technologies, applications, and processes used to
collect, store, analyze, and present business information to support better decision-making.
It helps organizations transform raw data into meaningful insights, allowing them to
identify problems, predict trends, and make informed decisions.
Example: A company like Amazon uses BI to analyze customer buying patterns and
recommend products accordingly.
• BI collects data from various sources like sales records, customer feedback, and
market trends.
• Helps identify issues such as falling sales or increasing costs.
Example: A retail company uses BI tools to find that sales drop in certain regions due
to delayed deliveries.
2. Improving Decision-Making
• BI provides dashboards and reports that summarize large data sets into simple visuals.
• Managers can make faster and more accurate decisions.
Example: A bank uses BI to decide on loan approval policies based on past customer
repayment data.
Introduction
Globalization is the process by which the world becomes more interconnected through trade,
technology, communication, and the exchange of information and ideas. It has made the
world a “global village,” where boundaries between nations are shrinking due to
advancements in information technology and communication systems. In the context of
governance, globalization has influenced how governments interact with citizens and manage
administrative processes, especially through E-Governance initiatives.
My View on Globalization
Globalization has both positive and negative aspects. On one hand, it has accelerated
technological growth, improved access to information, and enhanced international
cooperation. On the other hand, it has increased competition, created dependency on global
technology providers, and raised concerns about data privacy and cultural identity.
E-Governance – An Overview
Example: Online tax filing systems, Aadhaar services, and digital grievance redressal portals
in India.
Impact of Globalization on E-Governance
a) Cybersecurity Threats
Increased dependence on online systems exposes governments to hacking, data theft, and
cyber espionage.
Example: Several countries have faced cyberattacks on their national databases and defense
networks.
b) Digital Divide
Globalization benefits urban and educated populations more, leaving rural or underprivileged
groups behind. This leads to inequality in access to e-governance services.
To balance the benefits of globalization with national interests, governments can adopt the
following measures:
Assuming the role of marketing manager, advertise your firm that provides ERP training and
automation to all sort of customers with their merits and demerits with your own example.
Introduction
As the Marketing Manager of TechSmart Solutions Pvt. Ltd., I am proud to introduce our
company as a leading provider of ERP (Enterprise Resource Planning) training and
automation services to businesses, institutions, and individuals.
In today’s competitive world, every organization aims for efficiency, integration, and real-
time data management. Our firm bridges this gap by offering customized ERP solutions and
hands-on training that empower businesses to achieve digital excellence.
• ERP Training Programs: Practical learning modules for students, professionals, and
enterprises.
• ERP Automation Services: End-to-end ERP implementation that automates business
operations such as accounting, HR, inventory, and customer management.
We have trained over 10,000 learners and automated more than 250 companies across
manufacturing, retail, healthcare, and education sectors.
Example: We helped “GreenMart Retail Pvt. Ltd.” automate its billing, stock, and payroll
systems using SAP ERP, reducing manual errors and improving efficiency by 40%.
• Modules Covered: SAP, Oracle ERP, Tally ERP 9, and Microsoft Dynamics.
• Mode of Delivery: Online, Offline, and Corporate Workshops.
• Target Audience: Students, working professionals, and business owners.
Key Highlights:
Features:
1. Improved Efficiency:
Automates repetitive tasks, reducing time and human error.
Example: A manufacturing client reduced production delays by 30% using our ERP
automation.
2. Better Decision-Making:
ERP provides real-time data and analytics, helping managers make informed decisions.
3. Cost Reduction:
Eliminates duplication and improves resource utilization, saving operational costs.
4. Enhanced Collaboration:
Integrates departments such as HR, Finance, and Sales for seamless communication.
2. Complex Implementation:
Requires proper planning, customization, and skilled manpower to install and maintain
systems.
3. Resistance to Change:
Employees may initially resist automation due to fear of job loss or adaptation difficulties.
Example: When we implemented ERP for a logistics company, employees initially struggled
to adapt to the new system. However, after our training sessions, they became efficient users
and improved overall productivity.
At TechSmart Solutions Pvt. Ltd., we don’t just install ERP systems — we build smart,
connected, and future-ready businesses.
Our ERP training programs empower individuals with skills that make them job-ready,
while our automation services transform traditional businesses into digital leaders.
Our Promise:
Conclusion
ERP training and automation are the backbones of modern business success. As a
marketing manager of TechSmart Solutions Pvt. Ltd., I firmly believe that embracing ERP
technology is not an expense but an investment in growth and efficiency.
By choosing our firm, customers gain not just a system — but a strategic partner dedicated
to their digital transformation journey.