🗄️
DBMS
GATE CSEGATE CSE DBMS — ER model, relational algebra, SQL, normalisation, transactions
5 Chapters
01
ER Model
Entities, relationships, attributes, mapping to tables
Entities and AttributesRelationshipsCardinalityER to Relational Mapping+1 more
PYQs Available
5 topics
02
Relational Algebra
Operations on relations — select, project, join
SelectionProjectionCartesian ProductJoin Types+2 more
PYQs Available
6 topics
03
SQL
DDL, DML, queries, joins, subqueries, views
DDL CommandsDML CommandsSELECT QueryJoins+4 more
PYQs Available
8 topics
04
Normalisation
Functional dependencies, 1NF to BCNF, lossless decomposition
Functional Dependencies1NF2NF3NF+3 more
PYQs Available
7 topics
05
Transactions and Concurrency
ACID, schedules, serializability, locking
ACID PropertiesSchedulesConflict SerializabilityTwo-Phase Locking+2 more
PYQs Available
6 topics