Computer

1. Key features of computers (2 marks)

• Speed – Executes millions of instructions per second; work that takes days manually is done in seconds.
• Accuracy – Results are error-free; errors arise only from wrong data or wrong instructions (GIGO).
• Storage – Huge volumes of data can be stored and retrieved instantly.
• Automation – Once programmed, a computer works on its own without continuous human attention.
• Versatility – The same machine can do accounting, payroll, design, communication, etc., by changing software.
• Diligence – Works for long hours without fatigue, boredom or loss of concentration.
• Reliability – Consistent performance under the same conditions.
• Cost-effectiveness – Large volumes of work at very low per-unit cost.

2. Why these features make computers valuable to organizations (2 marks)

• Higher productivity – Large volumes of routine work (billing, payroll, inventory, banking transactions) are completed quickly and cheaply.
• Accurate and timely information – Management gets reliable reports and MIS data for planning, control and decision-making.
• Large-scale data handling – Customer records, transactions and ledgers can be stored, searched and analysed, which is impossible manually.
• Better customer service – ATMs, mobile banking, online services and quick counter service are possible only through computers.
• Competitive advantage and growth – Automation reduces cost, improves quality and lets the organization expand without a proportional rise in staff.
• Consistency and control – Uniform procedures, audit trails and reduced fraud through system-based checks.

3. Why an operating system is essential for a computer (6 marks)

Meaning: An operating system (OS) is the master system software that acts as an interface between the user and the computer hardware, and manages all hardware and software resources. Examples: Windows, Linux, UNIX, macOS, Android.

A computer without an operating system is only a collection of electronic circuits — it cannot be used. The OS is essential because of the following functions:

1. Process management – It creates, schedules, suspends and terminates processes, decides which program gets the CPU and for how long (CPU scheduling), and thus enables multitasking and multiprogramming. Without it, only one program could run at a time and the CPU would remain idle most of the time.

2. Memory management – It allocates memory to programs, keeps track of free and used memory, implements virtual memory and paging, and protects one program's memory from another. This prevents programs from overwriting each other and crashing the system.

3. File management – It creates, opens, reads, writes, deletes and organises files and directories, controls access rights and keeps track of where data is stored on disk. Users can handle data only through these services.

4. Device (I/O) management – It controls input/output devices through device drivers, buffers and spools data (e.g. print spooling), and handles interrupts. It hides hardware complexity so that programs need not know the details of each device.

5. Resource allocation and scheduling – It resolves conflicts when several programs demand the same resource (printer, disk, CPU time) and allocates resources fairly and efficiently.

6. User interface – It provides the command-line interface (CLI) or graphical user interface (GUI) through which the user gives commands and receives results. This is the only way an ordinary user can operate the machine.

7. Security and protection – It authenticates users by username and password, defines access permissions, and protects the system from unauthorized access, viruses and accidental damage.

8. Error detection and handling – It detects hardware failures, power problems and program errors, displays messages and takes corrective action so that the system does not stop completely.

9. Job and program execution control – It loads programs into memory, provides system calls and utility programs (copy, format, backup, task manager) and manages the booting process.

Conclusion: The operating system is the soul of the computer. It converts raw hardware into a usable, efficient and secure working environment; therefore every computer must have an operating system to function.

1. Application of Database Management System (2 marks)

A Database Management System (DBMS) is software that stores, organizes, retrieves and controls access to data in a structured form. Its major applications are:

• Banking and finance: maintaining customer accounts, deposits, loans, transactions and audit trails (core banking systems).
• Government and public administration: citizen records, land records, taxation, national ID and payroll systems.
• Business and e-commerce: inventory, sales, customer relationship management (CRM) and order processing.
• Education and health: student records, examination results, hospital patient records and appointment systems.
• Telecom, transport and airlines: billing, call detail records, ticket reservation and scheduling.
• Data warehousing and decision support: supplying clean, integrated data for reporting, analytics and management information systems (MIS).

2. How Information is Converted into Actionable Insights (2 marks)

Raw data becomes actionable insight through a layered process:

Data → Information → Knowledge → Insight → Action

• Data: raw facts collected from transactions and operations.
• Information: data processed, filtered and summarized so that it becomes meaningful (e.g., monthly deposit growth).
• Knowledge: information interpreted using experience, rules and context (e.g., why deposits fell in a certain branch).
• Insight: patterns, trends and causes identified through analysis, comparison and modelling.
• Action: the insight is turned into a decision or intervention (e.g., revise interest rate, tighten credit policy, deploy staff).

Thus a DBMS supplies reliable data; analytics and business intelligence tools convert it into insight; and management judgement converts insight into action.

3. Discussion: Application of DBMS and Conversion of Information into Actionable Insights (6 marks)

a) Role of DBMS in an organization

A DBMS acts as the central repository and control layer for an organization's data. Its major functions are data definition, data manipulation, storage management, security and integrity control, concurrency control, backup and recovery. Because of these functions, data is stored once, shared by many users, and remains consistent and trustworthy.

b) Major areas of application

• Core banking and payment systems: customer master data, account balances, loan accounts, transaction journals, ATM and mobile banking records. A DBMS ensures atomicity of fund transfers so that money is neither lost nor duplicated.
• Government administration: national identity, land ownership, tax records, social security and citizen service delivery. A DBMS supports large volumes, multiple agencies and legal audit requirements.
• Business operations: inventory, procurement, sales, HR and payroll. It enables real-time stock position and accurate salary processing.
• E-commerce and digital services: product catalogue, user profiles, carts, orders and delivery tracking.
• Health and education: patient history, lab reports, student enrolment and results.
• Analytics and decision support: data marts and warehouses built on DBMS feed dashboards, KPIs and predictive models.

c) From data to actionable insight — the process

1. Data capture: transactions, forms, sensors, web logs and mobile apps generate data, which is stored in the DBMS.
2. Data integration and cleaning: data from different systems is extracted, transformed and loaded (ETL) into a warehouse; duplicates, missing values and errors are removed.
3. Storage and organization: relational tables, star or snowflake schemas, and indexing make retrieval fast and consistent.
4. Query and reporting: SQL queries, OLAP cubes and MIS reports summarize performance — for example, branch-wise deposit and credit growth, non-performing loan ratio, or customer churn.
5. Analysis and modelling: statistical analysis, data mining and machine learning detect patterns, correlations and anomalies — for example, identifying customers likely to default or products with rising demand.
6. Visualization and interpretation: dashboards, charts and alerts present the finding in a form managers can grasp quickly.
7. Decision and action: the insight is translated into a concrete decision — revise interest rates, tighten credit appraisal, launch a targeted campaign, reallocate staff or change inventory levels.
8. Feedback loop: the outcome of the action is again captured as data, so the cycle repeats and improves.

d) Illustration

A bank's DBMS records every transaction. ETL consolidates this into a warehouse. Analysis shows that customers in a particular district are withdrawing fixed deposits heavily. The insight — possible loss of confidence or a competing higher interest rate — leads to action: revise the deposit rate and run a retention campaign. The result is again measured, closing the loop.

e) Conclusion

A DBMS is not merely a storage tool; it is the foundation of the data-to-decision chain. It provides accurate, secure and timely data, while analytics, business intelligence and human judgement convert that data into insights and finally into action. Organizations that link DBMS with analytics and decision-making gain faster, evidence-based and more competitive decisions.

What is Web Designing?

Web designing is the process of planning, creating, and arranging the visual layout, structure, and content of a website so that it looks attractive, is easy to navigate, and works properly in a web browser. It combines aesthetics (colours, fonts, images, layout) with functionality (navigation, responsiveness, usability) to deliver a good experience to the user.

Web designing generally covers:

• Layout and structure – where the header, menu, content, sidebar and footer are placed.
• Visual design – colour scheme, typography, images, icons and spacing.
• User experience (UX) and interface (UI) – how easily a visitor finds information and interacts with the site.
• Responsiveness – the site should display correctly on desktop, tablet and mobile.
• Content organisation – grouping and linking pages logically.

Web designing is closely related to web development: designing decides how the site looks and feels, while development (coding with HTML, CSS, JavaScript, PHP etc.) makes it work.

---

Role of HTML in Creating a Website

HTML (HyperText Markup Language) is the standard markup language used to create the basic structure and content of web pages. It is the skeleton (backbone) of every website. Its roles are:

1. Defines the structure of the page HTML uses tags such as <html>, <head>, <body>, <header>, <nav>, <section> and <footer> to divide a page into meaningful parts. Without this structure, a browser cannot organise the content.

2. Displays and formats content Tags like <h1>–<h6>, <p>, <ul>, <ol>, <table>, <img> and <video> place headings, paragraphs, lists, tables, images and multimedia on the page.

3. Creates hyperlinks (the "hypertext" part) The <a href="..."> tag links one page to another, which is what makes a website a web of connected pages and allows navigation between them.

4. Builds forms for user input Tags such as <form>, <input>, <select>, <textarea> and <button> are used to collect data — for example, login details, feedback or online application forms.

5. Provides semantic meaning Semantic tags like <nav>, <article>, <section> and <footer> tell the browser and search engines what each block of content means. This helps SEO (search engine optimisation) and accessibility for screen readers.

6. Acts as the base for CSS and JavaScript HTML is the skeleton, CSS is the skin (styling and layout) and JavaScript is the muscle (behaviour and interactivity). CSS and JavaScript are attached to HTML elements through class, id and <script> tags, so HTML is the foundation on which the whole website is built.

6. Ensures cross-platform compatibility Because HTML is a universal standard maintained by the W3C, an HTML page can be opened in any browser (Chrome, Firefox, Edge) on any device.

Conclusion: HTML provides the fundamental structure and content of a website. It works together with CSS for presentation and JavaScript for interactivity, and no website can be created without it. Hence HTML is rightly called the backbone of web designing.

Role of Operating System in a Computer

The operating system (OS) is the master system software that acts as an interface between the user/application programs and the computer hardware. Its main roles are:

1. Resource manager – It manages and allocates hardware resources among competing programs:

   • CPU/Process management – scheduling of processes, creation and termination of jobs.
   • Memory management – allocation and de-allocation of main memory, virtual memory, protection of one process's memory from another.
   • Device/I-O management – controlling input/output devices through device drivers and buffering/spooling.
   • File management – creating, storing, retrieving, naming and protecting files and directories on storage media.

2. User interface – It provides the environment through which a user interacts with the machine, e.g. command line interface (CLI) or graphical user interface (GUI).

3. Platform for application software – It loads and executes application programs and provides system calls/services (memory, file, I/O) so that programs need not deal with hardware details.

4. Security and protection – It controls access to files and devices through user accounts, passwords and permission levels, and prevents unauthorized use.

5. Error detection and handling – It detects hardware/software errors (e.g. memory failure, device error, illegal instruction) and takes corrective action so that the system keeps running smoothly.

6. Job/Program scheduling and monitoring – It decides which job runs when, keeps track of system status, and manages multitasking/multiuser operation.

In short, without an operating system the hardware cannot be used conveniently — the OS makes the computer usable, efficient, secure and convenient.

इन्टरनेट र इन्ट्रानेटबिच तुलना

बैंकिङ क्षेत्रमा प्रयोगका फाइदाहरू

1. सुरक्षित आन्तरिक सञ्चार — शाखा, डिभिजन तथा प्रधान कार्यालयबिच गोपनीय सूचना इन्ट्रानेटमार्फत सुरक्षित रूपमा आदानप्रदान हुन्छ।
2. छिटो सेवा प्रवाह — ग्राहकको खाता, कर्जा तथा कारोबार विवरण तत्कालै केन्द्रीय डाटाबेसबाट हेर्न सकिने हुँदा सेवा छिटो र भरपर्दो हुन्छ।
3. शाखारहित बैंकिङ तथा अनलाइन सेवा — इन्टरनेटका कारण मोबाइल बैंकिङ, इन्टरनेट बैंकिङ, QR भुक्तानी, विद्युतीय कारोबार सम्भव भएको छ।
4. लागत न्यूनीकरण — कागजी कार्य, हस्तान्तरण तथा भौतिक भ्रमण घटी डिजिटल कार्यप्रवाहबाट खर्च घट्छ।
5. सूचना तथा तथ्याङ्क व्यवस्थापन — केन्द्रीकृत डाटाबेस, नीति, परिपत्र र प्रतिवेदन कर्मचारीले सजिलै पहुँच गर्न सक्छन्।
6. ग्राहक सन्तुष्टि तथा विश्वास — २४सै घण्टा उपलब्ध डिजिटल सेवा र पारदर्शी कारोबारले ग्राहकको विश्वास बढाउँछ।
7. जोखिम नियन्त्रण तथा सुपरिवेक्षण — नेपाल राष्ट्र बैंकजस्ता नियामक निकायले विद्युतीय प्रतिवेदन (CBS, SRP) प्रणालीमार्फत बैंकको वित्तीय अवस्था नियाल्न सक्छन्।

निष्कर्ष: इन्टरनेटले बैंकिङ सेवालाई ग्राहकसम्म पुर्‍याउँछ भने इन्ट्रानेटले आन्तरिक कार्यप्रणालीलाई सुरक्षित, छिटो र व्यवस्थित बनाउँछ। दुवैको समन्वित प्रयोगले आधुनिक डिजिटल बैंकिङलाई सम्भव बनाउँछ।

डेटाबेस म्यानेजमेन्ट सिस्टम (DBMS) को महत्व:

१. डेटा केन्द्रीकृत भण्डारण (Centralized Data Storage): सबै डेटा एकै ठाउँमा राखिने हुँदा डेटाको दोहोरोपन (data redundancy) र असंगति (inconsistency) हट्छ।

२. डेटा सुरक्षा र गोपनीयता (Data Security): प्रयोगकर्तालाई फरक–फरक अधिकार (access rights) दिई अनधिकृत पहुँचबाट डेटा सुरक्षित राख्न सकिन्छ।

३. डेटा स्वतन्त्रता (Data Independence): डेटाको भौतिक संरचना परिवर्तन गर्दा पनि एप्लिकेसन प्रोग्राम परिवर्तन गर्नु नपर्ने।

४. सरल र छिटो खोजी तथा पुनःप्राप्ति (Efficient Query and Retrieval): SQL जस्ता भाषाद्वारा डेटा छिटो खोज्न, मिलाउन र अद्यावधिक गर्न सकिन्छ।

५. बहुप्रयोगकर्ता समर्थन (Multi-user Support): धेरै प्रयोगकर्ताले एकै समयमा डेटा प्रयोग गर्न सक्छन् र concurrency control द्वारा डेटा सही रहन्छ।

६. डेटा अखण्डता (Data Integrity): नियम तथा constraints लागू गरी डेटाको शुद्धता र विश्वसनीयता कायम राखिन्छ।

७. ब्याकअप र रिकभरी (Backup and Recovery): प्रणाली असफल भएमा डेटा पुनः प्राप्त गर्न सकिन्छ।

निष्कर्ष: यसरी DBMS ले डेटालाई व्यवस्थित, सुरक्षित, भरपर्दो र सहज रूपमा व्यवस्थापन गर्न महत्वपूर्ण भूमिका खेल्छ।

सूचना प्रविधि (ICT) नीतिले नेपालको ई-सुशासनलाई निम्नरीतिले प्रभाव पार्दछ :

१. कानुनी तथा संस्थागत आधार निर्माण — सूचना तथा सञ्चार प्रविधि नीति (२०५७ र २०७२), विद्युतीय कारोबार ऐन २०६३, सूचनाको हक सम्बन्धी ऐन २०६४ र डिजिटल नेपाल फ्रेमवर्क २०७६ ले ई-सुशासनका लागि कानुनी वातावरण तयार गरी डिजिटल सेवा विस्तारको बाटो खोलेका छन् ।

२. डिजिटल पूर्वाधार विकास — ब्रोडब्यान्ड, डाटा सेन्टर, राष्ट्रिय परिचयपत्र र अनलाइन भुक्तानी जस्ता पूर्वाधारको विकासमा नीतिले दिशानिर्देशन दिन्छ, जसले सेवा प्रवाहलाई छिटो, पारदर्शी र सुलभ बनाउँछ ।

३. सेवा केन्द्रित शासन — सरकारी सेवा अनलाइनमुखी बनाई नागरिक-सरकार अन्तरक्रिया सहज गराउँछ; जसले जनताको समय, लागत र झन्झट घटाउँछ ।

४. पारदर्शिता र जवाफदेहिता — खुला डाटा, सूचनाको हक र डिजिटल अभिलेखले भ्रष्टाचार नियन्त्रण तथा जवाफदेहिता बढाउन मद्दत गर्छ ।

५. सीमितता — ग्रामीण क्षेत्रमा डिजिटल पहुँचको अभाव, डिजिटल साक्षरताको कमी, पुरानो नीतिगत ढाँचा र कमजोर कार्यान्वयनले ई-सुशासनको प्रभावकारिता सीमित बनाएको छ ।

निष्कर्षमा, ICT नीति ई-सुशासनको आधार हो — यसले संरचना र दिशा दिन्छ, तर कार्यान्वयन र पहुँच सुनिश्चित गर्न थप सुधार आवश्यक छ ।

Computer System

A computer system is an organised combination of hardware, software, data, people and procedures that works together to accept input, process it according to stored instructions, store the results and produce meaningful output. It is not merely the physical machine; it is the complete arrangement in which the machine operates.

Components of a computer system:

The CPU (with its ALU, control unit and registers) executes instructions, primary memory holds programs and data currently in use, and secondary storage keeps data permanently. The system software acts as the bridge between the user and the hardware — and the most important system software is the operating system.

Operating System and Its Functions

An operating system (OS) is the master system software that manages all hardware and software resources of a computer and provides an environment in which application programs run. Examples: Windows, Linux, macOS, Android, UNIX.

Its major functions are:

1. Process Management The OS creates, schedules, suspends and terminates processes. It decides which process gets the CPU and for how long (CPU scheduling), handles process synchronisation and deadlock, and supports multitasking and multiprogramming.

2. Memory Management It allocates memory to programs, keeps track of which part of memory is in use, allocates and deallocates space as needed, and manages virtual memory and paging so that programs larger than physical RAM can still run.

3. File Management It creates, deletes, opens, closes, reads and writes files; organises them into directories/folders; controls access permissions; and keeps track of file locations on the storage device.

4. Device (I/O) Management Through device drivers it controls input/output devices such as keyboard, printer and disk, buffers and spools data (e.g., print spooling), and allocates devices to processes so that they are shared efficiently.

5. Resource Allocation and Scheduling It allocates CPU time, memory, storage and I/O devices among competing processes fairly and efficiently, resolving conflicts when several programs demand the same resource.

6. Process/User Interface It provides the interface through which users interact with the machine — Command Line Interface (CLI) or Graphical User Interface (GUI) — and interprets user commands.

7. Security and Protection It authenticates users through passwords and user accounts, prevents unauthorised access to files and memory, and isolates one process from another so that a faulty program cannot damage the system.

8. Error Detection and Handling It continuously monitors the system, detects hardware and software errors (memory failure, device failure, illegal instruction) and takes corrective action or reports the error to the user.

9. Networking and Communication It manages network connections, enables data exchange between computers, and handles protocols such as TCP/IP.

10. Accounting and Performance Monitoring It records which users use which resources and for how long, which helps in system monitoring, billing and performance tuning.

Conclusion: The operating system is the core of a computer system. By managing processes, memory, files, devices and security, it converts raw hardware into a usable, efficient and safe machine for the user.

Functions and Applications of Word Processing, Spreadsheet and Presentation Software in Business and Management

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

Functions:

• Text creation and editing: typing, inserting, deleting, moving and copying text; find and replace.
• Formatting: font, size, colour, alignment, line spacing, bullets and numbering, styles and themes.
• Page layout: margins, page size, orientation, headers and footers, page numbering, section breaks.
• Insertion of objects: tables, charts, pictures, hyperlinks, equations and symbols.
• Review tools: spell check, grammar check, thesaurus, track changes and comments.
• Templates and mail merge: ready-made formats and bulk personalised letters.
• Printing and sharing: print preview, PDF export, cloud sharing and co-authoring.

Applications in business and management:

• Drafting business letters, memos, notices, circulars and reports.
• Preparing contracts, agreements, proposals and project documents.
• Writing minutes of meetings, agendas and official correspondence.
• Producing company newsletters, brochures, letterheads and certificates.
• Mail merge for bulk letters to customers, employees and shareholders.
• Maintaining records such as employee details, inventory lists and price lists in tabular form.

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

Functions:

• Data entry and storage: rows, columns, cells and worksheets in a workbook.
• Formulas and functions: SUM, AVERAGE, IF, COUNT, VLOOKUP, PMT, etc.
• Formatting: number, currency, percentage, date formats, conditional formatting.
• Charting: bar, pie, line and column charts for visual presentation of data.
• Data management: sorting, filtering, data validation and pivot tables.
• What-if analysis: goal seek, scenario manager and data tables.
• Protection and sharing: password protection, sheet locking and cloud collaboration.

Applications in business and management:

• Preparing budgets, cash flow statements and financial projections.
• Maintaining payroll, salary sheets and tax calculations.
• Inventory control, stock valuation and reorder-level analysis.
• Sales analysis, cost analysis and profitability reports.
• Loan amortisation, EMI calculation and investment appraisal (NPV, IRR).
• Break-even analysis and forecasting for managerial decision-making.
• Preparing attendance sheets, marksheets and performance records.

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

Functions:

• Slide creation: title slides, text slides, bulleted content and speaker notes.
• Design tools: themes, templates, slide masters, colour schemes and fonts.
• Multimedia insertion: pictures, audio, video, charts and SmartArt.
• Animation and transition: entrance, emphasis and exit effects; slide transitions.
• Slide show control: custom shows, timings, rehearsed narration and presenter view.
• Handouts and notes: printing handouts and notes pages for the audience.
• Sharing and delivery: projection, PDF export and online presentation.

Applications in business and management:

• Presenting business plans to investors, banks and funding agencies.
• Product launches, marketing campaigns and sales presentations.
• Training and orientation programmes for employees.
• Board meetings, annual general meetings and management reviews.
• Project progress reports and seminar/workshop presentations.
• Academic and professional conferences, workshops and trainings.

Conclusion

Word processing software handles written communication and documentation, spreadsheet software handles numerical data, calculation and analysis, and presentation software handles effective visual delivery of information. Together they form the core of office automation, improving accuracy, speed, productivity, decision-making and professionalism in business and management.

LAN, WAN and MAN — Major Features and Uses

1. LAN (Local Area Network)

A LAN is a network confined to a small geographical area such as a single office, school, building or campus.

Major features:

• Limited coverage — typically within a building or a few hundred metres.
• High speed — commonly 100 Mbps to 10 Gbps using Ethernet or Wi-Fi.
• Low cost — cabling and hardware are inexpensive; the owner usually owns the whole network.
• Low error rate — short distance means fewer transmission errors.
• Private ownership — managed and maintained by a single organisation.
• Topologies — usually star, bus or ring.

Uses: file and printer sharing in an office, computer labs in schools, internal banking applications within a branch, and Wi-Fi hotspots in a building.

2. MAN (Metropolitan Area Network)

A MAN covers a city or a metropolitan area — larger than a LAN but smaller than a WAN.

Major features:

• City-wide coverage — roughly 5 km to 50 km.
• Moderate to high speed — often uses fibre optics or microwave links.
• Owned by one or a few organisations — sometimes a single private operator or the government.
• Connects multiple LANs — links branches across a city into one network.
• Moderate cost and error rate — between those of LAN and WAN.

Uses: cable TV networks in a city, linking all branches of a bank within a valley, metropolitan e-governance networks, and city-wide ISP services.

3. WAN (Wide Area Network)

A WAN spans a very large area — a country, a continent or the whole world.

Major features:

• Very large coverage — unlimited geographical range.
• Lower speed per link — often relies on leased lines, satellites or public carriers.
• High cost — expensive transmission media and equipment.
• Higher error rate — long distance and many intermediate devices.
• Not owned by a single party — uses public or leased communication lines.
• Uses switching — packet or circuit switching to route data.

Uses: the Internet itself, nationwide banking networks (e.g. connect IPS), airline reservation systems, and multinational corporate networks.

Difference between Internet and Intranet

Note: An intranet may be connected to the Internet through a firewall, but its resources remain restricted to internal users. When part of an intranet is opened to selected outsiders (suppliers, partners), it is called an extranet.

Definition of Database

A database is an organised collection of interrelated data stored in a structured manner so that it can be easily accessed, managed, and updated. It is designed to meet the information requirements of an organisation, allowing multiple users and application programs to share the same data with controlled redundancy and consistent integrity.

More formally, a database is a shared, integrated collection of logically related records or files that represents a self-describing collection of data, stored with as little redundancy as possible and independent of the application programs that use it.

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). It maintains the data dictionary (metadata) that describes the structure and properties of the stored data.

2. Data Manipulation Through a Data Manipulation Language (DML), the DBMS supports retrieval, insertion, deletion, and modification of data. Users can query the database (e.g., using SQL) without knowing how the data is physically stored.

3. Data Storage, Retrieval and Management The DBMS decides how data is physically stored on storage devices and provides efficient mechanisms to store and retrieve it. It handles the interaction between the logical view and the physical storage structures.

4. Data Security and Access Control The DBMS protects data from unauthorised access through user authentication, authorisation, passwords, and privileges. Different users are granted different levels of access to different parts of the database.

5. Data Integrity and Consistency It enforces integrity constraints (entity integrity, referential integrity, domain constraints) so that the data remains accurate and consistent. Transactions are processed so that the database moves from one valid state to another.

6. Concurrency Control When many users access the database simultaneously, the DBMS coordinates their transactions to prevent conflicts and preserve correctness, using techniques such as locking and timestamping.

7. Backup and Recovery The DBMS provides facilities for backup and recovery so that data can be restored in case of system failure, power loss, or accidental damage. It maintains logs to recover the database to a consistent state.

8. Data Independence It separates the logical view of data from its physical storage. Changes in storage structure need not affect application programs (physical data independence), and changes in the logical schema can be made with minimal impact on programs (logical data independence).

9. Utilities and Administration The DBMS offers utilities for backup, recovery, reorganisation, performance monitoring, and reporting. It also supports the role of the Database Administrator (DBA) in tuning and maintaining the system.

Conclusion In short, a DBMS provides a controlled, secure, and efficient environment for defining, storing, retrieving, and managing data, ensuring integrity, consistency, and availability for all authorised users.