Notes - Loksewa Online

Transactions and ACID Properties

Transactions, ACID properties, concurrency control, and deadlocks.

1NF, 2NF, 3NF, and BCNF explained with examples.

Tables, keys, and fundamental SQL statements: SELECT, INSERT, UPDATE, DELETE.

Entities, attributes, relationships, and how to draw ER diagrams.

What is DBMS, advantages over file systems, types of databases.

Arrays, linked lists, stacks, queues, trees, and graphs.

OSI model, TCP/IP, IP addressing, and subnetting.

RAM, ROM, cache, virtual memory, and paging.

Functions, types, and key concepts of operating systems.

Binary, octal, decimal, and hexadecimal number systems.