Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database (DBMS) (Transactions and concurrency control (concurrency control…
Database (DBMS)
Transactions and concurrency control
concurrency control intoduction
database recovvery techniques
ACID properties
log based recovery
transaction isolation levels in DBMS
cocurrency control | types of scheduling
conflict serializability
precedence graph for testing conflict serializability
how to test if two schedules are view equal or not
recoverability of schedules
deadlock in DBMS
starvation in DBMS
concurrency control protocols| lock based protocols
concurrency control protocol | 2 phase locking (2-PL)
thomas wotire rule
concurrency control protocols | timestamp ordering protocols
multiple granularity locking
grpah based protocol
time stamp and dead lock prevention schemes
implemenattion of locking in DBMS
Database design (integrity constraints normal form)
Database normalization| introduction
normal forms
functional dependency and attribute closure
finding attribure closure and candidate keys using functional dependencies
number of possible superkeys
lossless decomposition
dependency preserving decomposition
lossless join and dependency preserving decomposition
DBMS | how to find the highest normal form of a relation
equivalence of functional dependencies
armstrong's anioms in functional dependency
canonical cover
denormalization in database
introduction of 4th adn 5th normal forms
ER- models
database managment system inriduction
3-tier architecture
2-level 3-level
need for DBMS
advantahes of DBMS over filesystem
Data Abdtraction and data independance
ER model
recursive relationships
minization of ER diagram
enhanced ER model
mapping from ER model to relational model
Relational model (Realtionl algenra tuple calculus)
relational model
relational algebra
DBMS | anomalies in reltionam model
Relational model introduction and Codd Rules
Keys in Relational model
rekational Algenra Basic operators
relational Algenra - extended operators
tupple relational calculus
DBMS How to solve relationnal algebra problem for gare -1
DBMS | how to solve relational algebra problems for gate -2
File structire
indexing in databases
file organization
b tree
insert
delete
introduction
bata file indxing
RAID
data ware housing
data mining
data replication
SQL
structed query language
inner vs outer ioin
having vs where clause
database objects
nested Quries in SQL
SQL tutorial