Database Management Systems (CSE2004)

Credits : 4

NOTE:

Two of the best playlists:

Gate Smashers:

https://www.youtube.com/watch?v=kBdlM6hNDAE&list=PLxCzCOWd7aiFAN6I8CuViBuCdJgiOkT2Y

Jenny’s Tutorials (for only module 3): https://www.youtube.com/watch?v=T7AxM7Vqvaw&list=PLdo5W4Nhv31b33kF46f9aFjoJPOkdlsRc

MODULE 1

Module:1 DATABASE SYSTEMS CONCEPTS AND ARCHITECTURE

History and motivation for database systems -characteristics of database approach - Actors on the

scene - Workers behind the scene - Advantages of using DBMS approach– Data Models, Schemas, and Instances– Three-Schema Architecture and Data Independence– The Database

System Environment– Centralized and Client/Server Architectures for DBMSs– Classification of database management systems.

Gate smashers videos Lec-1 to Lec 7

MODULE 2

Module:2 DATA MODELING

Entity Relationship Model : Types of Attributes, Relationship, Structural Constraints - Relational

Model, Relational model Constraints - Mapping ER model to a relational schema - Integrity

constraints

Gate Smashers videos Lec 14 to Lec 19

MODULE 3

Guidelines for Relational Schema – Functional dependency; Normalization, Boyce Codd Normal

Form, Multi-valued dependency and Fourth Normal form; Join dependency and Fifth Normal

form.

Gate Smashers videos Lec 20 to Lec 35

MODULE 4

Module:4 QUERY PROCESSING ANDTRANSACTION PROCESSING

Translating SQL Queries into Relational Algebra - heuristic query optimization - Introduction to

Transaction Processing - Transaction and System concepts – Desirable properties of Transactions

- Characterizing schedules based on recoverability - Characterizing schedules based on

serializability

Gate Smashers videos Lec 42 to Lec 48 and Lec 69 to Lec 81

View serializability:(https://www.youtube.com/watch?v=Vb3G17vaug8)

Conflict serializability:(https://www.youtube.com/watch?v=rjmSWYZnEgk)

MODULE 5

Module:5 CONCURRENCY CONTROL AND RECOVERY TECHNIQUES

Two-Phase Locking Techniques for Concurrency Control – Concurrency Control based on

timestamp – Recovery Concepts – Recovery based on deferred update – Recovery techniques

based on immediate update - Shadow Paging.

Gate Smashers videos Lec 82 to Lec 86

MODULE 6

Module:6 PHYSICAL DATABASE DESIGN

Indexing: Single level indexing, multi-level indexing, dynamic multilevel Indexing

Gate Smashers videos Lec 87to Lec99

MODULE 7

Module:7 RECENT TRENDS - NOSQL DATABASE MANAGEMENT

Introduction, Need of NoSQL, CAP Theorem, different NoSQL data models: Key-value stores, Column families, Document databases, Graph databases

Slides from the faculty are enough.

MODULE 8