Computer Fundamentals and Applications

Computer System

A computer system is an organised combination of hardware, software, data, procedures and people that works together to accept input, process it according to a set of instructions, store it and produce meaningful output. It is not merely the physical machine; the system becomes functional only when the hardware is driven by software and operated by users.

Components of a computer system

Basic working (block diagram in words)

Input Unit → [ CPU: Control Unit + ALU ] ⇄ Memory Unit → Output Unit
                     ⇅
              Secondary Storage

The input unit accepts data; the control unit fetches and decodes instructions and directs their execution; the ALU performs arithmetic and logical operations; the memory unit holds data and instructions; the output unit presents results; and secondary storage keeps data permanently. The whole operation is coordinated by the operating system, which acts as the interface between the user/application and the hardware.

Functions of an Operating System

An operating system (OS) is the master system software that manages all hardware and software resources of a computer. Its major functions are:

1. Process Management It creates, schedules, suspends, resumes and terminates processes. It decides which process gets the CPU and for how long (CPU scheduling), handles process synchronisation and inter-process communication, and prevents deadlock. This gives the illusion of many programs running at once.

2. Memory Management It keeps track of every byte of main memory — which part is used and by whom. It allocates memory to processes, deallocates it on completion, and implements techniques such as paging, segmentation and virtual memory so that programs larger than physical RAM can run.

3. File Management It creates, opens, reads, writes, deletes and renames files and directories. It maintains the directory structure, controls access permissions (read/write/execute), and maps logical files onto physical disk blocks through the file system (FAT, NTFS, ext4).

4. Device / I/O Management Through device drivers it controls input and output devices, allocates them to processes, buffers and spools data (e.g. print spooling), and handles interrupts. It hides hardware details from applications.

5. Resource Allocation and Scheduling It decides which process gets which resource, when and for how long — using policies such as FCFS, SJF, Round Robin and priority scheduling — so that resources are used efficiently and fairly.

6. Security and Protection It authenticates users through passwords, biometrics or tokens, and enforces access rights on files, memory and devices. It isolates processes from one another so that a faulty program cannot corrupt others.

7. Error Detection and Handling It continuously monitors the system for hardware faults (memory error, device failure, power failure) and software errors (illegal instruction, division by zero) and takes corrective action or reports the error to the user.

8. User Interface It provides the environment through which the user interacts with the machine — Command Line Interface (CLI), Graphical User Interface (GUI) or touch/touchless interface.

9. Networking and Communication It manages network connections, enables data sharing between computers, and handles protocols, remote login and file transfer.

10. Accounting and Performance Monitoring It records which user or process consumes how much CPU time, memory and I/O, which helps in billing, auditing and tuning system performance.

11. Memory Protection and Virtual Machine Support It prevents a process from accessing another process's address space and can present each user with a virtual machine.

Conclusion A computer system is thus a complete man–machine system in which hardware provides the capability, software provides the intelligence and the operating system provides the control. By performing the above functions, the OS converts raw hardware into a convenient, efficient, secure and usable machine.

Introduction

Word processing, spreadsheet and presentation software are the three core categories of general-purpose office application software. In modern business and management they form the basic toolkit for creating, analysing and communicating information, and are used at every level — from clerical record keeping to strategic decision making.

1. Word Processing Software (e.g., MS Word, Google Docs)

Functions:

• Creating, editing, formatting and printing text documents (letters, reports, memos, contracts).
• Editing tools — cut, copy, paste, find and replace, spell and grammar check, thesaurus.
• Formatting — fonts, styles, paragraphs, bullets, tables, headers/footers, page setup.
• Insertion of images, charts, hyperlinks and tables; mail merge for bulk letters.
• Templates and wizards for standard documents; track changes and comments for review.

Applications in business and management:

• Preparation of business letters, quotations, invoices, circulars and notices.
• Drafting reports, proposals, project documents, minutes of meetings and policy manuals.
• Human resource work — appointment letters, job descriptions, performance reports.
• Legal and administrative documentation; mail merge for personalised customer or employee letters.
• Maintaining electronic files that can be stored, retrieved and reused, saving time and paper.

2. Spreadsheet Software (e.g., MS Excel, Google Sheets)

Functions:

• Grid of rows and columns (cells) for entering numeric, text and formula data.
• Automatic calculation through formulas and built-in functions (SUM, AVERAGE, IF, VLOOKUP, PMT).
• What-if analysis, goal seek, scenario and data tables; sorting and filtering.
• Charting and graphing (bar, pie, line, scatter) for visual presentation of data.
• Pivot tables for summarising large data sets; data validation and conditional formatting.

Applications in business and management:

• Accounting — ledgers, trial balance, payroll, depreciation, bank reconciliation.
• Budgeting, forecasting, cash-flow and variance analysis for financial control.
• Inventory management — stock levels, reorder points, valuation (FIFO/LIFO).
• Sales and marketing analysis — sales trends, product-wise performance, commission calculation.
• Loan and investment appraisal (NPV, IRR, EMI) supporting financial decisions.
• Break-even analysis and cost-volume-profit analysis for managerial planning.

3. Presentation Software (e.g., MS PowerPoint, Google Slides)

Functions:

• Creation of slide shows with text, images, charts, audio and video.
• Slide layouts, themes, master slides and animation/transition effects.
• Slide sorter, notes pages and handout printing; slide show delivery with a projector.

Applications in business and management:

• Presenting business plans, annual reports and project proposals to investors, boards and donors.
• Product launches, sales pitches and marketing campaigns.
• Training and orientation programmes for employees; classroom and seminar delivery.
• Management meetings, departmental reviews and performance briefings.
• Enhancing communication through visual aids, which improves understanding and persuasion.

4. Integrated Use and Managerial Significance

• Data flows from spreadsheet analysis into word-processed reports and presentation slides, giving an integrated information system.
• Increases productivity, accuracy, speed and consistency of office work; reduces cost and paperwork.
• Supports planning, organising, staffing, directing, controlling and decision-making functions of management.
• Enables electronic storage, easy updating, sharing and collaboration (cloud-based versions).

Conclusion

Thus, word processing software handles textual communication, spreadsheet software handles numerical analysis and presentation software handles visual communication. Together they constitute an indispensable office automation package that raises the efficiency and effectiveness of business and management at all levels.

Major Features and Uses of LAN, WAN and MAN

1. LAN (Local Area Network)

Features:

• Covers a small geographical area such as a single office, building, school or campus (typically up to a few hundred metres to about 1 km).
• High data transfer speed (typically 100 Mbps to 10 Gbps).
• Low setup and maintenance cost; owned and managed privately by a single organisation.
• Low error rate and high reliability due to short distance and guided media (UTP, coaxial, fibre).
• Uses simple topologies — star, bus, ring, mesh — and technologies such as Ethernet and Wi-Fi.

Uses:

• Sharing files, printers, scanners and other hardware among computers in an office.
• Internal email, database access and application sharing within an organisation.
• Computer labs, cyber cafés, hospital and bank branch networks, campus networks.

2. MAN (Metropolitan Area Network)

Features:

• Spans a city or metropolitan area, generally 5 km to about 50 km.
• Larger than LAN but smaller than WAN; connects several LANs of one city.
• Moderate to high speed (typically 10 Mbps to 100 Mbps, higher with fibre).
• Owned by a single organisation or by a telecom/service provider; moderate cost.
• Uses media such as optical fibre, leased lines, microwave and WiMAX.

Uses:

• Interconnecting branches of a bank, college or government office within a city.
• Cable TV networks and city-wide internet services.
• Metropolitan e-governance and smart-city networks.

3. WAN (Wide Area Network)

Features:

• Covers a very large area — a country, continent or the whole world.
• Connects LANs and MANs across long distances using public/leased telecommunication links.
• Comparatively low speed and high delay; higher error rate.
• Very high setup and maintenance cost; usually owned by telecom carriers or consortiums.
• Uses transmission media such as satellite, microwave, leased lines and public switched telephone network.

Uses:

• Internet, which is the largest WAN.
• Connecting branches of multinational companies, banks and airlines across countries.
• Military networks, national banking networks and remote e-mail/file transfer services.

Difference between Internet and Intranet

Conclusion: LAN, MAN and WAN differ mainly in geographical coverage, speed, cost and ownership. The Internet is a public global network, whereas an intranet is a private organisational network built on the same technology but restricted to internal users.

Definition of Database

A database is an organized, structured collection of interrelated data stored in a computer system in such a way that it can be easily accessed, managed, updated, and retrieved. It is designed to minimize data redundancy and maintain data integrity, consistency, and security. In simple terms, a database is a shared, integrated collection of logically related records or files that serves the data needs of an organization.

According to C. J. Date, "A database is a collection of stored operational data used by the application systems of some particular enterprise."

Functions of a Database Management System (DBMS)

A Database Management System (DBMS) is the software that acts as an interface between the database and its users or application programs. Its major functions are:

1. Data Definition: The DBMS allows users to define the structure of the database — tables, fields, data types, constraints, and relationships — using a Data Definition Language (DDL). This creates the schema or blueprint of the database.

2. Data Manipulation: Through a Data Manipulation Language (DML), the DBMS supports insertion, retrieval, updating, and deletion of data. Users can query the database using languages such as SQL to obtain required information.

3. Data Storage, Retrieval and Management: The DBMS stores data on storage media and provides efficient mechanisms to retrieve it. It handles the physical storage details so users need not know how data is physically arranged.

4. Data Security and Access Control: The DBMS protects data from unauthorized access through authentication (usernames, passwords) and authorization (granting different privileges to different users). It also provides views so that users see only the data relevant to them.

5. Data Integrity and Consistency: The DBMS enforces integrity constraints (such as primary keys, foreign keys, and domain constraints) so that the data entered remains accurate and consistent. It ensures that only valid data is stored.

6. Concurrency Control: When many users access the database simultaneously, the DBMS coordinates their transactions so that they do not interfere with one another, preventing problems such as lost updates and inconsistent reads.

7. Backup and Recovery: The DBMS provides facilities for taking backups and for recovering the database to a consistent state after a failure (power failure, system crash, or media failure), thereby ensuring reliability and durability of data.

8. Data Independence: The DBMS separates the logical view of data from its physical storage. Changes in storage structures or file organization do not require changes in application programs, which reduces maintenance effort.

9. Data Dictionary / Metadata Management: The DBMS maintains a data dictionary (system catalog) that stores metadata — descriptions of tables, columns, users, and privileges — which is used by the system itself for managing and controlling the database.

10. Data Sharing and Multiuser Environment: The DBMS allows many users and application programs to share the same database in a controlled manner, avoiding duplication of data and supporting concurrent, multi-user access.

Conclusion

Thus, a database is an organized collection of interrelated data, and the DBMS is the software that defines, stores, manipulates, protects, and controls that data. By performing these functions, the DBMS ensures that organizational data remains accurate, secure, consistent, and readily available to all authorized users.