.png)
Course Code - ITE1003
Credits - 4
Modules - 8
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 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 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 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 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 PHYSICAL DATABASE DESIGN
Indexing: Single level indexing, multi-level indexing, dynamic multilevel Indexing
Gate Smashers videos Lec 87to Lec 99
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.