Database Management Systems — concepts, SQL, normalisation, and transactions for Lok Sewa exam preparation.
Arrays, linked lists, stacks, queues, trees, and graphs.
What is DBMS, advantages over file systems, types of databases.
Entities, attributes, relationships, and how to draw ER diagrams.
Tables, keys, and fundamental SQL statements: SELECT, INSERT, UPDATE, DELETE.
1NF, 2NF, 3NF, and BCNF explained with examples.
Transactions, ACID properties, concurrency control, and deadlocks.
A complete Lok Sewa preparation guide covering core Computer Science topics required for IT Officer and Computer Operator exams.
History, generations, and classification of computers.
Binary, octal, decimal, and hexadecimal number systems.