Raj Prasai

Unit 1: Introduction to Operating System – Exam Revision Notes

1. Introduction to Operating System An Operating System (OS) is a system software that manages computer hardware, software resources, and provides services for computer programs.It acts as an interface between the user and hardware to ensure the system operates efficiently. Examples: Windows, Linux, macOS, Android, UNIX. 2. History and Generations of Operating System Generation Period…

Read More

Unit 5: Solution of Ordinary Differential Equations (ODEs)- Exam Revision Notes

1. Introduction An Ordinary Differential Equation (ODE) is an equation involving one dependent variable and its derivatives with respect to one independent variable. Example:[\frac{dy}{dx} = f(x, y)] Goal → To find approximate (y) for (x = x_1, x_2, …) 2. Methods for Solving ODEs There are two types: 3. Euler’s Method The simplest numerical method….

Read More

Unit 4: Solution of Linear Algebraic Equations – Exam Revision Notes

1. Introduction 2. Existence and Types of Solutions A system ( A\mathbf{x} = \mathbf{b} ) may have: 3. Consistency of Linear System A system is consistent if it has at least one solution, i.e.,[\text{Rank}(A) = \text{Rank}([A|B])]If (\text{Rank}(A) < \text{Rank}([A|B])), then the system is inconsistent. 4. Direct Methods These methods give exact (or nearly exact) solutions…

Read More

Unit 9: Transaction Management and Concurrency Control (Exam Revision Notes)

1. Introduction to Transaction A transaction is a logical unit of work that performs one or more database operations (like INSERT, UPDATE, DELETE) and ensures data integrity.  Example:When transferring money between two accounts: Both operations must succeed together — otherwise, neither should happen. 2. Properties of a Transaction (ACID) Transactions must satisfy ACID properties to…

Read More

 Unit 7: Developing Stored Procedures, DML Triggers, and Indexing (Exam Revision Notes)

1. Introduction As databases grow larger and more complex, performing the same SQL operations repeatedly or ensuring data integrity manually becomes inefficient.To handle this, SQL provides Stored Procedures, Triggers, and Indexes — advanced features to improve automation, consistency, and performance. A. Stored Procedures 1. Definition A Stored Procedure is a precompiled set of SQL statements…

Read More