UNIT I – INFORMATION

TECHNOLOGY
1. Introduction to IT
 Definition: Information Technology (IT) is the acquisition, processing, storage, and
distribution of information using computers, communication technology, and
microelectronics.
 Scope: Beyond data transfer → includes data recording, formulating, analyzing, and
decision support.
 Components of IT:
1. Computer Technology – Hardware & software for data processing.
2. Communication Technology – Transmission (LAN, WAN, internet,
wireless).
3. Reprographic & Micrographic Tech – Copying, scanning, printing, digital
storage.
 Importance in Business: Enhances productivity, decision-making, global
connectivity, and automation.
📌 Example: Online trading company → uses IT for payments, CRM, logistics, and
real-time data integration.

2. Characteristics of Computers
1. Speed – Millions of instructions per second.
2. Accuracy – Produces exact results if input is correct.
3. Automation – Executes tasks without manual help.
4. Storage – Huge volumes of data stored and retrieved quickly.
5. Versatility – Used in business, education, AI, research.
6. Diligence – No fatigue or loss of concentration.
7. Connectivity – Networked for global communication.

3. Classification of Computers
 By Size: Supercomputer, Mainframe, Minicomputer, Microcomputer (PCs, laptops).
 By Purpose: General-purpose (PCs), Special-purpose (ATMs, embedded).
 By Data Handling: Analog (continuous data), Digital (binary), Hybrid
(combination).
 By Generation:
o 1st (1946–58): Vacuum tubes, machine language, punch cards.
o 2nd (1959–64): Transistors, COBOL/FORTRAN, faster.
o 3rd (1965–70): ICs, OS introduced, monitor/keyboard.
o 4th (1971–today): Microprocessors, GUIs, networking.
o 5th (Present–Future): AI, robotics, quantum computing.

4. Computer System Architecture

  Von Neumann Model: Proposed in 1945 → stores both data and instructions in the
same memory.
 Functional Units:
o Input Unit → Memory Unit → CPU (CU + ALU + Registers) → Output Unit.
 Operation Cycle: Fetch → Decode → Execute → Store.
📌 Type: SISD (Single Instruction, Single Data).

5. Computer Hierarchy (Levels 0–6)

 L0 – Digital Logic Level: Gates (AND, OR, XOR), circuits.
 L1 – Microarchitecture Level: Control of registers, data paths.
 L2 – Instruction Set Architecture (ISA): Interface between hardware & software.
 L3 – Operating System Level: Manages memory, CPU, devices.
 L4 – Assembly Language Level: Mnemonics (MOV, ADD).
 L5 – High-Level Languages: C, Java, Python.
 L6 – User Level: Applications & executable programs.
📌 Explains how computing moves from hardware → user applications.

6. Computer Memory
 Primary Memory:
o RAM (volatile), ROM (non-volatile), Cache (fast).
 Secondary Memory: HDD (magnetic), SSD (flash-based, faster).
 Tertiary Storage: Backup systems (tapes, cloud).
 Virtual Memory: Secondary storage used as RAM extension.
📌 Hierarchy (fastest → slowest): Registers → Cache → RAM → HDD → Backup.

7. Input & Output Devices

 Input Devices: Keyboard, Mouse, Scanner, MICR, OCR, Joystick, Sensors.
 Output Devices: Monitor (LED/LCD), Printers (laser/inkjet), Speakers, Plotters.
📌 Together, I/O devices allow communication between users and computer systems.

8. Number Systems & Arithmetic

 Decimal (Base 10): Digits 0–9.
 Binary (Base 2): Digits 0 & 1 (used by computers).
 Octal (Base 8): Digits 0–7.
 Hexadecimal (Base 16): Digits 0–9, A–F.
 Conversions:
o Binary → Decimal: Multiply digits × powers of 2.
o Decimal → Binary: Divide by 2, record remainders.
 Binary Arithmetic:
o Addition: 1+1 = 10 (carry).
o Subtraction: Borrow rules.
📌 Why Binary?: Simple ON/OFF logic, reliable, used in digitizing
audio/video.
9. Cloud Computing
 Definition (NIST): On-demand network access to shared configurable resources with
minimal management.
 Essential Characteristics:
1. On-demand self-service.
2. Broad network access.
3. Resource pooling.
4. Rapid elasticity (scalability).
5. Measured service (pay-as-you-go).
 Service Models:

o SaaS (Google Docs, Gmail).

o PaaS (Heroku, Google App Engine).
o IaaS (AWS EC2, Azure).
 Deployment Models: Private, Public, Community, Hybrid.
 Challenges: Security, Compliance, Vendor lock-in, Latency.
📌 Diagram: Cloud service triangle.

10. Data Centers

 Definition: Centralized facilities for computing, networking, and data storage.
 Types:
o Public Cloud (AWS, Azure).
o Colocation (3rd party facilities).
o Enterprise (company-owned).
 Key Components:
o CPU, GPU, RAM, Storage (HDD/SSD).
o NICs, Routers, Switches, Firewalls.
o UPS, Backup generators.
o Load balancers, Accelerators.
 Challenges:
o Real-time integration, Latency.
o Security, Regulatory compliance.
o Cost efficiency & scalability.
 Business Continuity: Ensure redundancy, no single point of failure, scaling
(vertical/horizontal), and virtualization.

UNIT II – COMPUTER SOFTWARE

1. Types of Software
 System Software
o Controls and manages hardware operations.
o Provides platform for application software.
 o Examples: Operating System, Device Drivers, Utilities.
 Application Software
o Designed for end-users to perform specific tasks.
o Examples: MS Word, Tally, Photoshop, ERP software.
 Middleware
o Bridge between applications and databases/OS.
o Example: Oracle Fusion Middleware.
 Embedded Software
o Built into hardware devices to control specific functions.
o Examples: Software in washing machines, IoT devices, cars, robots.

2. System Software – Operating System (OS)

 Definition: OS is system software that manages hardware and software resources and
provides an interface for users.
 Functions:
1. Process management (multitasking, CPU scheduling).
2. Memory management (allocation, swapping, virtual memory).
3. File management (organize, retrieve, secure files).
4. Device management (drivers for I/O).
5. Security (authentication, access control).
6. User Interface (CLI/GUI).
 Types of OS:

o Batch, Multiprogramming, Time-sharing, Real-time, Distributed, Mobile.

 Evolution of OS:

1. Serial Processing → 2. Batch Processing → 3. Multiprogramming → 4. Time-

sharing → 5. Distributed → 6. Real-time OS.
 OS Architecture:

o Monolithic: All OS functions in one layer.

o Microkernel: Minimal kernel, services in user mode.
o Exo-kernel: Separates resource protection and management.
o Virtualization OS: Allows multiple OS on same hardware.

3. GUI (Graphical User Interface)

 Definition: A visual interface allowing users to interact via icons, menus, windows.
 Advantages: User-friendly, reduces errors, multitasking, intuitive design.
 Examples: Windows, macOS, Android.

4. Language Translators
 Compiler – Translates entire code at once into machine language; fast execution. (C,
C++).
 Interpreter – Translates line-by-line; slower but better for debugging. (Python,
JavaScript).
  Assembler – Converts assembly code into machine code.
 Compilation Process:
Preprocessor → Compiler → Assembler → Linker → Loader.

5. Programming Languages
 Low-level Languages:
o Machine language (binary code).
o Assembly language (mnemonics).
 High-level Languages: User-friendly, portable. Examples: C, Java, Python.
 4GLs (Fourth Generation): Problem-oriented, database-focused. Examples: SQL,
MATLAB.
 Emerging Languages: Python & R (AI/ML, Data Science), Swift & Kotlin (mobile
apps).

6. Software Development Process

 Steps: Requirement → Design → Coding → Testing → Deployment → Maintenance.
 Models:
o Waterfall: Sequential, simple, rigid.
o Agile: Iterative, flexible, customer feedback.
o RAD (Rapid Application Development): Prototyping + quick iterations.
o DevOps: Combines development & operations; focuses on automation &
continuous delivery.

7. Application Software
 Definition: Programs designed to meet end-user needs.
 Examples: Word processing (MS Word), Spreadsheet (Excel), Graphics (Photoshop),
ERP/CRM software.
 Features of Good Software: Reliable, Efficient, User-friendly, Maintainable,
Portable, Secure.
 Emerging Trends: Cloud-based apps, SaaS, Mobile-first apps, AI-powered
applications.

8. Spreadsheet & Presentation Software

 Spreadsheet (Excel):
o Organizes data in rows & columns.
o Functions: SUM, AVERAGE, IF, VLOOKUP, HLOOKUP.
o Tools: Charts, Pivot tables, Conditional formatting.
o Decision Support System (DSS): Excel used for forecasting, financial
analysis, scenario building.
o History: VisiCalc → Lotus 1-2-3 → MS Excel.
 Presentation Software (PowerPoint):
o Used for slideshows, animations, multimedia.
o Supports business, education, project reporting.
9. Database Management System (DBMS)
 Definition: A software system that manages data in a structured way, reducing
redundancy & improving security.
 Advantages: Centralized storage, less redundancy, security, consistency, easy
retrieval.
 Data Abstraction Levels:
1. Physical (storage level).
2. Logical (tables, schema).
3. View (user level).
 Keys:

o Primary Key: Uniquely identifies a record.

o Candidate Key: Possible choices for PK.
o Alternate Key: Candidate key not chosen as PK.
o Foreign Key: References PK of another table.
 Data Models:
o Hierarchical, Network, Relational, Object-oriented.
 ER Modeling: Entities, Attributes, Relationships (1:1, 1:M, M:N).
 ACID Properties: Atomicity, Consistency, Isolation, Durability.
 BASE Model: Basically Available, Soft-state, Eventual consistency (used in
NoSQL).
 CAP Theorem: A distributed system can only guarantee 2 of 3: Consistency,
Availability, Partition tolerance.

10. SQL (Structured Query Language)

 DDL (Data Definition Language):
o CREATE TABLE, ALTER TABLE, DROP TABLE.
 DML (Data Manipulation Language):
o INSERT, UPDATE, DELETE.
 DQL (Data Query Language):
o SELECT * FROM Students WHERE Marks > 60;
 DCL (Data Control Language):
o GRANT, REVOKE.
 TCL (Transaction Control Language):
o COMMIT, ROLLBACK.